ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "St. Clair" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535107 | 535107 | 2020-09-15 | St. Clair | Illinois | 17163 | 6750 | 181 |
531872 | 531872 | 2020-09-14 | St. Clair | Illinois | 17163 | 6704 | 180 |
528635 | 528635 | 2020-09-13 | St. Clair | Illinois | 17163 | 6652 | 180 |
525399 | 525399 | 2020-09-12 | St. Clair | Illinois | 17163 | 6632 | 180 |
522163 | 522163 | 2020-09-11 | St. Clair | Illinois | 17163 | 6583 | 179 |
518926 | 518926 | 2020-09-10 | St. Clair | Illinois | 17163 | 6516 | 179 |
515691 | 515691 | 2020-09-09 | St. Clair | Illinois | 17163 | 6421 | 178 |
512458 | 512458 | 2020-09-08 | St. Clair | Illinois | 17163 | 6356 | 178 |
509225 | 509225 | 2020-09-07 | St. Clair | Illinois | 17163 | 6306 | 176 |
505993 | 505993 | 2020-09-06 | St. Clair | Illinois | 17163 | 6259 | 176 |
502759 | 502759 | 2020-09-05 | St. Clair | Illinois | 17163 | 6231 | 176 |
499525 | 499525 | 2020-09-04 | St. Clair | Illinois | 17163 | 6167 | 175 |
496292 | 496292 | 2020-09-03 | St. Clair | Illinois | 17163 | 6041 | 175 |
493058 | 493058 | 2020-09-02 | St. Clair | Illinois | 17163 | 5992 | 175 |
489825 | 489825 | 2020-09-01 | St. Clair | Illinois | 17163 | 5935 | 175 |
486592 | 486592 | 2020-08-31 | St. Clair | Illinois | 17163 | 5850 | 174 |
483357 | 483357 | 2020-08-30 | St. Clair | Illinois | 17163 | 5794 | 174 |
480123 | 480123 | 2020-08-29 | St. Clair | Illinois | 17163 | 5775 | 174 |
476890 | 476890 | 2020-08-28 | St. Clair | Illinois | 17163 | 5683 | 174 |
473657 | 473657 | 2020-08-27 | St. Clair | Illinois | 17163 | 5617 | 174 |
470425 | 470425 | 2020-08-26 | St. Clair | Illinois | 17163 | 5549 | 174 |
467196 | 467196 | 2020-08-25 | St. Clair | Illinois | 17163 | 5503 | 174 |
463967 | 463967 | 2020-08-24 | St. Clair | Illinois | 17163 | 5449 | 173 |
460738 | 460738 | 2020-08-23 | St. Clair | Illinois | 17163 | 5370 | 173 |
457511 | 457511 | 2020-08-22 | St. Clair | Illinois | 17163 | 5296 | 172 |
454283 | 454283 | 2020-08-21 | St. Clair | Illinois | 17163 | 5205 | 170 |
451055 | 451055 | 2020-08-20 | St. Clair | Illinois | 17163 | 5137 | 166 |
447827 | 447827 | 2020-08-19 | St. Clair | Illinois | 17163 | 5077 | 165 |
444600 | 444600 | 2020-08-18 | St. Clair | Illinois | 17163 | 5005 | 163 |
441374 | 441374 | 2020-08-17 | St. Clair | Illinois | 17163 | 4927 | 162 |
438148 | 438148 | 2020-08-16 | St. Clair | Illinois | 17163 | 4861 | 162 |
434922 | 434922 | 2020-08-15 | St. Clair | Illinois | 17163 | 4795 | 162 |
431697 | 431697 | 2020-08-14 | St. Clair | Illinois | 17163 | 4726 | 162 |
428469 | 428469 | 2020-08-13 | St. Clair | Illinois | 17163 | 4662 | 162 |
425245 | 425245 | 2020-08-12 | St. Clair | Illinois | 17163 | 4584 | 162 |
422024 | 422024 | 2020-08-11 | St. Clair | Illinois | 17163 | 4518 | 161 |
418801 | 418801 | 2020-08-10 | St. Clair | Illinois | 17163 | 4441 | 161 |
415580 | 415580 | 2020-08-09 | St. Clair | Illinois | 17163 | 4409 | 161 |
412360 | 412360 | 2020-08-08 | St. Clair | Illinois | 17163 | 4344 | 161 |
409141 | 409141 | 2020-08-07 | St. Clair | Illinois | 17163 | 4282 | 160 |
405921 | 405921 | 2020-08-06 | St. Clair | Illinois | 17163 | 4224 | 159 |
402703 | 402703 | 2020-08-05 | St. Clair | Illinois | 17163 | 4134 | 159 |
399487 | 399487 | 2020-08-04 | St. Clair | Illinois | 17163 | 4074 | 156 |
396271 | 396271 | 2020-08-03 | St. Clair | Illinois | 17163 | 4015 | 156 |
393055 | 393055 | 2020-08-02 | St. Clair | Illinois | 17163 | 3907 | 156 |
389838 | 389838 | 2020-08-01 | St. Clair | Illinois | 17163 | 3862 | 156 |
386621 | 386621 | 2020-07-31 | St. Clair | Illinois | 17163 | 3792 | 155 |
383403 | 383403 | 2020-07-30 | St. Clair | Illinois | 17163 | 3708 | 154 |
380186 | 380186 | 2020-07-29 | St. Clair | Illinois | 17163 | 3659 | 154 |
376969 | 376969 | 2020-07-28 | St. Clair | Illinois | 17163 | 3593 | 154 |
373754 | 373754 | 2020-07-27 | St. Clair | Illinois | 17163 | 3530 | 153 |
370542 | 370542 | 2020-07-26 | St. Clair | Illinois | 17163 | 3473 | 153 |
367332 | 367332 | 2020-07-25 | St. Clair | Illinois | 17163 | 3433 | 153 |
364125 | 364125 | 2020-07-24 | St. Clair | Illinois | 17163 | 3357 | 152 |
360918 | 360918 | 2020-07-23 | St. Clair | Illinois | 17163 | 3270 | 152 |
357713 | 357713 | 2020-07-22 | St. Clair | Illinois | 17163 | 3210 | 152 |
354511 | 354511 | 2020-07-21 | St. Clair | Illinois | 17163 | 3138 | 151 |
351309 | 351309 | 2020-07-20 | St. Clair | Illinois | 17163 | 3095 | 150 |
348109 | 348109 | 2020-07-19 | St. Clair | Illinois | 17163 | 3053 | 150 |
344908 | 344908 | 2020-07-18 | St. Clair | Illinois | 17163 | 2976 | 149 |
341708 | 341708 | 2020-07-17 | St. Clair | Illinois | 17163 | 2871 | 148 |
338512 | 338512 | 2020-07-16 | St. Clair | Illinois | 17163 | 2803 | 147 |
335316 | 335316 | 2020-07-15 | St. Clair | Illinois | 17163 | 2732 | 147 |
332123 | 332123 | 2020-07-14 | St. Clair | Illinois | 17163 | 2471 | 145 |
328936 | 328936 | 2020-07-13 | St. Clair | Illinois | 17163 | 2471 | 144 |
325750 | 325750 | 2020-07-12 | St. Clair | Illinois | 17163 | 2471 | 144 |
322569 | 322569 | 2020-07-11 | St. Clair | Illinois | 17163 | 2471 | 144 |
319390 | 319390 | 2020-07-10 | St. Clair | Illinois | 17163 | 2471 | 144 |
316217 | 316217 | 2020-07-09 | St. Clair | Illinois | 17163 | 2412 | 144 |
313043 | 313043 | 2020-07-08 | St. Clair | Illinois | 17163 | 2297 | 143 |
309873 | 309873 | 2020-07-07 | St. Clair | Illinois | 17163 | 2297 | 140 |
306705 | 306705 | 2020-07-06 | St. Clair | Illinois | 17163 | 2208 | 140 |
303540 | 303540 | 2020-07-05 | St. Clair | Illinois | 17163 | 2208 | 140 |
300376 | 300376 | 2020-07-04 | St. Clair | Illinois | 17163 | 2208 | 140 |
297214 | 297214 | 2020-07-03 | St. Clair | Illinois | 17163 | 2167 | 139 |
294056 | 294056 | 2020-07-02 | St. Clair | Illinois | 17163 | 2167 | 139 |
290902 | 290902 | 2020-07-01 | St. Clair | Illinois | 17163 | 2133 | 138 |
287752 | 287752 | 2020-06-30 | St. Clair | Illinois | 17163 | 2086 | 138 |
284603 | 284603 | 2020-06-29 | St. Clair | Illinois | 17163 | 2039 | 138 |
281458 | 281458 | 2020-06-28 | St. Clair | Illinois | 17163 | 1956 | 138 |
278310 | 278310 | 2020-06-27 | St. Clair | Illinois | 17163 | 1956 | 138 |
275162 | 275162 | 2020-06-26 | St. Clair | Illinois | 17163 | 1921 | 136 |
272020 | 272020 | 2020-06-25 | St. Clair | Illinois | 17163 | 1896 | 136 |
268883 | 268883 | 2020-06-24 | St. Clair | Illinois | 17163 | 1869 | 136 |
265753 | 265753 | 2020-06-23 | St. Clair | Illinois | 17163 | 1816 | 135 |
262625 | 262625 | 2020-06-22 | St. Clair | Illinois | 17163 | 1799 | 132 |
259498 | 259498 | 2020-06-21 | St. Clair | Illinois | 17163 | 1799 | 132 |
256372 | 256372 | 2020-06-20 | St. Clair | Illinois | 17163 | 1772 | 131 |
253252 | 253252 | 2020-06-19 | St. Clair | Illinois | 17163 | 1748 | 131 |
250137 | 250137 | 2020-06-18 | St. Clair | Illinois | 17163 | 1716 | 131 |
247025 | 247025 | 2020-06-17 | St. Clair | Illinois | 17163 | 1698 | 130 |
243912 | 243912 | 2020-06-16 | St. Clair | Illinois | 17163 | 1668 | 130 |
240801 | 240801 | 2020-06-15 | St. Clair | Illinois | 17163 | 1662 | 129 |
237693 | 237693 | 2020-06-14 | St. Clair | Illinois | 17163 | 1626 | 126 |
234586 | 234586 | 2020-06-13 | St. Clair | Illinois | 17163 | 1610 | 124 |
231480 | 231480 | 2020-06-12 | St. Clair | Illinois | 17163 | 1569 | 123 |
228377 | 228377 | 2020-06-11 | St. Clair | Illinois | 17163 | 1546 | 117 |
225275 | 225275 | 2020-06-10 | St. Clair | Illinois | 17163 | 1490 | 112 |
222180 | 222180 | 2020-06-09 | St. Clair | Illinois | 17163 | 1490 | 112 |
219085 | 219085 | 2020-06-08 | St. Clair | Illinois | 17163 | 1467 | 109 |
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);