ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Clark" and fips = 17023 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535032 | 535032 | 2020-09-15 | Clark | Illinois | 17023 | 141 | 2 |
531797 | 531797 | 2020-09-14 | Clark | Illinois | 17023 | 140 | 2 |
528560 | 528560 | 2020-09-13 | Clark | Illinois | 17023 | 137 | 2 |
525324 | 525324 | 2020-09-12 | Clark | Illinois | 17023 | 133 | 2 |
522088 | 522088 | 2020-09-11 | Clark | Illinois | 17023 | 125 | 2 |
518851 | 518851 | 2020-09-10 | Clark | Illinois | 17023 | 123 | 2 |
515616 | 515616 | 2020-09-09 | Clark | Illinois | 17023 | 122 | 2 |
512383 | 512383 | 2020-09-08 | Clark | Illinois | 17023 | 121 | 2 |
509150 | 509150 | 2020-09-07 | Clark | Illinois | 17023 | 122 | 2 |
505918 | 505918 | 2020-09-06 | Clark | Illinois | 17023 | 121 | 2 |
502684 | 502684 | 2020-09-05 | Clark | Illinois | 17023 | 121 | 2 |
499450 | 499450 | 2020-09-04 | Clark | Illinois | 17023 | 120 | 2 |
496217 | 496217 | 2020-09-03 | Clark | Illinois | 17023 | 119 | 2 |
492983 | 492983 | 2020-09-02 | Clark | Illinois | 17023 | 119 | 2 |
489750 | 489750 | 2020-09-01 | Clark | Illinois | 17023 | 116 | 2 |
486517 | 486517 | 2020-08-31 | Clark | Illinois | 17023 | 116 | 2 |
483282 | 483282 | 2020-08-30 | Clark | Illinois | 17023 | 116 | 2 |
480048 | 480048 | 2020-08-29 | Clark | Illinois | 17023 | 116 | 2 |
476815 | 476815 | 2020-08-28 | Clark | Illinois | 17023 | 115 | 2 |
473582 | 473582 | 2020-08-27 | Clark | Illinois | 17023 | 112 | 2 |
470350 | 470350 | 2020-08-26 | Clark | Illinois | 17023 | 113 | 2 |
467121 | 467121 | 2020-08-25 | Clark | Illinois | 17023 | 112 | 2 |
463892 | 463892 | 2020-08-24 | Clark | Illinois | 17023 | 112 | 2 |
460663 | 460663 | 2020-08-23 | Clark | Illinois | 17023 | 112 | 2 |
457436 | 457436 | 2020-08-22 | Clark | Illinois | 17023 | 112 | 2 |
454208 | 454208 | 2020-08-21 | Clark | Illinois | 17023 | 105 | 2 |
450980 | 450980 | 2020-08-20 | Clark | Illinois | 17023 | 104 | 2 |
447752 | 447752 | 2020-08-19 | Clark | Illinois | 17023 | 98 | 2 |
444525 | 444525 | 2020-08-18 | Clark | Illinois | 17023 | 96 | 2 |
441299 | 441299 | 2020-08-17 | Clark | Illinois | 17023 | 96 | 2 |
438073 | 438073 | 2020-08-16 | Clark | Illinois | 17023 | 95 | 2 |
434847 | 434847 | 2020-08-15 | Clark | Illinois | 17023 | 93 | 2 |
431622 | 431622 | 2020-08-14 | Clark | Illinois | 17023 | 91 | 2 |
428394 | 428394 | 2020-08-13 | Clark | Illinois | 17023 | 88 | 2 |
425170 | 425170 | 2020-08-12 | Clark | Illinois | 17023 | 87 | 2 |
421949 | 421949 | 2020-08-11 | Clark | Illinois | 17023 | 87 | 2 |
418726 | 418726 | 2020-08-10 | Clark | Illinois | 17023 | 83 | 2 |
415505 | 415505 | 2020-08-09 | Clark | Illinois | 17023 | 82 | 2 |
412285 | 412285 | 2020-08-08 | Clark | Illinois | 17023 | 81 | 2 |
409066 | 409066 | 2020-08-07 | Clark | Illinois | 17023 | 79 | 2 |
405846 | 405846 | 2020-08-06 | Clark | Illinois | 17023 | 76 | 1 |
402628 | 402628 | 2020-08-05 | Clark | Illinois | 17023 | 73 | 1 |
399412 | 399412 | 2020-08-04 | Clark | Illinois | 17023 | 70 | 0 |
396196 | 396196 | 2020-08-03 | Clark | Illinois | 17023 | 68 | 0 |
392980 | 392980 | 2020-08-02 | Clark | Illinois | 17023 | 66 | 0 |
389763 | 389763 | 2020-08-01 | Clark | Illinois | 17023 | 66 | 0 |
386546 | 386546 | 2020-07-31 | Clark | Illinois | 17023 | 66 | 0 |
383328 | 383328 | 2020-07-30 | Clark | Illinois | 17023 | 65 | 0 |
380111 | 380111 | 2020-07-29 | Clark | Illinois | 17023 | 63 | 0 |
376894 | 376894 | 2020-07-28 | Clark | Illinois | 17023 | 63 | 0 |
373679 | 373679 | 2020-07-27 | Clark | Illinois | 17023 | 59 | 0 |
370467 | 370467 | 2020-07-26 | Clark | Illinois | 17023 | 57 | 0 |
367257 | 367257 | 2020-07-25 | Clark | Illinois | 17023 | 53 | 0 |
364050 | 364050 | 2020-07-24 | Clark | Illinois | 17023 | 52 | 0 |
360843 | 360843 | 2020-07-23 | Clark | Illinois | 17023 | 51 | 0 |
357638 | 357638 | 2020-07-22 | Clark | Illinois | 17023 | 50 | 0 |
354436 | 354436 | 2020-07-21 | Clark | Illinois | 17023 | 50 | 0 |
351234 | 351234 | 2020-07-20 | Clark | Illinois | 17023 | 50 | 0 |
348034 | 348034 | 2020-07-19 | Clark | Illinois | 17023 | 49 | 0 |
344833 | 344833 | 2020-07-18 | Clark | Illinois | 17023 | 49 | 0 |
341633 | 341633 | 2020-07-17 | Clark | Illinois | 17023 | 48 | 0 |
338437 | 338437 | 2020-07-16 | Clark | Illinois | 17023 | 45 | 0 |
335241 | 335241 | 2020-07-15 | Clark | Illinois | 17023 | 45 | 0 |
332048 | 332048 | 2020-07-14 | Clark | Illinois | 17023 | 41 | 0 |
328861 | 328861 | 2020-07-13 | Clark | Illinois | 17023 | 40 | 0 |
325675 | 325675 | 2020-07-12 | Clark | Illinois | 17023 | 41 | 0 |
322494 | 322494 | 2020-07-11 | Clark | Illinois | 17023 | 40 | 0 |
319315 | 319315 | 2020-07-10 | Clark | Illinois | 17023 | 36 | 0 |
316142 | 316142 | 2020-07-09 | Clark | Illinois | 17023 | 21 | 0 |
312968 | 312968 | 2020-07-08 | Clark | Illinois | 17023 | 18 | 0 |
309798 | 309798 | 2020-07-07 | Clark | Illinois | 17023 | 15 | 0 |
306630 | 306630 | 2020-07-06 | Clark | Illinois | 17023 | 15 | 0 |
303465 | 303465 | 2020-07-05 | Clark | Illinois | 17023 | 15 | 0 |
300301 | 300301 | 2020-07-04 | Clark | Illinois | 17023 | 15 | 0 |
297139 | 297139 | 2020-07-03 | Clark | Illinois | 17023 | 15 | 0 |
293982 | 293982 | 2020-07-02 | Clark | Illinois | 17023 | 14 | 0 |
290828 | 290828 | 2020-07-01 | Clark | Illinois | 17023 | 14 | 0 |
287678 | 287678 | 2020-06-30 | Clark | Illinois | 17023 | 14 | 0 |
284529 | 284529 | 2020-06-29 | Clark | Illinois | 17023 | 15 | 0 |
281384 | 281384 | 2020-06-28 | Clark | Illinois | 17023 | 15 | 0 |
278236 | 278236 | 2020-06-27 | Clark | Illinois | 17023 | 14 | 0 |
275088 | 275088 | 2020-06-26 | Clark | Illinois | 17023 | 14 | 0 |
271946 | 271946 | 2020-06-25 | Clark | Illinois | 17023 | 14 | 0 |
268809 | 268809 | 2020-06-24 | Clark | Illinois | 17023 | 14 | 0 |
265679 | 265679 | 2020-06-23 | Clark | Illinois | 17023 | 14 | 0 |
262551 | 262551 | 2020-06-22 | Clark | Illinois | 17023 | 14 | 0 |
259424 | 259424 | 2020-06-21 | Clark | Illinois | 17023 | 13 | 0 |
256298 | 256298 | 2020-06-20 | Clark | Illinois | 17023 | 13 | 0 |
253178 | 253178 | 2020-06-19 | Clark | Illinois | 17023 | 13 | 0 |
250063 | 250063 | 2020-06-18 | Clark | Illinois | 17023 | 13 | 0 |
246951 | 246951 | 2020-06-17 | Clark | Illinois | 17023 | 13 | 0 |
243838 | 243838 | 2020-06-16 | Clark | Illinois | 17023 | 13 | 0 |
240727 | 240727 | 2020-06-15 | Clark | Illinois | 17023 | 13 | 0 |
237619 | 237619 | 2020-06-14 | Clark | Illinois | 17023 | 13 | 0 |
234512 | 234512 | 2020-06-13 | Clark | Illinois | 17023 | 12 | 0 |
231406 | 231406 | 2020-06-12 | Clark | Illinois | 17023 | 12 | 0 |
228303 | 228303 | 2020-06-11 | Clark | Illinois | 17023 | 12 | 0 |
225201 | 225201 | 2020-06-10 | Clark | Illinois | 17023 | 12 | 0 |
222106 | 222106 | 2020-06-09 | Clark | Illinois | 17023 | 12 | 0 |
219011 | 219011 | 2020-06-08 | Clark | Illinois | 17023 | 12 | 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);