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 rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, 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 |
14516 | 14516 | 2020-03-27 | Rush | Indiana | 18139 | 3 | 0 |
16315 | 16315 | 2020-03-28 | Rush | Indiana | 18139 | 2 | 0 |
18219 | 18219 | 2020-03-29 | Rush | Indiana | 18139 | 2 | 0 |
20225 | 20225 | 2020-03-30 | Rush | Indiana | 18139 | 4 | 0 |
22320 | 22320 | 2020-03-31 | Rush | Indiana | 18139 | 4 | 0 |
24491 | 24491 | 2020-04-01 | Rush | Indiana | 18139 | 5 | 0 |
26730 | 26730 | 2020-04-02 | Rush | Indiana | 18139 | 7 | 0 |
29041 | 29041 | 2020-04-03 | Rush | Indiana | 18139 | 8 | 1 |
31408 | 31408 | 2020-04-04 | Rush | Indiana | 18139 | 10 | 1 |
33819 | 33819 | 2020-04-05 | Rush | Indiana | 18139 | 10 | 1 |
36273 | 36273 | 2020-04-06 | Rush | Indiana | 18139 | 12 | 1 |
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 |
46498 | 46498 | 2020-04-10 | Rush | Indiana | 18139 | 12 | 1 |
49132 | 49132 | 2020-04-11 | Rush | Indiana | 18139 | 13 | 1 |
51796 | 51796 | 2020-04-12 | Rush | Indiana | 18139 | 15 | 1 |
54477 | 54477 | 2020-04-13 | Rush | Indiana | 18139 | 17 | 1 |
57170 | 57170 | 2020-04-14 | Rush | Indiana | 18139 | 16 | 1 |
59878 | 59878 | 2020-04-15 | Rush | Indiana | 18139 | 17 | 1 |
62599 | 62599 | 2020-04-16 | Rush | Indiana | 18139 | 17 | 1 |
65333 | 65333 | 2020-04-17 | Rush | Indiana | 18139 | 20 | 1 |
68082 | 68082 | 2020-04-18 | Rush | Indiana | 18139 | 19 | 1 |
70844 | 70844 | 2020-04-19 | Rush | Indiana | 18139 | 18 | 1 |
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 |
87579 | 87579 | 2020-04-25 | Rush | Indiana | 18139 | 29 | 1 |
90395 | 90395 | 2020-04-26 | Rush | Indiana | 18139 | 30 | 1 |
93214 | 93214 | 2020-04-27 | Rush | Indiana | 18139 | 31 | 1 |
96046 | 96046 | 2020-04-28 | Rush | Indiana | 18139 | 34 | 1 |
98890 | 98890 | 2020-04-29 | Rush | Indiana | 18139 | 35 | 1 |
101741 | 101741 | 2020-04-30 | Rush | Indiana | 18139 | 37 | 1 |
104597 | 104597 | 2020-05-01 | Rush | Indiana | 18139 | 38 | 1 |
107462 | 107462 | 2020-05-02 | Rush | Indiana | 18139 | 39 | 1 |
110332 | 110332 | 2020-05-03 | Rush | Indiana | 18139 | 40 | 1 |
113207 | 113207 | 2020-05-04 | Rush | Indiana | 18139 | 41 | 1 |
116090 | 116090 | 2020-05-05 | Rush | Indiana | 18139 | 43 | 2 |
119050 | 119050 | 2020-05-06 | Rush | Indiana | 18139 | 47 | 2 |
122020 | 122020 | 2020-05-07 | Rush | Indiana | 18139 | 47 | 2 |
125000 | 125000 | 2020-05-08 | Rush | Indiana | 18139 | 47 | 2 |
127987 | 127987 | 2020-05-09 | Rush | Indiana | 18139 | 48 | 2 |
130978 | 130978 | 2020-05-10 | Rush | Indiana | 18139 | 48 | 2 |
133968 | 133968 | 2020-05-11 | Rush | Indiana | 18139 | 48 | 2 |
136957 | 136957 | 2020-05-12 | Rush | Indiana | 18139 | 49 | 2 |
139949 | 139949 | 2020-05-13 | Rush | Indiana | 18139 | 49 | 2 |
142945 | 142945 | 2020-05-14 | Rush | Indiana | 18139 | 51 | 2 |
145945 | 145945 | 2020-05-15 | Rush | Indiana | 18139 | 53 | 2 |
148949 | 148949 | 2020-05-16 | Rush | Indiana | 18139 | 53 | 2 |
151958 | 151958 | 2020-05-17 | Rush | Indiana | 18139 | 54 | 2 |
154970 | 154970 | 2020-05-18 | Rush | Indiana | 18139 | 55 | 2 |
157986 | 157986 | 2020-05-19 | Rush | Indiana | 18139 | 55 | 2 |
161012 | 161012 | 2020-05-20 | Rush | Indiana | 18139 | 55 | 2 |
164040 | 164040 | 2020-05-21 | Rush | Indiana | 18139 | 57 | 2 |
167073 | 167073 | 2020-05-22 | Rush | Indiana | 18139 | 58 | 2 |
170110 | 170110 | 2020-05-23 | Rush | Indiana | 18139 | 59 | 2 |
173151 | 173151 | 2020-05-24 | Rush | Indiana | 18139 | 59 | 2 |
176195 | 176195 | 2020-05-25 | Rush | Indiana | 18139 | 59 | 2 |
179239 | 179239 | 2020-05-26 | Rush | Indiana | 18139 | 59 | 2 |
182283 | 182283 | 2020-05-27 | Rush | Indiana | 18139 | 59 | 2 |
185337 | 185337 | 2020-05-28 | Rush | Indiana | 18139 | 59 | 2 |
188395 | 188395 | 2020-05-29 | Rush | Indiana | 18139 | 61 | 2 |
191460 | 191460 | 2020-05-30 | Rush | Indiana | 18139 | 61 | 2 |
194527 | 194527 | 2020-05-31 | Rush | Indiana | 18139 | 62 | 2 |
197597 | 197597 | 2020-06-01 | Rush | Indiana | 18139 | 62 | 2 |
200670 | 200670 | 2020-06-02 | Rush | Indiana | 18139 | 64 | 3 |
203746 | 203746 | 2020-06-03 | Rush | Indiana | 18139 | 66 | 3 |
206826 | 206826 | 2020-06-04 | Rush | Indiana | 18139 | 67 | 3 |
209907 | 209907 | 2020-06-05 | Rush | Indiana | 18139 | 67 | 3 |
212992 | 212992 | 2020-06-06 | Rush | Indiana | 18139 | 65 | 3 |
216079 | 216079 | 2020-06-07 | Rush | Indiana | 18139 | 65 | 3 |
219171 | 219171 | 2020-06-08 | Rush | Indiana | 18139 | 65 | 3 |
222266 | 222266 | 2020-06-09 | Rush | Indiana | 18139 | 67 | 3 |
225361 | 225361 | 2020-06-10 | Rush | Indiana | 18139 | 67 | 3 |
228463 | 228463 | 2020-06-11 | Rush | Indiana | 18139 | 67 | 3 |
231566 | 231566 | 2020-06-12 | Rush | Indiana | 18139 | 66 | 3 |
234672 | 234672 | 2020-06-13 | Rush | Indiana | 18139 | 67 | 3 |
237779 | 237779 | 2020-06-14 | Rush | Indiana | 18139 | 67 | 3 |
240887 | 240887 | 2020-06-15 | Rush | Indiana | 18139 | 68 | 3 |
243998 | 243998 | 2020-06-16 | Rush | Indiana | 18139 | 68 | 3 |
247111 | 247111 | 2020-06-17 | Rush | Indiana | 18139 | 68 | 3 |
250223 | 250223 | 2020-06-18 | Rush | Indiana | 18139 | 70 | 3 |
253338 | 253338 | 2020-06-19 | Rush | Indiana | 18139 | 71 | 3 |
256458 | 256458 | 2020-06-20 | Rush | Indiana | 18139 | 71 | 3 |
259584 | 259584 | 2020-06-21 | Rush | Indiana | 18139 | 72 | 3 |
262711 | 262711 | 2020-06-22 | Rush | Indiana | 18139 | 72 | 3 |
265839 | 265839 | 2020-06-23 | Rush | Indiana | 18139 | 73 | 3 |
268969 | 268969 | 2020-06-24 | Rush | Indiana | 18139 | 74 | 3 |
272106 | 272106 | 2020-06-25 | Rush | Indiana | 18139 | 74 | 3 |
275248 | 275248 | 2020-06-26 | Rush | Indiana | 18139 | 77 | 3 |
278396 | 278396 | 2020-06-27 | Rush | Indiana | 18139 | 77 | 3 |
281544 | 281544 | 2020-06-28 | Rush | Indiana | 18139 | 77 | 3 |
284689 | 284689 | 2020-06-29 | Rush | Indiana | 18139 | 77 | 3 |
284888 | 284888 | 2020-06-29 | Rush | Kansas | 20165 | 1 | 0 |
287838 | 287838 | 2020-06-30 | Rush | Indiana | 18139 | 80 | 3 |
288037 | 288037 | 2020-06-30 | Rush | Kansas | 20165 | 1 | 0 |
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);