ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,538 rows where county = "Rice" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500552 | 2500552 | 2022-05-13 | Rice | Kansas | 20159 | 2614 | 23 |
2500970 | 2500970 | 2022-05-13 | Rice | Minnesota | 27131 | 18357 | 176 |
2497294 | 2497294 | 2022-05-12 | Rice | Kansas | 20159 | 2612 | 23 |
2497712 | 2497712 | 2022-05-12 | Rice | Minnesota | 27131 | 18330 | 176 |
2494036 | 2494036 | 2022-05-11 | Rice | Kansas | 20159 | 2612 | 23 |
2494454 | 2494454 | 2022-05-11 | Rice | Minnesota | 27131 | 18307 | 176 |
2490778 | 2490778 | 2022-05-10 | Rice | Kansas | 20159 | 2612 | 23 |
2491196 | 2491196 | 2022-05-10 | Rice | Minnesota | 27131 | 18278 | 176 |
2487521 | 2487521 | 2022-05-09 | Rice | Kansas | 20159 | 2612 | 23 |
2487939 | 2487939 | 2022-05-09 | Rice | Minnesota | 27131 | 18219 | 176 |
2484263 | 2484263 | 2022-05-08 | Rice | Kansas | 20159 | 2612 | 23 |
2484681 | 2484681 | 2022-05-08 | Rice | Minnesota | 27131 | 18171 | 176 |
2481005 | 2481005 | 2022-05-07 | Rice | Kansas | 20159 | 2612 | 23 |
2481423 | 2481423 | 2022-05-07 | Rice | Minnesota | 27131 | 18171 | 176 |
2477747 | 2477747 | 2022-05-06 | Rice | Kansas | 20159 | 2612 | 23 |
2478165 | 2478165 | 2022-05-06 | Rice | Minnesota | 27131 | 18171 | 176 |
2474489 | 2474489 | 2022-05-05 | Rice | Kansas | 20159 | 2611 | 23 |
2474907 | 2474907 | 2022-05-05 | Rice | Minnesota | 27131 | 18134 | 176 |
2471232 | 2471232 | 2022-05-04 | Rice | Kansas | 20159 | 2611 | 23 |
2471650 | 2471650 | 2022-05-04 | Rice | Minnesota | 27131 | 18103 | 176 |
2467976 | 2467976 | 2022-05-03 | Rice | Kansas | 20159 | 2611 | 23 |
2468394 | 2468394 | 2022-05-03 | Rice | Minnesota | 27131 | 18085 | 176 |
2464721 | 2464721 | 2022-05-02 | Rice | Kansas | 20159 | 2611 | 23 |
2465139 | 2465139 | 2022-05-02 | Rice | Minnesota | 27131 | 18062 | 176 |
2461465 | 2461465 | 2022-05-01 | Rice | Kansas | 20159 | 2611 | 23 |
2461883 | 2461883 | 2022-05-01 | Rice | Minnesota | 27131 | 18052 | 176 |
2458209 | 2458209 | 2022-04-30 | Rice | Kansas | 20159 | 2611 | 23 |
2458627 | 2458627 | 2022-04-30 | Rice | Minnesota | 27131 | 18052 | 176 |
2454953 | 2454953 | 2022-04-29 | Rice | Kansas | 20159 | 2611 | 23 |
2455371 | 2455371 | 2022-04-29 | Rice | Minnesota | 27131 | 18052 | 176 |
2451697 | 2451697 | 2022-04-28 | Rice | Kansas | 20159 | 2611 | 23 |
2452115 | 2452115 | 2022-04-28 | Rice | Minnesota | 27131 | 18041 | 176 |
2448441 | 2448441 | 2022-04-27 | Rice | Kansas | 20159 | 2611 | 23 |
2448859 | 2448859 | 2022-04-27 | Rice | Minnesota | 27131 | 18023 | 175 |
2445185 | 2445185 | 2022-04-26 | Rice | Kansas | 20159 | 2611 | 23 |
2445603 | 2445603 | 2022-04-26 | Rice | Minnesota | 27131 | 18015 | 175 |
2441929 | 2441929 | 2022-04-25 | Rice | Kansas | 20159 | 2611 | 23 |
2442347 | 2442347 | 2022-04-25 | Rice | Minnesota | 27131 | 17996 | 175 |
2438673 | 2438673 | 2022-04-24 | Rice | Kansas | 20159 | 2611 | 23 |
2439091 | 2439091 | 2022-04-24 | Rice | Minnesota | 27131 | 17985 | 175 |
2435417 | 2435417 | 2022-04-23 | Rice | Kansas | 20159 | 2611 | 23 |
2435835 | 2435835 | 2022-04-23 | Rice | Minnesota | 27131 | 17985 | 175 |
2432161 | 2432161 | 2022-04-22 | Rice | Kansas | 20159 | 2611 | 23 |
2432579 | 2432579 | 2022-04-22 | Rice | Minnesota | 27131 | 17985 | 175 |
2428905 | 2428905 | 2022-04-21 | Rice | Kansas | 20159 | 2611 | 23 |
2429323 | 2429323 | 2022-04-21 | Rice | Minnesota | 27131 | 17974 | 175 |
2425649 | 2425649 | 2022-04-20 | Rice | Kansas | 20159 | 2611 | 23 |
2426067 | 2426067 | 2022-04-20 | Rice | Minnesota | 27131 | 17962 | 175 |
2422393 | 2422393 | 2022-04-19 | Rice | Kansas | 20159 | 2611 | 23 |
2422811 | 2422811 | 2022-04-19 | Rice | Minnesota | 27131 | 17953 | 175 |
2419137 | 2419137 | 2022-04-18 | Rice | Kansas | 20159 | 2611 | 23 |
2419555 | 2419555 | 2022-04-18 | Rice | Minnesota | 27131 | 17940 | 175 |
2415881 | 2415881 | 2022-04-17 | Rice | Kansas | 20159 | 2611 | 23 |
2416299 | 2416299 | 2022-04-17 | Rice | Minnesota | 27131 | 17929 | 175 |
2412625 | 2412625 | 2022-04-16 | Rice | Kansas | 20159 | 2611 | 23 |
2413043 | 2413043 | 2022-04-16 | Rice | Minnesota | 27131 | 17929 | 175 |
2409369 | 2409369 | 2022-04-15 | Rice | Kansas | 20159 | 2611 | 23 |
2409787 | 2409787 | 2022-04-15 | Rice | Minnesota | 27131 | 17929 | 175 |
2406113 | 2406113 | 2022-04-14 | Rice | Kansas | 20159 | 2610 | 23 |
2406531 | 2406531 | 2022-04-14 | Rice | Minnesota | 27131 | 17925 | 175 |
2402857 | 2402857 | 2022-04-13 | Rice | Kansas | 20159 | 2610 | 23 |
2403275 | 2403275 | 2022-04-13 | Rice | Minnesota | 27131 | 17917 | 175 |
2399603 | 2399603 | 2022-04-12 | Rice | Kansas | 20159 | 2610 | 23 |
2400021 | 2400021 | 2022-04-12 | Rice | Minnesota | 27131 | 17910 | 175 |
2396347 | 2396347 | 2022-04-11 | Rice | Kansas | 20159 | 2610 | 23 |
2396765 | 2396765 | 2022-04-11 | Rice | Minnesota | 27131 | 17902 | 175 |
2393092 | 2393092 | 2022-04-10 | Rice | Kansas | 20159 | 2610 | 23 |
2393510 | 2393510 | 2022-04-10 | Rice | Minnesota | 27131 | 17898 | 175 |
2389836 | 2389836 | 2022-04-09 | Rice | Kansas | 20159 | 2610 | 23 |
2390254 | 2390254 | 2022-04-09 | Rice | Minnesota | 27131 | 17898 | 175 |
2386580 | 2386580 | 2022-04-08 | Rice | Kansas | 20159 | 2610 | 23 |
2386998 | 2386998 | 2022-04-08 | Rice | Minnesota | 27131 | 17898 | 175 |
2383326 | 2383326 | 2022-04-07 | Rice | Kansas | 20159 | 2609 | 23 |
2383743 | 2383743 | 2022-04-07 | Rice | Minnesota | 27131 | 17894 | 174 |
2380071 | 2380071 | 2022-04-06 | Rice | Kansas | 20159 | 2609 | 23 |
2380488 | 2380488 | 2022-04-06 | Rice | Minnesota | 27131 | 17884 | 174 |
2376816 | 2376816 | 2022-04-05 | Rice | Kansas | 20159 | 2609 | 23 |
2377233 | 2377233 | 2022-04-05 | Rice | Minnesota | 27131 | 17874 | 173 |
2373564 | 2373564 | 2022-04-04 | Rice | Kansas | 20159 | 2609 | 23 |
2373981 | 2373981 | 2022-04-04 | Rice | Minnesota | 27131 | 17867 | 173 |
2370311 | 2370311 | 2022-04-03 | Rice | Kansas | 20159 | 2609 | 23 |
2370728 | 2370728 | 2022-04-03 | Rice | Minnesota | 27131 | 17865 | 173 |
2367058 | 2367058 | 2022-04-02 | Rice | Kansas | 20159 | 2609 | 23 |
2367475 | 2367475 | 2022-04-02 | Rice | Minnesota | 27131 | 17865 | 173 |
2363805 | 2363805 | 2022-04-01 | Rice | Kansas | 20159 | 2609 | 23 |
2364222 | 2364222 | 2022-04-01 | Rice | Minnesota | 27131 | 17865 | 173 |
2360551 | 2360551 | 2022-03-31 | Rice | Kansas | 20159 | 2609 | 22 |
2360968 | 2360968 | 2022-03-31 | Rice | Minnesota | 27131 | 17855 | 173 |
2357297 | 2357297 | 2022-03-30 | Rice | Kansas | 20159 | 2609 | 22 |
2357714 | 2357714 | 2022-03-30 | Rice | Minnesota | 27131 | 17853 | 173 |
2354044 | 2354044 | 2022-03-29 | Rice | Kansas | 20159 | 2609 | 22 |
2354461 | 2354461 | 2022-03-29 | Rice | Minnesota | 27131 | 17851 | 173 |
2350792 | 2350792 | 2022-03-28 | Rice | Kansas | 20159 | 2609 | 22 |
2351209 | 2351209 | 2022-03-28 | Rice | Minnesota | 27131 | 17842 | 173 |
2347539 | 2347539 | 2022-03-27 | Rice | Kansas | 20159 | 2609 | 22 |
2347956 | 2347956 | 2022-03-27 | Rice | Minnesota | 27131 | 17836 | 172 |
2344286 | 2344286 | 2022-03-26 | Rice | Kansas | 20159 | 2609 | 22 |
2344703 | 2344703 | 2022-03-26 | Rice | Minnesota | 27131 | 17836 | 172 |
2341033 | 2341033 | 2022-03-25 | Rice | Kansas | 20159 | 2609 | 22 |
2341450 | 2341450 | 2022-03-25 | Rice | Minnesota | 27131 | 17836 | 172 |
Advanced export
JSON shape: default, array, newline-delimited
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);