ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,464 rows where county = "Rush" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
11270 | 11270 | 2020-03-25 | Rush | Indiana | 18139 | 1 | 0 |
12830 | 12830 | 2020-03-26 | Rush | Indiana | 18139 | 1 | 0 |
284888 | 284888 | 2020-06-29 | Rush | Kansas | 20165 | 1 | 0 |
288037 | 288037 | 2020-06-30 | Rush | Kansas | 20165 | 1 | 0 |
291187 | 291187 | 2020-07-01 | Rush | Kansas | 20165 | 1 | 0 |
294341 | 294341 | 2020-07-02 | Rush | Kansas | 20165 | 1 | 0 |
297499 | 297499 | 2020-07-03 | Rush | Kansas | 20165 | 1 | 0 |
300661 | 300661 | 2020-07-04 | Rush | Kansas | 20165 | 1 | 0 |
303825 | 303825 | 2020-07-05 | Rush | Kansas | 20165 | 1 | 0 |
306992 | 306992 | 2020-07-06 | Rush | Kansas | 20165 | 1 | 0 |
310160 | 310160 | 2020-07-07 | Rush | Kansas | 20165 | 1 | 0 |
16315 | 16315 | 2020-03-28 | Rush | Indiana | 18139 | 2 | 0 |
18219 | 18219 | 2020-03-29 | Rush | Indiana | 18139 | 2 | 0 |
313330 | 313330 | 2020-07-08 | Rush | Kansas | 20165 | 2 | 0 |
316504 | 316504 | 2020-07-09 | Rush | Kansas | 20165 | 2 | 0 |
14516 | 14516 | 2020-03-27 | Rush | Indiana | 18139 | 3 | 0 |
319678 | 319678 | 2020-07-10 | Rush | Kansas | 20165 | 3 | 0 |
322857 | 322857 | 2020-07-11 | Rush | Kansas | 20165 | 3 | 0 |
326040 | 326040 | 2020-07-12 | Rush | Kansas | 20165 | 3 | 0 |
20225 | 20225 | 2020-03-30 | Rush | Indiana | 18139 | 4 | 0 |
22320 | 22320 | 2020-03-31 | Rush | Indiana | 18139 | 4 | 0 |
329226 | 329226 | 2020-07-13 | Rush | Kansas | 20165 | 4 | 0 |
332413 | 332413 | 2020-07-14 | Rush | Kansas | 20165 | 4 | 0 |
335606 | 335606 | 2020-07-15 | Rush | Kansas | 20165 | 4 | 0 |
338802 | 338802 | 2020-07-16 | Rush | Kansas | 20165 | 4 | 0 |
341998 | 341998 | 2020-07-17 | Rush | Kansas | 20165 | 4 | 0 |
345198 | 345198 | 2020-07-18 | Rush | Kansas | 20165 | 4 | 0 |
348399 | 348399 | 2020-07-19 | Rush | Kansas | 20165 | 4 | 0 |
351599 | 351599 | 2020-07-20 | Rush | Kansas | 20165 | 4 | 0 |
354801 | 354801 | 2020-07-21 | Rush | Kansas | 20165 | 4 | 0 |
24491 | 24491 | 2020-04-01 | Rush | Indiana | 18139 | 5 | 0 |
358003 | 358003 | 2020-07-22 | Rush | Kansas | 20165 | 5 | 0 |
361208 | 361208 | 2020-07-23 | Rush | Kansas | 20165 | 5 | 0 |
364415 | 364415 | 2020-07-24 | Rush | Kansas | 20165 | 5 | 0 |
367622 | 367622 | 2020-07-25 | Rush | Kansas | 20165 | 5 | 0 |
370832 | 370832 | 2020-07-26 | Rush | Kansas | 20165 | 5 | 0 |
374044 | 374044 | 2020-07-27 | Rush | Kansas | 20165 | 5 | 0 |
377259 | 377259 | 2020-07-28 | Rush | Kansas | 20165 | 5 | 0 |
380476 | 380476 | 2020-07-29 | Rush | Kansas | 20165 | 5 | 0 |
383693 | 383693 | 2020-07-30 | Rush | Kansas | 20165 | 5 | 0 |
386911 | 386911 | 2020-07-31 | Rush | Kansas | 20165 | 6 | 0 |
390128 | 390128 | 2020-08-01 | Rush | Kansas | 20165 | 6 | 0 |
393345 | 393345 | 2020-08-02 | Rush | Kansas | 20165 | 6 | 0 |
26730 | 26730 | 2020-04-02 | Rush | Indiana | 18139 | 7 | 0 |
396561 | 396561 | 2020-08-03 | Rush | Kansas | 20165 | 7 | 0 |
399776 | 399776 | 2020-08-04 | Rush | Kansas | 20165 | 7 | 0 |
29041 | 29041 | 2020-04-03 | Rush | Indiana | 18139 | 8 | 1 |
402993 | 402993 | 2020-08-05 | Rush | Kansas | 20165 | 9 | 0 |
406211 | 406211 | 2020-08-06 | Rush | Kansas | 20165 | 9 | 0 |
409430 | 409430 | 2020-08-07 | Rush | Kansas | 20165 | 9 | 0 |
412650 | 412650 | 2020-08-08 | Rush | Kansas | 20165 | 9 | 0 |
415870 | 415870 | 2020-08-09 | Rush | Kansas | 20165 | 9 | 0 |
419091 | 419091 | 2020-08-10 | Rush | Kansas | 20165 | 9 | 0 |
422314 | 422314 | 2020-08-11 | Rush | Kansas | 20165 | 9 | 0 |
31408 | 31408 | 2020-04-04 | Rush | Indiana | 18139 | 10 | 1 |
33819 | 33819 | 2020-04-05 | Rush | Indiana | 18139 | 10 | 1 |
425535 | 425535 | 2020-08-12 | Rush | Kansas | 20165 | 10 | 0 |
428759 | 428759 | 2020-08-13 | Rush | Kansas | 20165 | 10 | 0 |
431987 | 431987 | 2020-08-14 | Rush | Kansas | 20165 | 10 | 0 |
435212 | 435212 | 2020-08-15 | Rush | Kansas | 20165 | 10 | 0 |
438437 | 438437 | 2020-08-16 | Rush | Kansas | 20165 | 10 | 0 |
441664 | 441664 | 2020-08-17 | Rush | Kansas | 20165 | 11 | 0 |
444890 | 444890 | 2020-08-18 | Rush | Kansas | 20165 | 11 | 0 |
36273 | 36273 | 2020-04-06 | Rush | Indiana | 18139 | 12 | 1 |
46498 | 46498 | 2020-04-10 | Rush | Indiana | 18139 | 12 | 1 |
49132 | 49132 | 2020-04-11 | Rush | Indiana | 18139 | 13 | 1 |
448117 | 448117 | 2020-08-19 | Rush | Kansas | 20165 | 13 | 0 |
451345 | 451345 | 2020-08-20 | Rush | Kansas | 20165 | 13 | 0 |
38771 | 38771 | 2020-04-07 | Rush | Indiana | 18139 | 14 | 1 |
41317 | 41317 | 2020-04-08 | Rush | Indiana | 18139 | 14 | 1 |
43893 | 43893 | 2020-04-09 | Rush | Indiana | 18139 | 14 | 1 |
51796 | 51796 | 2020-04-12 | Rush | Indiana | 18139 | 15 | 1 |
454573 | 454573 | 2020-08-21 | Rush | Kansas | 20165 | 15 | 0 |
457801 | 457801 | 2020-08-22 | Rush | Kansas | 20165 | 15 | 0 |
461028 | 461028 | 2020-08-23 | Rush | Kansas | 20165 | 15 | 0 |
57170 | 57170 | 2020-04-14 | Rush | Indiana | 18139 | 16 | 1 |
464258 | 464258 | 2020-08-24 | Rush | Kansas | 20165 | 16 | 0 |
467487 | 467487 | 2020-08-25 | Rush | Kansas | 20165 | 16 | 0 |
54477 | 54477 | 2020-04-13 | Rush | Indiana | 18139 | 17 | 1 |
59878 | 59878 | 2020-04-15 | Rush | Indiana | 18139 | 17 | 1 |
62599 | 62599 | 2020-04-16 | Rush | Indiana | 18139 | 17 | 1 |
470716 | 470716 | 2020-08-26 | Rush | Kansas | 20165 | 17 | 0 |
473948 | 473948 | 2020-08-27 | Rush | Kansas | 20165 | 17 | 0 |
70844 | 70844 | 2020-04-19 | Rush | Indiana | 18139 | 18 | 1 |
477181 | 477181 | 2020-08-28 | Rush | Kansas | 20165 | 18 | 0 |
480414 | 480414 | 2020-08-29 | Rush | Kansas | 20165 | 18 | 0 |
483648 | 483648 | 2020-08-30 | Rush | Kansas | 20165 | 18 | 0 |
68082 | 68082 | 2020-04-18 | Rush | Indiana | 18139 | 19 | 1 |
65333 | 65333 | 2020-04-17 | Rush | Indiana | 18139 | 20 | 1 |
486883 | 486883 | 2020-08-31 | Rush | Kansas | 20165 | 20 | 0 |
490116 | 490116 | 2020-09-01 | Rush | Kansas | 20165 | 20 | 0 |
73615 | 73615 | 2020-04-20 | Rush | Indiana | 18139 | 21 | 1 |
76392 | 76392 | 2020-04-21 | Rush | Indiana | 18139 | 22 | 1 |
79176 | 79176 | 2020-04-22 | Rush | Indiana | 18139 | 22 | 1 |
81969 | 81969 | 2020-04-23 | Rush | Indiana | 18139 | 22 | 1 |
84769 | 84769 | 2020-04-24 | Rush | Indiana | 18139 | 27 | 1 |
493349 | 493349 | 2020-09-02 | Rush | Kansas | 20165 | 27 | 0 |
496583 | 496583 | 2020-09-03 | Rush | Kansas | 20165 | 27 | 0 |
87579 | 87579 | 2020-04-25 | Rush | Indiana | 18139 | 29 | 1 |
90395 | 90395 | 2020-04-26 | Rush | Indiana | 18139 | 30 | 1 |
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);