ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
760 rows where county = "Clay" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535033 | 535033 | 2020-09-15 | Clay | Illinois | 17025 | 134 | 0 |
531798 | 531798 | 2020-09-14 | Clay | Illinois | 17025 | 132 | 0 |
528561 | 528561 | 2020-09-13 | Clay | Illinois | 17025 | 129 | 0 |
525325 | 525325 | 2020-09-12 | Clay | Illinois | 17025 | 127 | 0 |
522089 | 522089 | 2020-09-11 | Clay | Illinois | 17025 | 120 | 0 |
518852 | 518852 | 2020-09-10 | Clay | Illinois | 17025 | 116 | 0 |
515617 | 515617 | 2020-09-09 | Clay | Illinois | 17025 | 114 | 0 |
512384 | 512384 | 2020-09-08 | Clay | Illinois | 17025 | 114 | 0 |
509151 | 509151 | 2020-09-07 | Clay | Illinois | 17025 | 113 | 0 |
505919 | 505919 | 2020-09-06 | Clay | Illinois | 17025 | 113 | 0 |
502685 | 502685 | 2020-09-05 | Clay | Illinois | 17025 | 112 | 0 |
499451 | 499451 | 2020-09-04 | Clay | Illinois | 17025 | 108 | 0 |
496218 | 496218 | 2020-09-03 | Clay | Illinois | 17025 | 92 | 0 |
492984 | 492984 | 2020-09-02 | Clay | Illinois | 17025 | 91 | 0 |
489751 | 489751 | 2020-09-01 | Clay | Illinois | 17025 | 84 | 0 |
486518 | 486518 | 2020-08-31 | Clay | Illinois | 17025 | 80 | 0 |
483283 | 483283 | 2020-08-30 | Clay | Illinois | 17025 | 78 | 0 |
480049 | 480049 | 2020-08-29 | Clay | Illinois | 17025 | 74 | 0 |
476816 | 476816 | 2020-08-28 | Clay | Illinois | 17025 | 72 | 0 |
473583 | 473583 | 2020-08-27 | Clay | Illinois | 17025 | 65 | 0 |
470351 | 470351 | 2020-08-26 | Clay | Illinois | 17025 | 62 | 0 |
467122 | 467122 | 2020-08-25 | Clay | Illinois | 17025 | 61 | 0 |
463893 | 463893 | 2020-08-24 | Clay | Illinois | 17025 | 60 | 0 |
460664 | 460664 | 2020-08-23 | Clay | Illinois | 17025 | 59 | 0 |
457437 | 457437 | 2020-08-22 | Clay | Illinois | 17025 | 57 | 0 |
454209 | 454209 | 2020-08-21 | Clay | Illinois | 17025 | 52 | 0 |
450981 | 450981 | 2020-08-20 | Clay | Illinois | 17025 | 51 | 0 |
447753 | 447753 | 2020-08-19 | Clay | Illinois | 17025 | 47 | 0 |
444526 | 444526 | 2020-08-18 | Clay | Illinois | 17025 | 40 | 0 |
441300 | 441300 | 2020-08-17 | Clay | Illinois | 17025 | 38 | 0 |
438074 | 438074 | 2020-08-16 | Clay | Illinois | 17025 | 36 | 0 |
434848 | 434848 | 2020-08-15 | Clay | Illinois | 17025 | 32 | 0 |
431623 | 431623 | 2020-08-14 | Clay | Illinois | 17025 | 32 | 0 |
428395 | 428395 | 2020-08-13 | Clay | Illinois | 17025 | 31 | 0 |
425171 | 425171 | 2020-08-12 | Clay | Illinois | 17025 | 27 | 0 |
421950 | 421950 | 2020-08-11 | Clay | Illinois | 17025 | 26 | 0 |
418727 | 418727 | 2020-08-10 | Clay | Illinois | 17025 | 23 | 0 |
415506 | 415506 | 2020-08-09 | Clay | Illinois | 17025 | 23 | 0 |
412286 | 412286 | 2020-08-08 | Clay | Illinois | 17025 | 23 | 0 |
409067 | 409067 | 2020-08-07 | Clay | Illinois | 17025 | 20 | 0 |
405847 | 405847 | 2020-08-06 | Clay | Illinois | 17025 | 18 | 0 |
402629 | 402629 | 2020-08-05 | Clay | Illinois | 17025 | 17 | 0 |
399413 | 399413 | 2020-08-04 | Clay | Illinois | 17025 | 15 | 0 |
396197 | 396197 | 2020-08-03 | Clay | Illinois | 17025 | 14 | 0 |
392981 | 392981 | 2020-08-02 | Clay | Illinois | 17025 | 14 | 0 |
389764 | 389764 | 2020-08-01 | Clay | Illinois | 17025 | 13 | 0 |
386547 | 386547 | 2020-07-31 | Clay | Illinois | 17025 | 12 | 0 |
383329 | 383329 | 2020-07-30 | Clay | Illinois | 17025 | 12 | 0 |
380112 | 380112 | 2020-07-29 | Clay | Illinois | 17025 | 10 | 0 |
376895 | 376895 | 2020-07-28 | Clay | Illinois | 17025 | 10 | 0 |
373680 | 373680 | 2020-07-27 | Clay | Illinois | 17025 | 10 | 0 |
370468 | 370468 | 2020-07-26 | Clay | Illinois | 17025 | 9 | 0 |
367258 | 367258 | 2020-07-25 | Clay | Illinois | 17025 | 9 | 0 |
364051 | 364051 | 2020-07-24 | Clay | Illinois | 17025 | 9 | 0 |
360844 | 360844 | 2020-07-23 | Clay | Illinois | 17025 | 9 | 0 |
357639 | 357639 | 2020-07-22 | Clay | Illinois | 17025 | 9 | 0 |
354437 | 354437 | 2020-07-21 | Clay | Illinois | 17025 | 9 | 0 |
351235 | 351235 | 2020-07-20 | Clay | Illinois | 17025 | 8 | 0 |
348035 | 348035 | 2020-07-19 | Clay | Illinois | 17025 | 8 | 0 |
344834 | 344834 | 2020-07-18 | Clay | Illinois | 17025 | 8 | 0 |
341634 | 341634 | 2020-07-17 | Clay | Illinois | 17025 | 8 | 0 |
338438 | 338438 | 2020-07-16 | Clay | Illinois | 17025 | 8 | 0 |
335242 | 335242 | 2020-07-15 | Clay | Illinois | 17025 | 8 | 0 |
332049 | 332049 | 2020-07-14 | Clay | Illinois | 17025 | 8 | 0 |
328862 | 328862 | 2020-07-13 | Clay | Illinois | 17025 | 8 | 0 |
325676 | 325676 | 2020-07-12 | Clay | Illinois | 17025 | 5 | 0 |
322495 | 322495 | 2020-07-11 | Clay | Illinois | 17025 | 5 | 0 |
319316 | 319316 | 2020-07-10 | Clay | Illinois | 17025 | 2 | 0 |
316143 | 316143 | 2020-07-09 | Clay | Illinois | 17025 | 2 | 0 |
312969 | 312969 | 2020-07-08 | Clay | Illinois | 17025 | 2 | 0 |
309799 | 309799 | 2020-07-07 | Clay | Illinois | 17025 | 2 | 0 |
306631 | 306631 | 2020-07-06 | Clay | Illinois | 17025 | 2 | 0 |
303466 | 303466 | 2020-07-05 | Clay | Illinois | 17025 | 2 | 0 |
300302 | 300302 | 2020-07-04 | Clay | Illinois | 17025 | 2 | 0 |
297140 | 297140 | 2020-07-03 | Clay | Illinois | 17025 | 2 | 0 |
293983 | 293983 | 2020-07-02 | Clay | Illinois | 17025 | 2 | 0 |
290829 | 290829 | 2020-07-01 | Clay | Illinois | 17025 | 2 | 0 |
287679 | 287679 | 2020-06-30 | Clay | Illinois | 17025 | 2 | 0 |
284530 | 284530 | 2020-06-29 | Clay | Illinois | 17025 | 2 | 0 |
281385 | 281385 | 2020-06-28 | Clay | Illinois | 17025 | 2 | 0 |
278237 | 278237 | 2020-06-27 | Clay | Illinois | 17025 | 2 | 0 |
275089 | 275089 | 2020-06-26 | Clay | Illinois | 17025 | 2 | 0 |
271947 | 271947 | 2020-06-25 | Clay | Illinois | 17025 | 2 | 0 |
268810 | 268810 | 2020-06-24 | Clay | Illinois | 17025 | 2 | 0 |
265680 | 265680 | 2020-06-23 | Clay | Illinois | 17025 | 2 | 0 |
262552 | 262552 | 2020-06-22 | Clay | Illinois | 17025 | 2 | 0 |
259425 | 259425 | 2020-06-21 | Clay | Illinois | 17025 | 2 | 0 |
256299 | 256299 | 2020-06-20 | Clay | Illinois | 17025 | 2 | 0 |
253179 | 253179 | 2020-06-19 | Clay | Illinois | 17025 | 2 | 0 |
250064 | 250064 | 2020-06-18 | Clay | Illinois | 17025 | 3 | 0 |
246952 | 246952 | 2020-06-17 | Clay | Illinois | 17025 | 2 | 0 |
243839 | 243839 | 2020-06-16 | Clay | Illinois | 17025 | 2 | 0 |
240728 | 240728 | 2020-06-15 | Clay | Illinois | 17025 | 2 | 0 |
237620 | 237620 | 2020-06-14 | Clay | Illinois | 17025 | 2 | 0 |
234513 | 234513 | 2020-06-13 | Clay | Illinois | 17025 | 2 | 0 |
231407 | 231407 | 2020-06-12 | Clay | Illinois | 17025 | 2 | 0 |
228304 | 228304 | 2020-06-11 | Clay | Illinois | 17025 | 2 | 0 |
225202 | 225202 | 2020-06-10 | Clay | Illinois | 17025 | 2 | 0 |
222107 | 222107 | 2020-06-09 | Clay | Illinois | 17025 | 2 | 0 |
219012 | 219012 | 2020-06-08 | Clay | Illinois | 17025 | 2 | 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);