ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Clay" and fips = 1027 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
631653 | 631653 | 2020-10-15 | Clay | Alabama | 1027 | 674 | 12 |
628409 | 628409 | 2020-10-14 | Clay | Alabama | 1027 | 667 | 11 |
625166 | 625166 | 2020-10-13 | Clay | Alabama | 1027 | 661 | 9 |
621923 | 621923 | 2020-10-12 | Clay | Alabama | 1027 | 650 | 9 |
618680 | 618680 | 2020-10-11 | Clay | Alabama | 1027 | 646 | 9 |
615438 | 615438 | 2020-10-10 | Clay | Alabama | 1027 | 641 | 9 |
612197 | 612197 | 2020-10-09 | Clay | Alabama | 1027 | 634 | 9 |
608955 | 608955 | 2020-10-08 | Clay | Alabama | 1027 | 627 | 9 |
605712 | 605712 | 2020-10-07 | Clay | Alabama | 1027 | 623 | 9 |
602470 | 602470 | 2020-10-06 | Clay | Alabama | 1027 | 614 | 9 |
599227 | 599227 | 2020-10-05 | Clay | Alabama | 1027 | 613 | 9 |
595984 | 595984 | 2020-10-04 | Clay | Alabama | 1027 | 611 | 9 |
592742 | 592742 | 2020-10-03 | Clay | Alabama | 1027 | 608 | 9 |
589502 | 589502 | 2020-10-02 | Clay | Alabama | 1027 | 600 | 9 |
586261 | 586261 | 2020-10-01 | Clay | Alabama | 1027 | 594 | 9 |
583021 | 583021 | 2020-09-30 | Clay | Alabama | 1027 | 592 | 9 |
579782 | 579782 | 2020-09-29 | Clay | Alabama | 1027 | 591 | 8 |
576541 | 576541 | 2020-09-28 | Clay | Alabama | 1027 | 592 | 8 |
573297 | 573297 | 2020-09-27 | Clay | Alabama | 1027 | 587 | 8 |
570055 | 570055 | 2020-09-26 | Clay | Alabama | 1027 | 585 | 8 |
566814 | 566814 | 2020-09-25 | Clay | Alabama | 1027 | 579 | 7 |
563573 | 563573 | 2020-09-24 | Clay | Alabama | 1027 | 570 | 7 |
560334 | 560334 | 2020-09-23 | Clay | Alabama | 1027 | 554 | 7 |
557098 | 557098 | 2020-09-22 | Clay | Alabama | 1027 | 553 | 7 |
553861 | 553861 | 2020-09-21 | Clay | Alabama | 1027 | 552 | 7 |
550622 | 550622 | 2020-09-20 | Clay | Alabama | 1027 | 542 | 7 |
547383 | 547383 | 2020-09-19 | Clay | Alabama | 1027 | 536 | 7 |
544146 | 544146 | 2020-09-18 | Clay | Alabama | 1027 | 531 | 7 |
540910 | 540910 | 2020-09-17 | Clay | Alabama | 1027 | 518 | 7 |
537673 | 537673 | 2020-09-16 | Clay | Alabama | 1027 | 505 | 7 |
534437 | 534437 | 2020-09-15 | Clay | Alabama | 1027 | 495 | 7 |
531202 | 531202 | 2020-09-14 | Clay | Alabama | 1027 | 486 | 7 |
527965 | 527965 | 2020-09-13 | Clay | Alabama | 1027 | 478 | 7 |
524729 | 524729 | 2020-09-12 | Clay | Alabama | 1027 | 464 | 7 |
521493 | 521493 | 2020-09-11 | Clay | Alabama | 1027 | 460 | 7 |
518256 | 518256 | 2020-09-10 | Clay | Alabama | 1027 | 456 | 6 |
515021 | 515021 | 2020-09-09 | Clay | Alabama | 1027 | 439 | 6 |
511788 | 511788 | 2020-09-08 | Clay | Alabama | 1027 | 428 | 6 |
508555 | 508555 | 2020-09-07 | Clay | Alabama | 1027 | 425 | 6 |
505323 | 505323 | 2020-09-06 | Clay | Alabama | 1027 | 420 | 6 |
502089 | 502089 | 2020-09-05 | Clay | Alabama | 1027 | 416 | 6 |
498855 | 498855 | 2020-09-04 | Clay | Alabama | 1027 | 399 | 6 |
495622 | 495622 | 2020-09-03 | Clay | Alabama | 1027 | 390 | 6 |
492388 | 492388 | 2020-09-02 | Clay | Alabama | 1027 | 385 | 6 |
489155 | 489155 | 2020-09-01 | Clay | Alabama | 1027 | 379 | 6 |
485922 | 485922 | 2020-08-31 | Clay | Alabama | 1027 | 373 | 6 |
482687 | 482687 | 2020-08-30 | Clay | Alabama | 1027 | 370 | 6 |
479453 | 479453 | 2020-08-29 | Clay | Alabama | 1027 | 360 | 6 |
476220 | 476220 | 2020-08-28 | Clay | Alabama | 1027 | 357 | 6 |
472987 | 472987 | 2020-08-27 | Clay | Alabama | 1027 | 347 | 6 |
469755 | 469755 | 2020-08-26 | Clay | Alabama | 1027 | 349 | 6 |
466526 | 466526 | 2020-08-25 | Clay | Alabama | 1027 | 331 | 6 |
463297 | 463297 | 2020-08-24 | Clay | Alabama | 1027 | 331 | 6 |
460068 | 460068 | 2020-08-23 | Clay | Alabama | 1027 | 328 | 6 |
456841 | 456841 | 2020-08-22 | Clay | Alabama | 1027 | 328 | 6 |
453613 | 453613 | 2020-08-21 | Clay | Alabama | 1027 | 329 | 5 |
450385 | 450385 | 2020-08-20 | Clay | Alabama | 1027 | 326 | 5 |
447157 | 447157 | 2020-08-19 | Clay | Alabama | 1027 | 325 | 5 |
443930 | 443930 | 2020-08-18 | Clay | Alabama | 1027 | 323 | 5 |
440704 | 440704 | 2020-08-17 | Clay | Alabama | 1027 | 317 | 5 |
437478 | 437478 | 2020-08-16 | Clay | Alabama | 1027 | 314 | 5 |
434252 | 434252 | 2020-08-15 | Clay | Alabama | 1027 | 307 | 5 |
431027 | 431027 | 2020-08-14 | Clay | Alabama | 1027 | 287 | 5 |
427799 | 427799 | 2020-08-13 | Clay | Alabama | 1027 | 287 | 5 |
424575 | 424575 | 2020-08-12 | Clay | Alabama | 1027 | 284 | 5 |
421354 | 421354 | 2020-08-11 | Clay | Alabama | 1027 | 274 | 5 |
418133 | 418133 | 2020-08-10 | Clay | Alabama | 1027 | 268 | 5 |
414912 | 414912 | 2020-08-09 | Clay | Alabama | 1027 | 263 | 5 |
411692 | 411692 | 2020-08-08 | Clay | Alabama | 1027 | 257 | 5 |
408473 | 408473 | 2020-08-07 | Clay | Alabama | 1027 | 254 | 5 |
405253 | 405253 | 2020-08-06 | Clay | Alabama | 1027 | 241 | 5 |
402035 | 402035 | 2020-08-05 | Clay | Alabama | 1027 | 229 | 5 |
398819 | 398819 | 2020-08-04 | Clay | Alabama | 1027 | 226 | 5 |
395603 | 395603 | 2020-08-03 | Clay | Alabama | 1027 | 220 | 5 |
392387 | 392387 | 2020-08-02 | Clay | Alabama | 1027 | 219 | 5 |
389170 | 389170 | 2020-08-01 | Clay | Alabama | 1027 | 204 | 5 |
385953 | 385953 | 2020-07-31 | Clay | Alabama | 1027 | 198 | 5 |
382735 | 382735 | 2020-07-30 | Clay | Alabama | 1027 | 193 | 5 |
379518 | 379518 | 2020-07-29 | Clay | Alabama | 1027 | 185 | 4 |
376302 | 376302 | 2020-07-28 | Clay | Alabama | 1027 | 180 | 4 |
373088 | 373088 | 2020-07-27 | Clay | Alabama | 1027 | 178 | 4 |
369876 | 369876 | 2020-07-26 | Clay | Alabama | 1027 | 169 | 3 |
366666 | 366666 | 2020-07-25 | Clay | Alabama | 1027 | 151 | 3 |
363459 | 363459 | 2020-07-24 | Clay | Alabama | 1027 | 143 | 3 |
360253 | 360253 | 2020-07-23 | Clay | Alabama | 1027 | 139 | 2 |
357048 | 357048 | 2020-07-22 | Clay | Alabama | 1027 | 137 | 2 |
353845 | 353845 | 2020-07-21 | Clay | Alabama | 1027 | 134 | 2 |
350643 | 350643 | 2020-07-20 | Clay | Alabama | 1027 | 125 | 2 |
347442 | 347442 | 2020-07-19 | Clay | Alabama | 1027 | 118 | 2 |
344242 | 344242 | 2020-07-18 | Clay | Alabama | 1027 | 109 | 2 |
341043 | 341043 | 2020-07-17 | Clay | Alabama | 1027 | 98 | 2 |
337847 | 337847 | 2020-07-16 | Clay | Alabama | 1027 | 97 | 2 |
334652 | 334652 | 2020-07-15 | Clay | Alabama | 1027 | 94 | 2 |
331459 | 331459 | 2020-07-14 | Clay | Alabama | 1027 | 92 | 2 |
328273 | 328273 | 2020-07-13 | Clay | Alabama | 1027 | 89 | 2 |
325087 | 325087 | 2020-07-12 | Clay | Alabama | 1027 | 85 | 2 |
321906 | 321906 | 2020-07-11 | Clay | Alabama | 1027 | 85 | 2 |
318727 | 318727 | 2020-07-10 | Clay | Alabama | 1027 | 82 | 2 |
315554 | 315554 | 2020-07-09 | Clay | Alabama | 1027 | 74 | 2 |
312379 | 312379 | 2020-07-08 | Clay | Alabama | 1027 | 69 | 2 |
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);