ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

752 rows where fips = 38103 sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: deaths, date (date)

state 1

fips 1

  • 38103 · 752 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2501638 2501638 2022-05-13 Wells North Dakota 38103 1018 12
2498380 2498380 2022-05-12 Wells North Dakota 38103 1016 12
2495122 2495122 2022-05-11 Wells North Dakota 38103 1016 12
2491864 2491864 2022-05-10 Wells North Dakota 38103 1016 12
2488606 2488606 2022-05-09 Wells North Dakota 38103 1016 12
2485349 2485349 2022-05-08 Wells North Dakota 38103 1016 12
2482091 2482091 2022-05-07 Wells North Dakota 38103 1016 12
2478833 2478833 2022-05-06 Wells North Dakota 38103 1016 12
2475575 2475575 2022-05-05 Wells North Dakota 38103 1015 12
2472318 2472318 2022-05-04 Wells North Dakota 38103 1015 12
2469062 2469062 2022-05-03 Wells North Dakota 38103 1015 12
2465806 2465806 2022-05-02 Wells North Dakota 38103 1015 12
2462551 2462551 2022-05-01 Wells North Dakota 38103 1015 12
2459295 2459295 2022-04-30 Wells North Dakota 38103 1015 12
2456039 2456039 2022-04-29 Wells North Dakota 38103 1015 12
2452783 2452783 2022-04-28 Wells North Dakota 38103 1014 12
2449527 2449527 2022-04-27 Wells North Dakota 38103 1014 12
2446270 2446270 2022-04-26 Wells North Dakota 38103 1014 12
2443015 2443015 2022-04-25 Wells North Dakota 38103 1014 12
2439759 2439759 2022-04-24 Wells North Dakota 38103 1014 12
2436503 2436503 2022-04-23 Wells North Dakota 38103 1014 12
2433247 2433247 2022-04-22 Wells North Dakota 38103 1014 12
2429991 2429991 2022-04-21 Wells North Dakota 38103 1013 12
2426735 2426735 2022-04-20 Wells North Dakota 38103 1013 12
2423479 2423479 2022-04-19 Wells North Dakota 38103 1013 12
2420222 2420222 2022-04-18 Wells North Dakota 38103 1013 12
2416967 2416967 2022-04-17 Wells North Dakota 38103 1013 12
2413711 2413711 2022-04-16 Wells North Dakota 38103 1013 12
2410455 2410455 2022-04-15 Wells North Dakota 38103 1013 12
2407199 2407199 2022-04-14 Wells North Dakota 38103 1011 12
2403943 2403943 2022-04-13 Wells North Dakota 38103 1011 12
2400688 2400688 2022-04-12 Wells North Dakota 38103 1011 12
2397433 2397433 2022-04-11 Wells North Dakota 38103 1011 12
2394178 2394178 2022-04-10 Wells North Dakota 38103 1011 12
2390922 2390922 2022-04-09 Wells North Dakota 38103 1011 12
2387666 2387666 2022-04-08 Wells North Dakota 38103 1011 12
2384411 2384411 2022-04-07 Wells North Dakota 38103 1011 12
2381156 2381156 2022-04-06 Wells North Dakota 38103 1011 12
2377901 2377901 2022-04-05 Wells North Dakota 38103 1011 12
2374648 2374648 2022-04-04 Wells North Dakota 38103 1011 12
2371396 2371396 2022-04-03 Wells North Dakota 38103 1011 12
2368143 2368143 2022-04-02 Wells North Dakota 38103 1011 12
2364890 2364890 2022-04-01 Wells North Dakota 38103 1011 12
2361636 2361636 2022-03-31 Wells North Dakota 38103 1010 12
2358382 2358382 2022-03-30 Wells North Dakota 38103 1010 12
2355128 2355128 2022-03-29 Wells North Dakota 38103 1010 12
2351875 2351875 2022-03-28 Wells North Dakota 38103 1010 12
2348623 2348623 2022-03-27 Wells North Dakota 38103 1010 12
2345370 2345370 2022-03-26 Wells North Dakota 38103 1010 12
2342117 2342117 2022-03-25 Wells North Dakota 38103 1010 12
2338864 2338864 2022-03-24 Wells North Dakota 38103 1010 12
2335610 2335610 2022-03-23 Wells North Dakota 38103 1010 12
2332356 2332356 2022-03-22 Wells North Dakota 38103 1010 12
2329103 2329103 2022-03-21 Wells North Dakota 38103 1010 12
2325851 2325851 2022-03-20 Wells North Dakota 38103 1010 12
2322598 2322598 2022-03-19 Wells North Dakota 38103 1010 12
2319344 2319344 2022-03-18 Wells North Dakota 38103 1010 12
2316090 2316090 2022-03-17 Wells North Dakota 38103 1011 12
2312837 2312837 2022-03-16 Wells North Dakota 38103 1010 11
2309584 2309584 2022-03-15 Wells North Dakota 38103 1009 11
2306331 2306331 2022-03-14 Wells North Dakota 38103 1009 11
2303080 2303080 2022-03-13 Wells North Dakota 38103 1009 11
2299828 2299828 2022-03-12 Wells North Dakota 38103 1009 11
2296576 2296576 2022-03-11 Wells North Dakota 38103 1007 11
2293324 2293324 2022-03-10 Wells North Dakota 38103 1007 11
2290072 2290072 2022-03-09 Wells North Dakota 38103 1007 11
2286820 2286820 2022-03-08 Wells North Dakota 38103 1007 11
2283568 2283568 2022-03-07 Wells North Dakota 38103 1007 11
2280316 2280316 2022-03-06 Wells North Dakota 38103 1007 11
2277063 2277063 2022-03-05 Wells North Dakota 38103 1007 11
2273810 2273810 2022-03-04 Wells North Dakota 38103 1007 11
2270557 2270557 2022-03-03 Wells North Dakota 38103 1006 11
2267305 2267305 2022-03-02 Wells North Dakota 38103 1006 11
2264053 2264053 2022-03-01 Wells North Dakota 38103 1005 11
2260802 2260802 2022-02-28 Wells North Dakota 38103 1005 11
2257551 2257551 2022-02-27 Wells North Dakota 38103 1005 11
2254300 2254300 2022-02-26 Wells North Dakota 38103 1005 11
2251049 2251049 2022-02-25 Wells North Dakota 38103 1003 11
2247798 2247798 2022-02-24 Wells North Dakota 38103 1001 11
2244547 2244547 2022-02-23 Wells North Dakota 38103 999 11
2241296 2241296 2022-02-22 Wells North Dakota 38103 998 11
2238045 2238045 2022-02-21 Wells North Dakota 38103 996 11
2234794 2234794 2022-02-20 Wells North Dakota 38103 995 11
2231543 2231543 2022-02-19 Wells North Dakota 38103 995 11
2228292 2228292 2022-02-18 Wells North Dakota 38103 995 11
2225041 2225041 2022-02-17 Wells North Dakota 38103 992 11
2221790 2221790 2022-02-16 Wells North Dakota 38103 991 11
2218539 2218539 2022-02-15 Wells North Dakota 38103 991 11
2215288 2215288 2022-02-14 Wells North Dakota 38103 989 11
2212037 2212037 2022-02-13 Wells North Dakota 38103 989 11
2208784 2208784 2022-02-12 Wells North Dakota 38103 989 11
2205531 2205531 2022-02-11 Wells North Dakota 38103 987 11
2202278 2202278 2022-02-10 Wells North Dakota 38103 986 11
2199024 2199024 2022-02-09 Wells North Dakota 38103 989 11
2195770 2195770 2022-02-08 Wells North Dakota 38103 987 11
2192516 2192516 2022-02-07 Wells North Dakota 38103 987 11
2189262 2189262 2022-02-06 Wells North Dakota 38103 985 11
2186009 2186009 2022-02-05 Wells North Dakota 38103 985 11
2182757 2182757 2022-02-04 Wells North Dakota 38103 983 11
2179505 2179505 2022-02-03 Wells North Dakota 38103 983 11

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [ny_times_us_counties] (
   [date] TEXT,
   [county] TEXT,
   [state] TEXT,
   [fips] INTEGER,
   [cases] INTEGER,
   [deaths] INTEGER
);
CREATE INDEX [idx_ny_times_us_counties_state]
    ON [ny_times_us_counties] ([state]);
CREATE INDEX [idx_ny_times_us_counties_county]
    ON [ny_times_us_counties] ([county]);
CREATE INDEX [idx_ny_times_us_counties_fips]
    ON [ny_times_us_counties] ([fips]);
CREATE INDEX [idx_ny_times_us_counties_date]
    ON [ny_times_us_counties] ([date] desc);