ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Lafayette" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1064794 | 1064794 | 2021-02-25 | Lafayette | Missouri | 29107 | 2542 | 53 |
1061550 | 1061550 | 2021-02-24 | Lafayette | Missouri | 29107 | 2538 | 53 |
1058304 | 1058304 | 2021-02-23 | Lafayette | Missouri | 29107 | 2534 | 53 |
1055058 | 1055058 | 2021-02-22 | Lafayette | Missouri | 29107 | 2533 | 53 |
1051811 | 1051811 | 2021-02-21 | Lafayette | Missouri | 29107 | 2532 | 53 |
1048564 | 1048564 | 2021-02-20 | Lafayette | Missouri | 29107 | 2527 | 53 |
1045318 | 1045318 | 2021-02-19 | Lafayette | Missouri | 29107 | 2522 | 53 |
1042073 | 1042073 | 2021-02-18 | Lafayette | Missouri | 29107 | 2520 | 53 |
1038828 | 1038828 | 2021-02-17 | Lafayette | Missouri | 29107 | 2514 | 52 |
1035583 | 1035583 | 2021-02-16 | Lafayette | Missouri | 29107 | 2509 | 48 |
1032338 | 1032338 | 2021-02-15 | Lafayette | Missouri | 29107 | 2507 | 48 |
1029091 | 1029091 | 2021-02-14 | Lafayette | Missouri | 29107 | 2505 | 48 |
1025845 | 1025845 | 2021-02-13 | Lafayette | Missouri | 29107 | 2502 | 48 |
1022600 | 1022600 | 2021-02-12 | Lafayette | Missouri | 29107 | 2495 | 48 |
1019355 | 1019355 | 2021-02-11 | Lafayette | Missouri | 29107 | 2486 | 48 |
1016110 | 1016110 | 2021-02-10 | Lafayette | Missouri | 29107 | 2482 | 48 |
1012865 | 1012865 | 2021-02-09 | Lafayette | Missouri | 29107 | 2478 | 48 |
1009620 | 1009620 | 2021-02-08 | Lafayette | Missouri | 29107 | 2470 | 48 |
1006373 | 1006373 | 2021-02-07 | Lafayette | Missouri | 29107 | 2467 | 48 |
1003127 | 1003127 | 2021-02-06 | Lafayette | Missouri | 29107 | 2466 | 48 |
999882 | 999882 | 2021-02-05 | Lafayette | Missouri | 29107 | 2456 | 48 |
996636 | 996636 | 2021-02-04 | Lafayette | Missouri | 29107 | 2449 | 48 |
993390 | 993390 | 2021-02-03 | Lafayette | Missouri | 29107 | 2428 | 48 |
990144 | 990144 | 2021-02-02 | Lafayette | Missouri | 29107 | 2424 | 48 |
986897 | 986897 | 2021-02-01 | Lafayette | Missouri | 29107 | 2412 | 46 |
983650 | 983650 | 2021-01-31 | Lafayette | Missouri | 29107 | 2410 | 46 |
980404 | 980404 | 2021-01-30 | Lafayette | Missouri | 29107 | 2401 | 46 |
977158 | 977158 | 2021-01-29 | Lafayette | Missouri | 29107 | 2391 | 46 |
973913 | 973913 | 2021-01-28 | Lafayette | Missouri | 29107 | 2376 | 46 |
970668 | 970668 | 2021-01-27 | Lafayette | Missouri | 29107 | 2366 | 46 |
967423 | 967423 | 2021-01-26 | Lafayette | Missouri | 29107 | 2362 | 46 |
964179 | 964179 | 2021-01-25 | Lafayette | Missouri | 29107 | 2361 | 45 |
960934 | 960934 | 2021-01-24 | Lafayette | Missouri | 29107 | 2358 | 45 |
957688 | 957688 | 2021-01-23 | Lafayette | Missouri | 29107 | 2343 | 45 |
954443 | 954443 | 2021-01-22 | Lafayette | Missouri | 29107 | 2334 | 45 |
951198 | 951198 | 2021-01-21 | Lafayette | Missouri | 29107 | 2326 | 45 |
947952 | 947952 | 2021-01-20 | Lafayette | Missouri | 29107 | 2313 | 45 |
944705 | 944705 | 2021-01-19 | Lafayette | Missouri | 29107 | 2295 | 44 |
941460 | 941460 | 2021-01-18 | Lafayette | Missouri | 29107 | 2283 | 44 |
938215 | 938215 | 2021-01-17 | Lafayette | Missouri | 29107 | 2278 | 44 |
934970 | 934970 | 2021-01-16 | Lafayette | Missouri | 29107 | 2272 | 44 |
931725 | 931725 | 2021-01-15 | Lafayette | Missouri | 29107 | 2269 | 44 |
928480 | 928480 | 2021-01-14 | Lafayette | Missouri | 29107 | 2261 | 44 |
925234 | 925234 | 2021-01-13 | Lafayette | Missouri | 29107 | 2243 | 44 |
921989 | 921989 | 2021-01-12 | Lafayette | Missouri | 29107 | 2241 | 44 |
918744 | 918744 | 2021-01-11 | Lafayette | Missouri | 29107 | 2223 | 43 |
915499 | 915499 | 2021-01-10 | Lafayette | Missouri | 29107 | 2213 | 43 |
912254 | 912254 | 2021-01-09 | Lafayette | Missouri | 29107 | 2204 | 43 |
909009 | 909009 | 2021-01-08 | Lafayette | Missouri | 29107 | 2191 | 43 |
905763 | 905763 | 2021-01-07 | Lafayette | Missouri | 29107 | 2170 | 42 |
902518 | 902518 | 2021-01-06 | Lafayette | Missouri | 29107 | 2152 | 42 |
899273 | 899273 | 2021-01-05 | Lafayette | Missouri | 29107 | 2140 | 42 |
896028 | 896028 | 2021-01-04 | Lafayette | Missouri | 29107 | 2125 | 40 |
892781 | 892781 | 2021-01-03 | Lafayette | Missouri | 29107 | 2125 | 40 |
889535 | 889535 | 2021-01-02 | Lafayette | Missouri | 29107 | 2114 | 40 |
886289 | 886289 | 2021-01-01 | Lafayette | Missouri | 29107 | 2092 | 40 |
883044 | 883044 | 2020-12-31 | Lafayette | Missouri | 29107 | 2058 | 40 |
879799 | 879799 | 2020-12-30 | Lafayette | Missouri | 29107 | 2055 | 40 |
876554 | 876554 | 2020-12-29 | Lafayette | Missouri | 29107 | 2034 | 40 |
873309 | 873309 | 2020-12-28 | Lafayette | Missouri | 29107 | 2014 | 38 |
870064 | 870064 | 2020-12-27 | Lafayette | Missouri | 29107 | 2002 | 38 |
866819 | 866819 | 2020-12-26 | Lafayette | Missouri | 29107 | 1997 | 38 |
863574 | 863574 | 2020-12-25 | Lafayette | Missouri | 29107 | 1988 | 38 |
860329 | 860329 | 2020-12-24 | Lafayette | Missouri | 29107 | 1970 | 38 |
857084 | 857084 | 2020-12-23 | Lafayette | Missouri | 29107 | 1951 | 38 |
853839 | 853839 | 2020-12-22 | Lafayette | Missouri | 29107 | 1940 | 36 |
850594 | 850594 | 2020-12-21 | Lafayette | Missouri | 29107 | 1904 | 36 |
847349 | 847349 | 2020-12-20 | Lafayette | Missouri | 29107 | 1879 | 36 |
844103 | 844103 | 2020-12-19 | Lafayette | Missouri | 29107 | 1866 | 36 |
840858 | 840858 | 2020-12-18 | Lafayette | Missouri | 29107 | 1839 | 36 |
837613 | 837613 | 2020-12-17 | Lafayette | Missouri | 29107 | 1821 | 35 |
834367 | 834367 | 2020-12-16 | Lafayette | Missouri | 29107 | 1805 | 35 |
831120 | 831120 | 2020-12-15 | Lafayette | Missouri | 29107 | 1797 | 35 |
827874 | 827874 | 2020-12-14 | Lafayette | Missouri | 29107 | 1782 | 35 |
824627 | 824627 | 2020-12-13 | Lafayette | Missouri | 29107 | 1770 | 35 |
821381 | 821381 | 2020-12-12 | Lafayette | Missouri | 29107 | 1752 | 35 |
818135 | 818135 | 2020-12-11 | Lafayette | Missouri | 29107 | 1723 | 31 |
814889 | 814889 | 2020-12-10 | Lafayette | Missouri | 29107 | 1723 | 31 |
811644 | 811644 | 2020-12-09 | Lafayette | Missouri | 29107 | 1704 | 31 |
808399 | 808399 | 2020-12-08 | Lafayette | Missouri | 29107 | 1690 | 31 |
805154 | 805154 | 2020-12-07 | Lafayette | Missouri | 29107 | 1667 | 30 |
801909 | 801909 | 2020-12-06 | Lafayette | Missouri | 29107 | 1657 | 30 |
798664 | 798664 | 2020-12-05 | Lafayette | Missouri | 29107 | 1634 | 30 |
795419 | 795419 | 2020-12-04 | Lafayette | Missouri | 29107 | 1617 | 30 |
792174 | 792174 | 2020-12-03 | Lafayette | Missouri | 29107 | 1601 | 30 |
788929 | 788929 | 2020-12-02 | Lafayette | Missouri | 29107 | 1581 | 30 |
785684 | 785684 | 2020-12-01 | Lafayette | Missouri | 29107 | 1566 | 29 |
782440 | 782440 | 2020-11-30 | Lafayette | Missouri | 29107 | 1554 | 29 |
779194 | 779194 | 2020-11-29 | Lafayette | Missouri | 29107 | 1528 | 29 |
775949 | 775949 | 2020-11-28 | Lafayette | Missouri | 29107 | 1499 | 29 |
772704 | 772704 | 2020-11-27 | Lafayette | Missouri | 29107 | 1491 | 29 |
769459 | 769459 | 2020-11-26 | Lafayette | Missouri | 29107 | 1477 | 29 |
766213 | 766213 | 2020-11-25 | Lafayette | Missouri | 29107 | 1448 | 29 |
762968 | 762968 | 2020-11-24 | Lafayette | Missouri | 29107 | 1410 | 29 |
759723 | 759723 | 2020-11-23 | Lafayette | Missouri | 29107 | 1389 | 29 |
756476 | 756476 | 2020-11-22 | Lafayette | Missouri | 29107 | 1369 | 29 |
753230 | 753230 | 2020-11-21 | Lafayette | Missouri | 29107 | 1355 | 29 |
749984 | 749984 | 2020-11-20 | Lafayette | Missouri | 29107 | 1331 | 29 |
746738 | 746738 | 2020-11-19 | Lafayette | Missouri | 29107 | 1309 | 29 |
743491 | 743491 | 2020-11-18 | Lafayette | Missouri | 29107 | 1278 | 28 |
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);