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)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
319675 | 319675 | 2020-07-10 | Rice | Kansas | 20159 | 7 | 0 |
320089 | 320089 | 2020-07-10 | Rice | Minnesota | 27131 | 873 | 8 |
316501 | 316501 | 2020-07-09 | Rice | Kansas | 20159 | 4 | 0 |
316914 | 316914 | 2020-07-09 | Rice | Minnesota | 27131 | 862 | 8 |
313327 | 313327 | 2020-07-08 | Rice | Kansas | 20159 | 4 | 0 |
313740 | 313740 | 2020-07-08 | Rice | Minnesota | 27131 | 859 | 8 |
310157 | 310157 | 2020-07-07 | Rice | Kansas | 20159 | 4 | 0 |
310570 | 310570 | 2020-07-07 | Rice | Minnesota | 27131 | 848 | 8 |
306989 | 306989 | 2020-07-06 | Rice | Kansas | 20159 | 4 | 0 |
307402 | 307402 | 2020-07-06 | Rice | Minnesota | 27131 | 844 | 7 |
303822 | 303822 | 2020-07-05 | Rice | Kansas | 20159 | 4 | 0 |
304235 | 304235 | 2020-07-05 | Rice | Minnesota | 27131 | 842 | 7 |
300658 | 300658 | 2020-07-04 | Rice | Kansas | 20159 | 4 | 0 |
301071 | 301071 | 2020-07-04 | Rice | Minnesota | 27131 | 835 | 7 |
297496 | 297496 | 2020-07-03 | Rice | Kansas | 20159 | 4 | 0 |
297908 | 297908 | 2020-07-03 | Rice | Minnesota | 27131 | 835 | 7 |
294338 | 294338 | 2020-07-02 | Rice | Kansas | 20159 | 4 | 0 |
294750 | 294750 | 2020-07-02 | Rice | Minnesota | 27131 | 827 | 7 |
291184 | 291184 | 2020-07-01 | Rice | Kansas | 20159 | 4 | 0 |
291596 | 291596 | 2020-07-01 | Rice | Minnesota | 27131 | 824 | 7 |
288034 | 288034 | 2020-06-30 | Rice | Kansas | 20159 | 4 | 0 |
288445 | 288445 | 2020-06-30 | Rice | Minnesota | 27131 | 809 | 7 |
284885 | 284885 | 2020-06-29 | Rice | Kansas | 20159 | 4 | 0 |
285295 | 285295 | 2020-06-29 | Rice | Minnesota | 27131 | 804 | 6 |
281740 | 281740 | 2020-06-28 | Rice | Kansas | 20159 | 4 | 0 |
282150 | 282150 | 2020-06-28 | Rice | Minnesota | 27131 | 793 | 4 |
278592 | 278592 | 2020-06-27 | Rice | Kansas | 20159 | 4 | 0 |
279002 | 279002 | 2020-06-27 | Rice | Minnesota | 27131 | 783 | 4 |
275444 | 275444 | 2020-06-26 | Rice | Kansas | 20159 | 4 | 0 |
275854 | 275854 | 2020-06-26 | Rice | Minnesota | 27131 | 780 | 4 |
272301 | 272301 | 2020-06-25 | Rice | Kansas | 20159 | 4 | 0 |
272711 | 272711 | 2020-06-25 | Rice | Minnesota | 27131 | 771 | 4 |
269164 | 269164 | 2020-06-24 | Rice | Kansas | 20159 | 4 | 0 |
269574 | 269574 | 2020-06-24 | Rice | Minnesota | 27131 | 761 | 4 |
266032 | 266032 | 2020-06-23 | Rice | Kansas | 20159 | 4 | 0 |
266441 | 266441 | 2020-06-23 | Rice | Minnesota | 27131 | 758 | 4 |
262904 | 262904 | 2020-06-22 | Rice | Kansas | 20159 | 4 | 0 |
263315 | 263315 | 2020-06-22 | Rice | Minnesota | 27131 | 754 | 4 |
259777 | 259777 | 2020-06-21 | Rice | Kansas | 20159 | 4 | 0 |
260186 | 260186 | 2020-06-21 | Rice | Minnesota | 27131 | 748 | 4 |
256651 | 256651 | 2020-06-20 | Rice | Kansas | 20159 | 4 | 0 |
257060 | 257060 | 2020-06-20 | Rice | Minnesota | 27131 | 743 | 4 |
253531 | 253531 | 2020-06-19 | Rice | Kansas | 20159 | 4 | 0 |
253940 | 253940 | 2020-06-19 | Rice | Minnesota | 27131 | 740 | 4 |
250416 | 250416 | 2020-06-18 | Rice | Kansas | 20159 | 4 | 0 |
250825 | 250825 | 2020-06-18 | Rice | Minnesota | 27131 | 733 | 4 |
247304 | 247304 | 2020-06-17 | Rice | Kansas | 20159 | 4 | 0 |
247713 | 247713 | 2020-06-17 | Rice | Minnesota | 27131 | 701 | 3 |
244191 | 244191 | 2020-06-16 | Rice | Kansas | 20159 | 4 | 0 |
244600 | 244600 | 2020-06-16 | Rice | Minnesota | 27131 | 697 | 3 |
241080 | 241080 | 2020-06-15 | Rice | Kansas | 20159 | 4 | 0 |
241489 | 241489 | 2020-06-15 | Rice | Minnesota | 27131 | 694 | 3 |
237971 | 237971 | 2020-06-14 | Rice | Kansas | 20159 | 4 | 0 |
238380 | 238380 | 2020-06-14 | Rice | Minnesota | 27131 | 688 | 3 |
234864 | 234864 | 2020-06-13 | Rice | Kansas | 20159 | 4 | 0 |
235273 | 235273 | 2020-06-13 | Rice | Minnesota | 27131 | 688 | 3 |
231758 | 231758 | 2020-06-12 | Rice | Kansas | 20159 | 4 | 0 |
232167 | 232167 | 2020-06-12 | Rice | Minnesota | 27131 | 685 | 3 |
228655 | 228655 | 2020-06-11 | Rice | Kansas | 20159 | 4 | 0 |
229063 | 229063 | 2020-06-11 | Rice | Minnesota | 27131 | 604 | 3 |
225553 | 225553 | 2020-06-10 | Rice | Kansas | 20159 | 4 | 0 |
225961 | 225961 | 2020-06-10 | Rice | Minnesota | 27131 | 594 | 3 |
222458 | 222458 | 2020-06-09 | Rice | Kansas | 20159 | 4 | 0 |
222863 | 222863 | 2020-06-09 | Rice | Minnesota | 27131 | 593 | 3 |
219363 | 219363 | 2020-06-08 | Rice | Kansas | 20159 | 4 | 0 |
219768 | 219768 | 2020-06-08 | Rice | Minnesota | 27131 | 587 | 3 |
216271 | 216271 | 2020-06-07 | Rice | Kansas | 20159 | 4 | 0 |
216676 | 216676 | 2020-06-07 | Rice | Minnesota | 27131 | 576 | 3 |
213184 | 213184 | 2020-06-06 | Rice | Kansas | 20159 | 4 | 0 |
213588 | 213588 | 2020-06-06 | Rice | Minnesota | 27131 | 565 | 3 |
210099 | 210099 | 2020-06-05 | Rice | Kansas | 20159 | 4 | 0 |
210504 | 210504 | 2020-06-05 | Rice | Minnesota | 27131 | 524 | 3 |
207018 | 207018 | 2020-06-04 | Rice | Kansas | 20159 | 4 | 0 |
207423 | 207423 | 2020-06-04 | Rice | Minnesota | 27131 | 483 | 3 |
203937 | 203937 | 2020-06-03 | Rice | Kansas | 20159 | 4 | 0 |
204342 | 204342 | 2020-06-03 | Rice | Minnesota | 27131 | 480 | 2 |
200860 | 200860 | 2020-06-02 | Rice | Kansas | 20159 | 4 | 0 |
201265 | 201265 | 2020-06-02 | Rice | Minnesota | 27131 | 467 | 2 |
197788 | 197788 | 2020-06-01 | Rice | Kansas | 20159 | 4 | 0 |
198192 | 198192 | 2020-06-01 | Rice | Minnesota | 27131 | 462 | 2 |
194718 | 194718 | 2020-05-31 | Rice | Kansas | 20159 | 4 | 0 |
195121 | 195121 | 2020-05-31 | Rice | Minnesota | 27131 | 462 | 2 |
191650 | 191650 | 2020-05-30 | Rice | Kansas | 20159 | 4 | 0 |
192053 | 192053 | 2020-05-30 | Rice | Minnesota | 27131 | 452 | 2 |
188586 | 188586 | 2020-05-29 | Rice | Kansas | 20159 | 4 | 0 |
188989 | 188989 | 2020-05-29 | Rice | Minnesota | 27131 | 438 | 2 |
185528 | 185528 | 2020-05-28 | Rice | Kansas | 20159 | 4 | 0 |
185931 | 185931 | 2020-05-28 | Rice | Minnesota | 27131 | 423 | 2 |
182474 | 182474 | 2020-05-27 | Rice | Kansas | 20159 | 4 | 0 |
182876 | 182876 | 2020-05-27 | Rice | Minnesota | 27131 | 411 | 2 |
179429 | 179429 | 2020-05-26 | Rice | Kansas | 20159 | 4 | 0 |
179830 | 179830 | 2020-05-26 | Rice | Minnesota | 27131 | 396 | 2 |
176385 | 176385 | 2020-05-25 | Rice | Kansas | 20159 | 4 | 0 |
176786 | 176786 | 2020-05-25 | Rice | Minnesota | 27131 | 386 | 2 |
173341 | 173341 | 2020-05-24 | Rice | Kansas | 20159 | 4 | 0 |
173743 | 173743 | 2020-05-24 | Rice | Minnesota | 27131 | 365 | 2 |
170300 | 170300 | 2020-05-23 | Rice | Kansas | 20159 | 4 | 0 |
170701 | 170701 | 2020-05-23 | Rice | Minnesota | 27131 | 352 | 2 |
167262 | 167262 | 2020-05-22 | Rice | Kansas | 20159 | 4 | 0 |
167663 | 167663 | 2020-05-22 | Rice | Minnesota | 27131 | 328 | 2 |
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);