ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Montgomery" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
945119 | 945119 | 2021-01-19 | Montgomery | North Carolina | 37123 | 2472 | 52 |
941873 | 941873 | 2021-01-18 | Montgomery | North Carolina | 37123 | 2446 | 52 |
938628 | 938628 | 2021-01-17 | Montgomery | North Carolina | 37123 | 2446 | 52 |
935383 | 935383 | 2021-01-16 | Montgomery | North Carolina | 37123 | 2427 | 52 |
932138 | 932138 | 2021-01-15 | Montgomery | North Carolina | 37123 | 2398 | 52 |
928893 | 928893 | 2021-01-14 | Montgomery | North Carolina | 37123 | 2357 | 52 |
925648 | 925648 | 2021-01-13 | Montgomery | North Carolina | 37123 | 2309 | 52 |
922402 | 922402 | 2021-01-12 | Montgomery | North Carolina | 37123 | 2302 | 50 |
919157 | 919157 | 2021-01-11 | Montgomery | North Carolina | 37123 | 2287 | 48 |
915912 | 915912 | 2021-01-10 | Montgomery | North Carolina | 37123 | 2260 | 48 |
912667 | 912667 | 2021-01-09 | Montgomery | North Carolina | 37123 | 2230 | 48 |
909422 | 909422 | 2021-01-08 | Montgomery | North Carolina | 37123 | 2183 | 48 |
906177 | 906177 | 2021-01-07 | Montgomery | North Carolina | 37123 | 2124 | 48 |
902931 | 902931 | 2021-01-06 | Montgomery | North Carolina | 37123 | 2068 | 47 |
899686 | 899686 | 2021-01-05 | Montgomery | North Carolina | 37123 | 2045 | 47 |
896441 | 896441 | 2021-01-04 | Montgomery | North Carolina | 37123 | 2023 | 47 |
893195 | 893195 | 2021-01-03 | Montgomery | North Carolina | 37123 | 1978 | 47 |
889949 | 889949 | 2021-01-02 | Montgomery | North Carolina | 37123 | 1974 | 47 |
886702 | 886702 | 2021-01-01 | Montgomery | North Carolina | 37123 | 1920 | 46 |
883457 | 883457 | 2020-12-31 | Montgomery | North Carolina | 37123 | 1920 | 46 |
880212 | 880212 | 2020-12-30 | Montgomery | North Carolina | 37123 | 1899 | 46 |
876967 | 876967 | 2020-12-29 | Montgomery | North Carolina | 37123 | 1878 | 46 |
873722 | 873722 | 2020-12-28 | Montgomery | North Carolina | 37123 | 1868 | 46 |
870477 | 870477 | 2020-12-27 | Montgomery | North Carolina | 37123 | 1860 | 46 |
867232 | 867232 | 2020-12-26 | Montgomery | North Carolina | 37123 | 1854 | 46 |
863987 | 863987 | 2020-12-25 | Montgomery | North Carolina | 37123 | 1796 | 46 |
860742 | 860742 | 2020-12-24 | Montgomery | North Carolina | 37123 | 1796 | 46 |
857497 | 857497 | 2020-12-23 | Montgomery | North Carolina | 37123 | 1796 | 46 |
854252 | 854252 | 2020-12-22 | Montgomery | North Carolina | 37123 | 1777 | 46 |
851007 | 851007 | 2020-12-21 | Montgomery | North Carolina | 37123 | 1766 | 46 |
847762 | 847762 | 2020-12-20 | Montgomery | North Carolina | 37123 | 1744 | 46 |
844517 | 844517 | 2020-12-19 | Montgomery | North Carolina | 37123 | 1728 | 44 |
841271 | 841271 | 2020-12-18 | Montgomery | North Carolina | 37123 | 1708 | 44 |
838026 | 838026 | 2020-12-17 | Montgomery | North Carolina | 37123 | 1685 | 44 |
834780 | 834780 | 2020-12-16 | Montgomery | North Carolina | 37123 | 1666 | 44 |
831534 | 831534 | 2020-12-15 | Montgomery | North Carolina | 37123 | 1631 | 44 |
828287 | 828287 | 2020-12-14 | Montgomery | North Carolina | 37123 | 1613 | 44 |
825041 | 825041 | 2020-12-13 | Montgomery | North Carolina | 37123 | 1600 | 44 |
821794 | 821794 | 2020-12-12 | Montgomery | North Carolina | 37123 | 1581 | 44 |
818548 | 818548 | 2020-12-11 | Montgomery | North Carolina | 37123 | 1570 | 43 |
815302 | 815302 | 2020-12-10 | Montgomery | North Carolina | 37123 | 1544 | 43 |
812057 | 812057 | 2020-12-09 | Montgomery | North Carolina | 37123 | 1529 | 43 |
808812 | 808812 | 2020-12-08 | Montgomery | North Carolina | 37123 | 1521 | 43 |
805567 | 805567 | 2020-12-07 | Montgomery | North Carolina | 37123 | 1501 | 43 |
802322 | 802322 | 2020-12-06 | Montgomery | North Carolina | 37123 | 1489 | 43 |
799077 | 799077 | 2020-12-05 | Montgomery | North Carolina | 37123 | 1463 | 43 |
795832 | 795832 | 2020-12-04 | Montgomery | North Carolina | 37123 | 1446 | 42 |
792587 | 792587 | 2020-12-03 | Montgomery | North Carolina | 37123 | 1440 | 42 |
789342 | 789342 | 2020-12-02 | Montgomery | North Carolina | 37123 | 1425 | 41 |
786097 | 786097 | 2020-12-01 | Montgomery | North Carolina | 37123 | 1413 | 41 |
782853 | 782853 | 2020-11-30 | Montgomery | North Carolina | 37123 | 1404 | 41 |
779607 | 779607 | 2020-11-29 | Montgomery | North Carolina | 37123 | 1399 | 41 |
776362 | 776362 | 2020-11-28 | Montgomery | North Carolina | 37123 | 1388 | 41 |
773117 | 773117 | 2020-11-27 | Montgomery | North Carolina | 37123 | 1381 | 41 |
769872 | 769872 | 2020-11-26 | Montgomery | North Carolina | 37123 | 1367 | 41 |
766626 | 766626 | 2020-11-25 | Montgomery | North Carolina | 37123 | 1367 | 41 |
763381 | 763381 | 2020-11-24 | Montgomery | North Carolina | 37123 | 1355 | 41 |
760136 | 760136 | 2020-11-23 | Montgomery | North Carolina | 37123 | 1350 | 41 |
756890 | 756890 | 2020-11-22 | Montgomery | North Carolina | 37123 | 1345 | 41 |
753643 | 753643 | 2020-11-21 | Montgomery | North Carolina | 37123 | 1330 | 41 |
750397 | 750397 | 2020-11-20 | Montgomery | North Carolina | 37123 | 1324 | 41 |
747151 | 747151 | 2020-11-19 | Montgomery | North Carolina | 37123 | 1315 | 41 |
743905 | 743905 | 2020-11-18 | Montgomery | North Carolina | 37123 | 1304 | 41 |
740658 | 740658 | 2020-11-17 | Montgomery | North Carolina | 37123 | 1295 | 41 |
737413 | 737413 | 2020-11-16 | Montgomery | North Carolina | 37123 | 1285 | 40 |
734169 | 734169 | 2020-11-15 | Montgomery | North Carolina | 37123 | 1282 | 40 |
730923 | 730923 | 2020-11-14 | Montgomery | North Carolina | 37123 | 1280 | 39 |
727679 | 727679 | 2020-11-13 | Montgomery | North Carolina | 37123 | 1268 | 39 |
724435 | 724435 | 2020-11-12 | Montgomery | North Carolina | 37123 | 1262 | 39 |
721192 | 721192 | 2020-11-11 | Montgomery | North Carolina | 37123 | 1255 | 39 |
717949 | 717949 | 2020-11-10 | Montgomery | North Carolina | 37123 | 1251 | 39 |
714706 | 714706 | 2020-11-09 | Montgomery | North Carolina | 37123 | 1247 | 39 |
711462 | 711462 | 2020-11-08 | Montgomery | North Carolina | 37123 | 1247 | 39 |
708218 | 708218 | 2020-11-07 | Montgomery | North Carolina | 37123 | 1244 | 39 |
704975 | 704975 | 2020-11-06 | Montgomery | North Carolina | 37123 | 1243 | 39 |
701732 | 701732 | 2020-11-05 | Montgomery | North Carolina | 37123 | 1235 | 39 |
698488 | 698488 | 2020-11-04 | Montgomery | North Carolina | 37123 | 1228 | 38 |
695245 | 695245 | 2020-11-03 | Montgomery | North Carolina | 37123 | 1223 | 38 |
692003 | 692003 | 2020-11-02 | Montgomery | North Carolina | 37123 | 1218 | 38 |
688759 | 688759 | 2020-11-01 | Montgomery | North Carolina | 37123 | 1213 | 38 |
685514 | 685514 | 2020-10-31 | Montgomery | North Carolina | 37123 | 1208 | 38 |
682271 | 682271 | 2020-10-30 | Montgomery | North Carolina | 37123 | 1202 | 38 |
679028 | 679028 | 2020-10-29 | Montgomery | North Carolina | 37123 | 1195 | 38 |
675785 | 675785 | 2020-10-28 | Montgomery | North Carolina | 37123 | 1190 | 38 |
672542 | 672542 | 2020-10-27 | Montgomery | North Carolina | 37123 | 1184 | 38 |
669300 | 669300 | 2020-10-26 | Montgomery | North Carolina | 37123 | 1178 | 38 |
666056 | 666056 | 2020-10-25 | Montgomery | North Carolina | 37123 | 1174 | 38 |
662811 | 662811 | 2020-10-24 | Montgomery | North Carolina | 37123 | 1169 | 38 |
659567 | 659567 | 2020-10-23 | Montgomery | North Carolina | 37123 | 1164 | 38 |
656323 | 656323 | 2020-10-22 | Montgomery | North Carolina | 37123 | 1157 | 38 |
653078 | 653078 | 2020-10-21 | Montgomery | North Carolina | 37123 | 1154 | 38 |
649833 | 649833 | 2020-10-20 | Montgomery | North Carolina | 37123 | 1154 | 38 |
646589 | 646589 | 2020-10-19 | Montgomery | North Carolina | 37123 | 1146 | 38 |
643343 | 643343 | 2020-10-18 | Montgomery | North Carolina | 37123 | 1142 | 38 |
640095 | 640095 | 2020-10-17 | Montgomery | North Carolina | 37123 | 1134 | 38 |
636849 | 636849 | 2020-10-16 | Montgomery | North Carolina | 37123 | 1119 | 38 |
633603 | 633603 | 2020-10-15 | Montgomery | North Carolina | 37123 | 1108 | 38 |
630358 | 630358 | 2020-10-14 | Montgomery | North Carolina | 37123 | 1101 | 38 |
627114 | 627114 | 2020-10-13 | Montgomery | North Carolina | 37123 | 1095 | 36 |
623872 | 623872 | 2020-10-12 | Montgomery | North Carolina | 37123 | 1093 | 36 |
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);