ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 5045 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
274620 | 274620 | 2020-06-26 | Faulkner | Arkansas | 5045 | 382 | 3 |
277768 | 277768 | 2020-06-27 | Faulkner | Arkansas | 5045 | 409 | 3 |
280915 | 280915 | 2020-06-28 | Faulkner | Arkansas | 5045 | 437 | 3 |
284061 | 284061 | 2020-06-29 | Faulkner | Arkansas | 5045 | 453 | 3 |
287207 | 287207 | 2020-06-30 | Faulkner | Arkansas | 5045 | 477 | 3 |
290358 | 290358 | 2020-07-01 | Faulkner | Arkansas | 5045 | 492 | 3 |
293512 | 293512 | 2020-07-02 | Faulkner | Arkansas | 5045 | 529 | 3 |
296668 | 296668 | 2020-07-03 | Faulkner | Arkansas | 5045 | 545 | 3 |
299830 | 299830 | 2020-07-04 | Faulkner | Arkansas | 5045 | 564 | 3 |
302994 | 302994 | 2020-07-05 | Faulkner | Arkansas | 5045 | 593 | 3 |
306158 | 306158 | 2020-07-06 | Faulkner | Arkansas | 5045 | 612 | 3 |
309326 | 309326 | 2020-07-07 | Faulkner | Arkansas | 5045 | 622 | 3 |
312496 | 312496 | 2020-07-08 | Faulkner | Arkansas | 5045 | 648 | 3 |
315671 | 315671 | 2020-07-09 | Faulkner | Arkansas | 5045 | 701 | 3 |
318844 | 318844 | 2020-07-10 | Faulkner | Arkansas | 5045 | 727 | 3 |
322023 | 322023 | 2020-07-11 | Faulkner | Arkansas | 5045 | 757 | 3 |
325204 | 325204 | 2020-07-12 | Faulkner | Arkansas | 5045 | 771 | 3 |
328390 | 328390 | 2020-07-13 | Faulkner | Arkansas | 5045 | 788 | 3 |
331576 | 331576 | 2020-07-14 | Faulkner | Arkansas | 5045 | 810 | 4 |
334769 | 334769 | 2020-07-15 | Faulkner | Arkansas | 5045 | 830 | 4 |
337964 | 337964 | 2020-07-16 | Faulkner | Arkansas | 5045 | 857 | 4 |
341160 | 341160 | 2020-07-17 | Faulkner | Arkansas | 5045 | 869 | 4 |
344359 | 344359 | 2020-07-18 | Faulkner | Arkansas | 5045 | 888 | 4 |
347559 | 347559 | 2020-07-19 | Faulkner | Arkansas | 5045 | 905 | 4 |
350760 | 350760 | 2020-07-20 | Faulkner | Arkansas | 5045 | 926 | 4 |
353962 | 353962 | 2020-07-21 | Faulkner | Arkansas | 5045 | 940 | 4 |
357165 | 357165 | 2020-07-22 | Faulkner | Arkansas | 5045 | 970 | 4 |
360370 | 360370 | 2020-07-23 | Faulkner | Arkansas | 5045 | 996 | 4 |
363577 | 363577 | 2020-07-24 | Faulkner | Arkansas | 5045 | 1013 | 4 |
366784 | 366784 | 2020-07-25 | Faulkner | Arkansas | 5045 | 1046 | 4 |
369994 | 369994 | 2020-07-26 | Faulkner | Arkansas | 5045 | 1063 | 4 |
373206 | 373206 | 2020-07-27 | Faulkner | Arkansas | 5045 | 1081 | 4 |
376420 | 376420 | 2020-07-28 | Faulkner | Arkansas | 5045 | 1120 | 4 |
379636 | 379636 | 2020-07-29 | Faulkner | Arkansas | 5045 | 1138 | 4 |
382853 | 382853 | 2020-07-30 | Faulkner | Arkansas | 5045 | 1158 | 5 |
386071 | 386071 | 2020-07-31 | Faulkner | Arkansas | 5045 | 1175 | 5 |
389288 | 389288 | 2020-08-01 | Faulkner | Arkansas | 5045 | 1190 | 5 |
392505 | 392505 | 2020-08-02 | Faulkner | Arkansas | 5045 | 1203 | 5 |
395721 | 395721 | 2020-08-03 | Faulkner | Arkansas | 5045 | 1212 | 5 |
398937 | 398937 | 2020-08-04 | Faulkner | Arkansas | 5045 | 1229 | 5 |
402153 | 402153 | 2020-08-05 | Faulkner | Arkansas | 5045 | 1239 | 5 |
405371 | 405371 | 2020-08-06 | Faulkner | Arkansas | 5045 | 1252 | 5 |
408591 | 408591 | 2020-08-07 | Faulkner | Arkansas | 5045 | 1278 | 6 |
411810 | 411810 | 2020-08-08 | Faulkner | Arkansas | 5045 | 1290 | 6 |
415030 | 415030 | 2020-08-09 | Faulkner | Arkansas | 5045 | 1304 | 6 |
418251 | 418251 | 2020-08-10 | Faulkner | Arkansas | 5045 | 1319 | 6 |
421472 | 421472 | 2020-08-11 | Faulkner | Arkansas | 5045 | 1330 | 6 |
424693 | 424693 | 2020-08-12 | Faulkner | Arkansas | 5045 | 1340 | 6 |
427917 | 427917 | 2020-08-13 | Faulkner | Arkansas | 5045 | 1361 | 6 |
431145 | 431145 | 2020-08-14 | Faulkner | Arkansas | 5045 | 1370 | 6 |
434370 | 434370 | 2020-08-15 | Faulkner | Arkansas | 5045 | 1375 | 6 |
437596 | 437596 | 2020-08-16 | Faulkner | Arkansas | 5045 | 1397 | 6 |
440822 | 440822 | 2020-08-17 | Faulkner | Arkansas | 5045 | 1402 | 6 |
444048 | 444048 | 2020-08-18 | Faulkner | Arkansas | 5045 | 1412 | 7 |
447275 | 447275 | 2020-08-19 | Faulkner | Arkansas | 5045 | 1422 | 7 |
450503 | 450503 | 2020-08-20 | Faulkner | Arkansas | 5045 | 1438 | 7 |
453731 | 453731 | 2020-08-21 | Faulkner | Arkansas | 5045 | 1468 | 7 |
456959 | 456959 | 2020-08-22 | Faulkner | Arkansas | 5045 | 1485 | 7 |
460186 | 460186 | 2020-08-23 | Faulkner | Arkansas | 5045 | 1500 | 7 |
463415 | 463415 | 2020-08-24 | Faulkner | Arkansas | 5045 | 1535 | 7 |
466644 | 466644 | 2020-08-25 | Faulkner | Arkansas | 5045 | 1579 | 7 |
469873 | 469873 | 2020-08-26 | Faulkner | Arkansas | 5045 | 1593 | 8 |
473105 | 473105 | 2020-08-27 | Faulkner | Arkansas | 5045 | 1610 | 8 |
476338 | 476338 | 2020-08-28 | Faulkner | Arkansas | 5045 | 1640 | 8 |
479571 | 479571 | 2020-08-29 | Faulkner | Arkansas | 5045 | 1649 | 8 |
482805 | 482805 | 2020-08-30 | Faulkner | Arkansas | 5045 | 1679 | 8 |
486040 | 486040 | 2020-08-31 | Faulkner | Arkansas | 5045 | 1693 | 9 |
489273 | 489273 | 2020-09-01 | Faulkner | Arkansas | 5045 | 1703 | 9 |
492506 | 492506 | 2020-09-02 | Faulkner | Arkansas | 5045 | 1719 | 9 |
495740 | 495740 | 2020-09-03 | Faulkner | Arkansas | 5045 | 1747 | 9 |
498973 | 498973 | 2020-09-04 | Faulkner | Arkansas | 5045 | 1758 | 9 |
502207 | 502207 | 2020-09-05 | Faulkner | Arkansas | 5045 | 1770 | 9 |
505441 | 505441 | 2020-09-06 | Faulkner | Arkansas | 5045 | 1790 | 9 |
508673 | 508673 | 2020-09-07 | Faulkner | Arkansas | 5045 | 1798 | 9 |
511906 | 511906 | 2020-09-08 | Faulkner | Arkansas | 5045 | 1809 | 9 |
515139 | 515139 | 2020-09-09 | Faulkner | Arkansas | 5045 | 1827 | 9 |
518374 | 518374 | 2020-09-10 | Faulkner | Arkansas | 5045 | 1840 | 10 |
521611 | 521611 | 2020-09-11 | Faulkner | Arkansas | 5045 | 1873 | 10 |
524847 | 524847 | 2020-09-12 | Faulkner | Arkansas | 5045 | 1962 | 12 |
528083 | 528083 | 2020-09-13 | Faulkner | Arkansas | 5045 | 2012 | 12 |
531320 | 531320 | 2020-09-14 | Faulkner | Arkansas | 5045 | 2031 | 12 |
534555 | 534555 | 2020-09-15 | Faulkner | Arkansas | 5045 | 2061 | 15 |
537791 | 537791 | 2020-09-16 | Faulkner | Arkansas | 5045 | 2103 | 15 |
541028 | 541028 | 2020-09-17 | Faulkner | Arkansas | 5045 | 2138 | 16 |
544264 | 544264 | 2020-09-18 | Faulkner | Arkansas | 5045 | 2167 | 17 |
547502 | 547502 | 2020-09-19 | Faulkner | Arkansas | 5045 | 2201 | 17 |
550741 | 550741 | 2020-09-20 | Faulkner | Arkansas | 5045 | 2260 | 17 |
553980 | 553980 | 2020-09-21 | Faulkner | Arkansas | 5045 | 2277 | 19 |
557217 | 557217 | 2020-09-22 | Faulkner | Arkansas | 5045 | 2308 | 19 |
560453 | 560453 | 2020-09-23 | Faulkner | Arkansas | 5045 | 2363 | 19 |
563692 | 563692 | 2020-09-24 | Faulkner | Arkansas | 5045 | 2391 | 19 |
566932 | 566932 | 2020-09-25 | Faulkner | Arkansas | 5045 | 2432 | 19 |
570174 | 570174 | 2020-09-26 | Faulkner | Arkansas | 5045 | 2452 | 19 |
573416 | 573416 | 2020-09-27 | Faulkner | Arkansas | 5045 | 2473 | 19 |
576659 | 576659 | 2020-09-28 | Faulkner | Arkansas | 5045 | 2502 | 19 |
579900 | 579900 | 2020-09-29 | Faulkner | Arkansas | 5045 | 2531 | 20 |
583139 | 583139 | 2020-09-30 | Faulkner | Arkansas | 5045 | 2566 | 20 |
586379 | 586379 | 2020-10-01 | Faulkner | Arkansas | 5045 | 2596 | 20 |
589620 | 589620 | 2020-10-02 | Faulkner | Arkansas | 5045 | 2643 | 20 |
592860 | 592860 | 2020-10-03 | Faulkner | Arkansas | 5045 | 2679 | 22 |
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);