ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Pulaski" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
935001 | 935001 | 2021-01-16 | Pulaski | Missouri | 29169 | 2841 | 33 |
931756 | 931756 | 2021-01-15 | Pulaski | Missouri | 29169 | 2838 | 33 |
928511 | 928511 | 2021-01-14 | Pulaski | Missouri | 29169 | 2828 | 33 |
925265 | 925265 | 2021-01-13 | Pulaski | Missouri | 29169 | 2807 | 32 |
922020 | 922020 | 2021-01-12 | Pulaski | Missouri | 29169 | 2805 | 32 |
918775 | 918775 | 2021-01-11 | Pulaski | Missouri | 29169 | 2801 | 29 |
915530 | 915530 | 2021-01-10 | Pulaski | Missouri | 29169 | 2791 | 29 |
912285 | 912285 | 2021-01-09 | Pulaski | Missouri | 29169 | 2771 | 29 |
909040 | 909040 | 2021-01-08 | Pulaski | Missouri | 29169 | 2759 | 29 |
905794 | 905794 | 2021-01-07 | Pulaski | Missouri | 29169 | 2628 | 29 |
902549 | 902549 | 2021-01-06 | Pulaski | Missouri | 29169 | 2598 | 29 |
899304 | 899304 | 2021-01-05 | Pulaski | Missouri | 29169 | 2595 | 29 |
896059 | 896059 | 2021-01-04 | Pulaski | Missouri | 29169 | 2590 | 28 |
892812 | 892812 | 2021-01-03 | Pulaski | Missouri | 29169 | 2590 | 28 |
889566 | 889566 | 2021-01-02 | Pulaski | Missouri | 29169 | 2579 | 27 |
886320 | 886320 | 2021-01-01 | Pulaski | Missouri | 29169 | 2571 | 27 |
883075 | 883075 | 2020-12-31 | Pulaski | Missouri | 29169 | 2546 | 27 |
879830 | 879830 | 2020-12-30 | Pulaski | Missouri | 29169 | 2517 | 27 |
876585 | 876585 | 2020-12-29 | Pulaski | Missouri | 29169 | 2512 | 27 |
873340 | 873340 | 2020-12-28 | Pulaski | Missouri | 29169 | 2503 | 27 |
870095 | 870095 | 2020-12-27 | Pulaski | Missouri | 29169 | 2497 | 27 |
866850 | 866850 | 2020-12-26 | Pulaski | Missouri | 29169 | 2494 | 27 |
863605 | 863605 | 2020-12-25 | Pulaski | Missouri | 29169 | 2487 | 27 |
860360 | 860360 | 2020-12-24 | Pulaski | Missouri | 29169 | 2481 | 27 |
857115 | 857115 | 2020-12-23 | Pulaski | Missouri | 29169 | 2463 | 27 |
853870 | 853870 | 2020-12-22 | Pulaski | Missouri | 29169 | 2352 | 27 |
850625 | 850625 | 2020-12-21 | Pulaski | Missouri | 29169 | 2280 | 26 |
847380 | 847380 | 2020-12-20 | Pulaski | Missouri | 29169 | 2262 | 26 |
844134 | 844134 | 2020-12-19 | Pulaski | Missouri | 29169 | 2231 | 26 |
840889 | 840889 | 2020-12-18 | Pulaski | Missouri | 29169 | 2217 | 26 |
837644 | 837644 | 2020-12-17 | Pulaski | Missouri | 29169 | 2202 | 26 |
834398 | 834398 | 2020-12-16 | Pulaski | Missouri | 29169 | 2171 | 26 |
831151 | 831151 | 2020-12-15 | Pulaski | Missouri | 29169 | 2165 | 26 |
827905 | 827905 | 2020-12-14 | Pulaski | Missouri | 29169 | 2158 | 24 |
824658 | 824658 | 2020-12-13 | Pulaski | Missouri | 29169 | 2150 | 24 |
821412 | 821412 | 2020-12-12 | Pulaski | Missouri | 29169 | 2136 | 24 |
818166 | 818166 | 2020-12-11 | Pulaski | Missouri | 29169 | 2048 | 24 |
814920 | 814920 | 2020-12-10 | Pulaski | Missouri | 29169 | 2048 | 24 |
811675 | 811675 | 2020-12-09 | Pulaski | Missouri | 29169 | 2001 | 24 |
808430 | 808430 | 2020-12-08 | Pulaski | Missouri | 29169 | 1995 | 24 |
805185 | 805185 | 2020-12-07 | Pulaski | Missouri | 29169 | 1978 | 24 |
801940 | 801940 | 2020-12-06 | Pulaski | Missouri | 29169 | 1941 | 24 |
798695 | 798695 | 2020-12-05 | Pulaski | Missouri | 29169 | 1888 | 24 |
795450 | 795450 | 2020-12-04 | Pulaski | Missouri | 29169 | 1768 | 24 |
792205 | 792205 | 2020-12-03 | Pulaski | Missouri | 29169 | 1710 | 23 |
788960 | 788960 | 2020-12-02 | Pulaski | Missouri | 29169 | 1673 | 23 |
785715 | 785715 | 2020-12-01 | Pulaski | Missouri | 29169 | 1661 | 21 |
782471 | 782471 | 2020-11-30 | Pulaski | Missouri | 29169 | 1643 | 19 |
779225 | 779225 | 2020-11-29 | Pulaski | Missouri | 29169 | 1614 | 18 |
775980 | 775980 | 2020-11-28 | Pulaski | Missouri | 29169 | 1587 | 18 |
772735 | 772735 | 2020-11-27 | Pulaski | Missouri | 29169 | 1576 | 17 |
769490 | 769490 | 2020-11-26 | Pulaski | Missouri | 29169 | 1559 | 17 |
766244 | 766244 | 2020-11-25 | Pulaski | Missouri | 29169 | 1523 | 17 |
762999 | 762999 | 2020-11-24 | Pulaski | Missouri | 29169 | 1509 | 17 |
759754 | 759754 | 2020-11-23 | Pulaski | Missouri | 29169 | 1496 | 15 |
756507 | 756507 | 2020-11-22 | Pulaski | Missouri | 29169 | 1473 | 15 |
753261 | 753261 | 2020-11-21 | Pulaski | Missouri | 29169 | 1447 | 15 |
750015 | 750015 | 2020-11-20 | Pulaski | Missouri | 29169 | 1418 | 15 |
746769 | 746769 | 2020-11-19 | Pulaski | Missouri | 29169 | 1376 | 14 |
743522 | 743522 | 2020-11-18 | Pulaski | Missouri | 29169 | 1353 | 14 |
740275 | 740275 | 2020-11-17 | Pulaski | Missouri | 29169 | 1339 | 14 |
737031 | 737031 | 2020-11-16 | Pulaski | Missouri | 29169 | 1311 | 14 |
733785 | 733785 | 2020-11-15 | Pulaski | Missouri | 29169 | 1295 | 14 |
730540 | 730540 | 2020-11-14 | Pulaski | Missouri | 29169 | 1295 | 14 |
727297 | 727297 | 2020-11-13 | Pulaski | Missouri | 29169 | 1249 | 13 |
724054 | 724054 | 2020-11-12 | Pulaski | Missouri | 29169 | 1235 | 13 |
720811 | 720811 | 2020-11-11 | Pulaski | Missouri | 29169 | 1211 | 13 |
717568 | 717568 | 2020-11-10 | Pulaski | Missouri | 29169 | 1207 | 13 |
714324 | 714324 | 2020-11-09 | Pulaski | Missouri | 29169 | 1197 | 11 |
711080 | 711080 | 2020-11-08 | Pulaski | Missouri | 29169 | 1182 | 11 |
707836 | 707836 | 2020-11-07 | Pulaski | Missouri | 29169 | 1154 | 11 |
704593 | 704593 | 2020-11-06 | Pulaski | Missouri | 29169 | 1143 | 11 |
701351 | 701351 | 2020-11-05 | Pulaski | Missouri | 29169 | 1118 | 11 |
698107 | 698107 | 2020-11-04 | Pulaski | Missouri | 29169 | 1107 | 11 |
694864 | 694864 | 2020-11-03 | Pulaski | Missouri | 29169 | 1095 | 11 |
691622 | 691622 | 2020-11-02 | Pulaski | Missouri | 29169 | 1090 | 11 |
688377 | 688377 | 2020-11-01 | Pulaski | Missouri | 29169 | 1074 | 11 |
685133 | 685133 | 2020-10-31 | Pulaski | Missouri | 29169 | 1059 | 11 |
681890 | 681890 | 2020-10-30 | Pulaski | Missouri | 29169 | 1053 | 11 |
678646 | 678646 | 2020-10-29 | Pulaski | Missouri | 29169 | 1047 | 11 |
675404 | 675404 | 2020-10-28 | Pulaski | Missouri | 29169 | 1020 | 11 |
672161 | 672161 | 2020-10-27 | Pulaski | Missouri | 29169 | 1003 | 11 |
668919 | 668919 | 2020-10-26 | Pulaski | Missouri | 29169 | 979 | 9 |
665675 | 665675 | 2020-10-25 | Pulaski | Missouri | 29169 | 963 | 9 |
662430 | 662430 | 2020-10-24 | Pulaski | Missouri | 29169 | 944 | 9 |
659186 | 659186 | 2020-10-23 | Pulaski | Missouri | 29169 | 927 | 9 |
655941 | 655941 | 2020-10-22 | Pulaski | Missouri | 29169 | 906 | 9 |
652696 | 652696 | 2020-10-21 | Pulaski | Missouri | 29169 | 901 | 9 |
649451 | 649451 | 2020-10-20 | Pulaski | Missouri | 29169 | 894 | 9 |
646207 | 646207 | 2020-10-19 | Pulaski | Missouri | 29169 | 894 | 9 |
642961 | 642961 | 2020-10-18 | Pulaski | Missouri | 29169 | 891 | 8 |
639713 | 639713 | 2020-10-17 | Pulaski | Missouri | 29169 | 875 | 8 |
636467 | 636467 | 2020-10-16 | Pulaski | Missouri | 29169 | 865 | 8 |
633221 | 633221 | 2020-10-15 | Pulaski | Missouri | 29169 | 857 | 8 |
629976 | 629976 | 2020-10-14 | Pulaski | Missouri | 29169 | 846 | 8 |
626732 | 626732 | 2020-10-13 | Pulaski | Missouri | 29169 | 819 | 8 |
623490 | 623490 | 2020-10-12 | Pulaski | Missouri | 29169 | 819 | 8 |
620247 | 620247 | 2020-10-11 | Pulaski | Missouri | 29169 | 819 | 8 |
617005 | 617005 | 2020-10-10 | Pulaski | Missouri | 29169 | 819 | 8 |
613764 | 613764 | 2020-10-09 | Pulaski | Missouri | 29169 | 776 | 8 |
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);