ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Fayette" and fips = 17051 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535046 | 535046 | 2020-09-15 | Fayette | Illinois | 17051 | 266 | 3 |
531811 | 531811 | 2020-09-14 | Fayette | Illinois | 17051 | 260 | 3 |
528574 | 528574 | 2020-09-13 | Fayette | Illinois | 17051 | 255 | 3 |
525338 | 525338 | 2020-09-12 | Fayette | Illinois | 17051 | 246 | 3 |
522102 | 522102 | 2020-09-11 | Fayette | Illinois | 17051 | 243 | 3 |
518865 | 518865 | 2020-09-10 | Fayette | Illinois | 17051 | 227 | 3 |
515630 | 515630 | 2020-09-09 | Fayette | Illinois | 17051 | 217 | 3 |
512397 | 512397 | 2020-09-08 | Fayette | Illinois | 17051 | 217 | 3 |
509164 | 509164 | 2020-09-07 | Fayette | Illinois | 17051 | 214 | 3 |
505932 | 505932 | 2020-09-06 | Fayette | Illinois | 17051 | 212 | 3 |
502698 | 502698 | 2020-09-05 | Fayette | Illinois | 17051 | 202 | 3 |
499464 | 499464 | 2020-09-04 | Fayette | Illinois | 17051 | 196 | 3 |
496231 | 496231 | 2020-09-03 | Fayette | Illinois | 17051 | 183 | 3 |
492997 | 492997 | 2020-09-02 | Fayette | Illinois | 17051 | 176 | 3 |
489764 | 489764 | 2020-09-01 | Fayette | Illinois | 17051 | 172 | 3 |
486531 | 486531 | 2020-08-31 | Fayette | Illinois | 17051 | 169 | 3 |
483296 | 483296 | 2020-08-30 | Fayette | Illinois | 17051 | 165 | 3 |
480062 | 480062 | 2020-08-29 | Fayette | Illinois | 17051 | 163 | 3 |
476829 | 476829 | 2020-08-28 | Fayette | Illinois | 17051 | 153 | 3 |
473596 | 473596 | 2020-08-27 | Fayette | Illinois | 17051 | 144 | 3 |
470364 | 470364 | 2020-08-26 | Fayette | Illinois | 17051 | 140 | 3 |
467135 | 467135 | 2020-08-25 | Fayette | Illinois | 17051 | 127 | 3 |
463906 | 463906 | 2020-08-24 | Fayette | Illinois | 17051 | 120 | 3 |
460677 | 460677 | 2020-08-23 | Fayette | Illinois | 17051 | 115 | 3 |
457450 | 457450 | 2020-08-22 | Fayette | Illinois | 17051 | 108 | 3 |
454222 | 454222 | 2020-08-21 | Fayette | Illinois | 17051 | 103 | 3 |
450994 | 450994 | 2020-08-20 | Fayette | Illinois | 17051 | 97 | 3 |
447766 | 447766 | 2020-08-19 | Fayette | Illinois | 17051 | 87 | 3 |
444539 | 444539 | 2020-08-18 | Fayette | Illinois | 17051 | 81 | 3 |
441313 | 441313 | 2020-08-17 | Fayette | Illinois | 17051 | 80 | 3 |
438087 | 438087 | 2020-08-16 | Fayette | Illinois | 17051 | 78 | 3 |
434861 | 434861 | 2020-08-15 | Fayette | Illinois | 17051 | 78 | 3 |
431636 | 431636 | 2020-08-14 | Fayette | Illinois | 17051 | 73 | 3 |
428408 | 428408 | 2020-08-13 | Fayette | Illinois | 17051 | 73 | 3 |
425184 | 425184 | 2020-08-12 | Fayette | Illinois | 17051 | 71 | 3 |
421963 | 421963 | 2020-08-11 | Fayette | Illinois | 17051 | 69 | 3 |
418740 | 418740 | 2020-08-10 | Fayette | Illinois | 17051 | 67 | 3 |
415519 | 415519 | 2020-08-09 | Fayette | Illinois | 17051 | 66 | 3 |
412299 | 412299 | 2020-08-08 | Fayette | Illinois | 17051 | 65 | 3 |
409080 | 409080 | 2020-08-07 | Fayette | Illinois | 17051 | 60 | 3 |
405860 | 405860 | 2020-08-06 | Fayette | Illinois | 17051 | 60 | 3 |
402642 | 402642 | 2020-08-05 | Fayette | Illinois | 17051 | 58 | 3 |
399426 | 399426 | 2020-08-04 | Fayette | Illinois | 17051 | 58 | 3 |
396210 | 396210 | 2020-08-03 | Fayette | Illinois | 17051 | 58 | 3 |
392994 | 392994 | 2020-08-02 | Fayette | Illinois | 17051 | 55 | 3 |
389777 | 389777 | 2020-08-01 | Fayette | Illinois | 17051 | 54 | 3 |
386560 | 386560 | 2020-07-31 | Fayette | Illinois | 17051 | 53 | 3 |
383342 | 383342 | 2020-07-30 | Fayette | Illinois | 17051 | 52 | 3 |
380125 | 380125 | 2020-07-29 | Fayette | Illinois | 17051 | 51 | 3 |
376908 | 376908 | 2020-07-28 | Fayette | Illinois | 17051 | 44 | 3 |
373693 | 373693 | 2020-07-27 | Fayette | Illinois | 17051 | 43 | 3 |
370481 | 370481 | 2020-07-26 | Fayette | Illinois | 17051 | 43 | 3 |
367271 | 367271 | 2020-07-25 | Fayette | Illinois | 17051 | 41 | 3 |
364064 | 364064 | 2020-07-24 | Fayette | Illinois | 17051 | 41 | 3 |
360857 | 360857 | 2020-07-23 | Fayette | Illinois | 17051 | 40 | 3 |
357652 | 357652 | 2020-07-22 | Fayette | Illinois | 17051 | 39 | 3 |
354450 | 354450 | 2020-07-21 | Fayette | Illinois | 17051 | 39 | 3 |
351248 | 351248 | 2020-07-20 | Fayette | Illinois | 17051 | 38 | 3 |
348048 | 348048 | 2020-07-19 | Fayette | Illinois | 17051 | 35 | 3 |
344847 | 344847 | 2020-07-18 | Fayette | Illinois | 17051 | 34 | 3 |
341647 | 341647 | 2020-07-17 | Fayette | Illinois | 17051 | 32 | 3 |
338451 | 338451 | 2020-07-16 | Fayette | Illinois | 17051 | 30 | 3 |
335255 | 335255 | 2020-07-15 | Fayette | Illinois | 17051 | 28 | 3 |
332062 | 332062 | 2020-07-14 | Fayette | Illinois | 17051 | 26 | 3 |
328875 | 328875 | 2020-07-13 | Fayette | Illinois | 17051 | 25 | 3 |
325689 | 325689 | 2020-07-12 | Fayette | Illinois | 17051 | 24 | 3 |
322508 | 322508 | 2020-07-11 | Fayette | Illinois | 17051 | 24 | 3 |
319329 | 319329 | 2020-07-10 | Fayette | Illinois | 17051 | 23 | 3 |
316156 | 316156 | 2020-07-09 | Fayette | Illinois | 17051 | 23 | 3 |
312982 | 312982 | 2020-07-08 | Fayette | Illinois | 17051 | 24 | 3 |
309812 | 309812 | 2020-07-07 | Fayette | Illinois | 17051 | 23 | 3 |
306644 | 306644 | 2020-07-06 | Fayette | Illinois | 17051 | 23 | 3 |
303479 | 303479 | 2020-07-05 | Fayette | Illinois | 17051 | 23 | 3 |
300315 | 300315 | 2020-07-04 | Fayette | Illinois | 17051 | 23 | 3 |
297153 | 297153 | 2020-07-03 | Fayette | Illinois | 17051 | 23 | 3 |
293996 | 293996 | 2020-07-02 | Fayette | Illinois | 17051 | 23 | 3 |
290842 | 290842 | 2020-07-01 | Fayette | Illinois | 17051 | 23 | 3 |
287692 | 287692 | 2020-06-30 | Fayette | Illinois | 17051 | 23 | 3 |
284543 | 284543 | 2020-06-29 | Fayette | Illinois | 17051 | 23 | 3 |
281398 | 281398 | 2020-06-28 | Fayette | Illinois | 17051 | 23 | 3 |
278250 | 278250 | 2020-06-27 | Fayette | Illinois | 17051 | 23 | 3 |
275102 | 275102 | 2020-06-26 | Fayette | Illinois | 17051 | 23 | 3 |
271960 | 271960 | 2020-06-25 | Fayette | Illinois | 17051 | 23 | 3 |
268823 | 268823 | 2020-06-24 | Fayette | Illinois | 17051 | 23 | 3 |
265693 | 265693 | 2020-06-23 | Fayette | Illinois | 17051 | 23 | 3 |
262565 | 262565 | 2020-06-22 | Fayette | Illinois | 17051 | 23 | 3 |
259438 | 259438 | 2020-06-21 | Fayette | Illinois | 17051 | 23 | 3 |
256312 | 256312 | 2020-06-20 | Fayette | Illinois | 17051 | 23 | 3 |
253192 | 253192 | 2020-06-19 | Fayette | Illinois | 17051 | 23 | 3 |
250077 | 250077 | 2020-06-18 | Fayette | Illinois | 17051 | 23 | 3 |
246965 | 246965 | 2020-06-17 | Fayette | Illinois | 17051 | 23 | 3 |
243852 | 243852 | 2020-06-16 | Fayette | Illinois | 17051 | 22 | 3 |
240741 | 240741 | 2020-06-15 | Fayette | Illinois | 17051 | 22 | 3 |
237633 | 237633 | 2020-06-14 | Fayette | Illinois | 17051 | 22 | 3 |
234526 | 234526 | 2020-06-13 | Fayette | Illinois | 17051 | 22 | 3 |
231420 | 231420 | 2020-06-12 | Fayette | Illinois | 17051 | 22 | 3 |
228317 | 228317 | 2020-06-11 | Fayette | Illinois | 17051 | 22 | 3 |
225215 | 225215 | 2020-06-10 | Fayette | Illinois | 17051 | 22 | 3 |
222120 | 222120 | 2020-06-09 | Fayette | Illinois | 17051 | 21 | 3 |
219025 | 219025 | 2020-06-08 | Fayette | Illinois | 17051 | 21 | 3 |
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);