ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Marion" and state = "Illinois" sorted by county
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
20144 | 20144 | 2020-03-30 | Marion | Illinois | 17121 | 2 | 0 |
22236 | 22236 | 2020-03-31 | Marion | Illinois | 17121 | 2 | 0 |
24404 | 24404 | 2020-04-01 | Marion | Illinois | 17121 | 2 | 0 |
26639 | 26639 | 2020-04-02 | Marion | Illinois | 17121 | 2 | 0 |
28949 | 28949 | 2020-04-03 | Marion | Illinois | 17121 | 3 | 0 |
31313 | 31313 | 2020-04-04 | Marion | Illinois | 17121 | 3 | 0 |
33723 | 33723 | 2020-04-05 | Marion | Illinois | 17121 | 3 | 0 |
36175 | 36175 | 2020-04-06 | Marion | Illinois | 17121 | 3 | 0 |
38671 | 38671 | 2020-04-07 | Marion | Illinois | 17121 | 3 | 0 |
41216 | 41216 | 2020-04-08 | Marion | Illinois | 17121 | 4 | 0 |
43790 | 43790 | 2020-04-09 | Marion | Illinois | 17121 | 10 | 0 |
46394 | 46394 | 2020-04-10 | Marion | Illinois | 17121 | 12 | 0 |
49025 | 49025 | 2020-04-11 | Marion | Illinois | 17121 | 13 | 0 |
51687 | 51687 | 2020-04-12 | Marion | Illinois | 17121 | 13 | 0 |
54368 | 54368 | 2020-04-13 | Marion | Illinois | 17121 | 13 | 0 |
57061 | 57061 | 2020-04-14 | Marion | Illinois | 17121 | 14 | 0 |
59768 | 59768 | 2020-04-15 | Marion | Illinois | 17121 | 17 | 0 |
62489 | 62489 | 2020-04-16 | Marion | Illinois | 17121 | 17 | 0 |
65222 | 65222 | 2020-04-17 | Marion | Illinois | 17121 | 17 | 0 |
67971 | 67971 | 2020-04-18 | Marion | Illinois | 17121 | 19 | 0 |
70733 | 70733 | 2020-04-19 | Marion | Illinois | 17121 | 20 | 0 |
73503 | 73503 | 2020-04-20 | Marion | Illinois | 17121 | 20 | 0 |
76280 | 76280 | 2020-04-21 | Marion | Illinois | 17121 | 25 | 0 |
79064 | 79064 | 2020-04-22 | Marion | Illinois | 17121 | 24 | 0 |
81857 | 81857 | 2020-04-23 | Marion | Illinois | 17121 | 25 | 0 |
84657 | 84657 | 2020-04-24 | Marion | Illinois | 17121 | 26 | 0 |
87467 | 87467 | 2020-04-25 | Marion | Illinois | 17121 | 26 | 0 |
90283 | 90283 | 2020-04-26 | Marion | Illinois | 17121 | 26 | 0 |
93102 | 93102 | 2020-04-27 | Marion | Illinois | 17121 | 26 | 0 |
95934 | 95934 | 2020-04-28 | Marion | Illinois | 17121 | 28 | 0 |
98778 | 98778 | 2020-04-29 | Marion | Illinois | 17121 | 29 | 0 |
101629 | 101629 | 2020-04-30 | Marion | Illinois | 17121 | 33 | 0 |
104485 | 104485 | 2020-05-01 | Marion | Illinois | 17121 | 34 | 0 |
107350 | 107350 | 2020-05-02 | Marion | Illinois | 17121 | 34 | 0 |
110220 | 110220 | 2020-05-03 | Marion | Illinois | 17121 | 34 | 0 |
113095 | 113095 | 2020-05-04 | Marion | Illinois | 17121 | 35 | 0 |
115978 | 115978 | 2020-05-05 | Marion | Illinois | 17121 | 36 | 0 |
118938 | 118938 | 2020-05-06 | Marion | Illinois | 17121 | 38 | 0 |
121908 | 121908 | 2020-05-07 | Marion | Illinois | 17121 | 40 | 0 |
124887 | 124887 | 2020-05-08 | Marion | Illinois | 17121 | 41 | 0 |
127874 | 127874 | 2020-05-09 | Marion | Illinois | 17121 | 43 | 0 |
130865 | 130865 | 2020-05-10 | Marion | Illinois | 17121 | 44 | 0 |
133856 | 133856 | 2020-05-11 | Marion | Illinois | 17121 | 47 | 0 |
136845 | 136845 | 2020-05-12 | Marion | Illinois | 17121 | 47 | 0 |
139837 | 139837 | 2020-05-13 | Marion | Illinois | 17121 | 47 | 0 |
142833 | 142833 | 2020-05-14 | Marion | Illinois | 17121 | 47 | 0 |
145833 | 145833 | 2020-05-15 | Marion | Illinois | 17121 | 47 | 0 |
148836 | 148836 | 2020-05-16 | Marion | Illinois | 17121 | 48 | 0 |
151845 | 151845 | 2020-05-17 | Marion | Illinois | 17121 | 48 | 0 |
154857 | 154857 | 2020-05-18 | Marion | Illinois | 17121 | 48 | 0 |
157873 | 157873 | 2020-05-19 | Marion | Illinois | 17121 | 49 | 0 |
160899 | 160899 | 2020-05-20 | Marion | Illinois | 17121 | 49 | 0 |
163927 | 163927 | 2020-05-21 | Marion | Illinois | 17121 | 50 | 0 |
166960 | 166960 | 2020-05-22 | Marion | Illinois | 17121 | 50 | 0 |
169997 | 169997 | 2020-05-23 | Marion | Illinois | 17121 | 50 | 0 |
173038 | 173038 | 2020-05-24 | Marion | Illinois | 17121 | 50 | 0 |
176082 | 176082 | 2020-05-25 | Marion | Illinois | 17121 | 50 | 0 |
179126 | 179126 | 2020-05-26 | Marion | Illinois | 17121 | 50 | 0 |
182170 | 182170 | 2020-05-27 | Marion | Illinois | 17121 | 50 | 0 |
185224 | 185224 | 2020-05-28 | Marion | Illinois | 17121 | 50 | 0 |
188282 | 188282 | 2020-05-29 | Marion | Illinois | 17121 | 50 | 0 |
191347 | 191347 | 2020-05-30 | Marion | Illinois | 17121 | 50 | 0 |
194414 | 194414 | 2020-05-31 | Marion | Illinois | 17121 | 50 | 0 |
197484 | 197484 | 2020-06-01 | Marion | Illinois | 17121 | 50 | 0 |
200557 | 200557 | 2020-06-02 | Marion | Illinois | 17121 | 50 | 0 |
203633 | 203633 | 2020-06-03 | Marion | Illinois | 17121 | 51 | 0 |
206713 | 206713 | 2020-06-04 | Marion | Illinois | 17121 | 51 | 0 |
209794 | 209794 | 2020-06-05 | Marion | Illinois | 17121 | 52 | 0 |
212879 | 212879 | 2020-06-06 | Marion | Illinois | 17121 | 55 | 0 |
215966 | 215966 | 2020-06-07 | Marion | Illinois | 17121 | 55 | 0 |
219057 | 219057 | 2020-06-08 | Marion | Illinois | 17121 | 55 | 0 |
222152 | 222152 | 2020-06-09 | Marion | Illinois | 17121 | 55 | 0 |
225247 | 225247 | 2020-06-10 | Marion | Illinois | 17121 | 55 | 0 |
228349 | 228349 | 2020-06-11 | Marion | Illinois | 17121 | 55 | 0 |
231452 | 231452 | 2020-06-12 | Marion | Illinois | 17121 | 55 | 0 |
234558 | 234558 | 2020-06-13 | Marion | Illinois | 17121 | 55 | 0 |
237665 | 237665 | 2020-06-14 | Marion | Illinois | 17121 | 55 | 0 |
240773 | 240773 | 2020-06-15 | Marion | Illinois | 17121 | 55 | 0 |
243884 | 243884 | 2020-06-16 | Marion | Illinois | 17121 | 55 | 0 |
246997 | 246997 | 2020-06-17 | Marion | Illinois | 17121 | 55 | 0 |
250109 | 250109 | 2020-06-18 | Marion | Illinois | 17121 | 55 | 0 |
253224 | 253224 | 2020-06-19 | Marion | Illinois | 17121 | 57 | 0 |
256344 | 256344 | 2020-06-20 | Marion | Illinois | 17121 | 57 | 0 |
259470 | 259470 | 2020-06-21 | Marion | Illinois | 17121 | 60 | 0 |
262597 | 262597 | 2020-06-22 | Marion | Illinois | 17121 | 60 | 0 |
265725 | 265725 | 2020-06-23 | Marion | Illinois | 17121 | 62 | 0 |
268855 | 268855 | 2020-06-24 | Marion | Illinois | 17121 | 63 | 0 |
271992 | 271992 | 2020-06-25 | Marion | Illinois | 17121 | 65 | 0 |
275134 | 275134 | 2020-06-26 | Marion | Illinois | 17121 | 65 | 0 |
278282 | 278282 | 2020-06-27 | Marion | Illinois | 17121 | 65 | 0 |
281430 | 281430 | 2020-06-28 | Marion | Illinois | 17121 | 65 | 0 |
284575 | 284575 | 2020-06-29 | Marion | Illinois | 17121 | 65 | 0 |
287724 | 287724 | 2020-06-30 | Marion | Illinois | 17121 | 65 | 0 |
290874 | 290874 | 2020-07-01 | Marion | Illinois | 17121 | 66 | 0 |
294028 | 294028 | 2020-07-02 | Marion | Illinois | 17121 | 66 | 0 |
297185 | 297185 | 2020-07-03 | Marion | Illinois | 17121 | 68 | 0 |
300347 | 300347 | 2020-07-04 | Marion | Illinois | 17121 | 69 | 0 |
303511 | 303511 | 2020-07-05 | Marion | Illinois | 17121 | 69 | 0 |
306676 | 306676 | 2020-07-06 | Marion | Illinois | 17121 | 70 | 0 |
309844 | 309844 | 2020-07-07 | Marion | Illinois | 17121 | 70 | 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);