ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Montgomery" and fips = 42091 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1081777 | 1081777 | 2021-03-02 | Montgomery | Pennsylvania | 42091 | 54217 | 1554 |
1078531 | 1078531 | 2021-03-01 | Montgomery | Pennsylvania | 42091 | 54030 | 1548 |
1075286 | 1075286 | 2021-02-28 | Montgomery | Pennsylvania | 42091 | 53921 | 1548 |
1072040 | 1072040 | 2021-02-27 | Montgomery | Pennsylvania | 42091 | 53760 | 1541 |
1068794 | 1068794 | 2021-02-26 | Montgomery | Pennsylvania | 42091 | 53604 | 1541 |
1065549 | 1065549 | 2021-02-25 | Montgomery | Pennsylvania | 42091 | 53371 | 1532 |
1062304 | 1062304 | 2021-02-24 | Montgomery | Pennsylvania | 42091 | 53231 | 1529 |
1059059 | 1059059 | 2021-02-23 | Montgomery | Pennsylvania | 42091 | 53049 | 1524 |
1055813 | 1055813 | 2021-02-22 | Montgomery | Pennsylvania | 42091 | 52898 | 1518 |
1052567 | 1052567 | 2021-02-21 | Montgomery | Pennsylvania | 42091 | 52748 | 1514 |
1049320 | 1049320 | 2021-02-20 | Montgomery | Pennsylvania | 42091 | 52637 | 1511 |
1046073 | 1046073 | 2021-02-19 | Montgomery | Pennsylvania | 42091 | 52427 | 1509 |
1042828 | 1042828 | 2021-02-18 | Montgomery | Pennsylvania | 42091 | 52252 | 1506 |
1039583 | 1039583 | 2021-02-17 | Montgomery | Pennsylvania | 42091 | 52041 | 1498 |
1036338 | 1036338 | 2021-02-16 | Montgomery | Pennsylvania | 42091 | 51803 | 1480 |
1033093 | 1033093 | 2021-02-15 | Montgomery | Pennsylvania | 42091 | 51656 | 1480 |
1029847 | 1029847 | 2021-02-14 | Montgomery | Pennsylvania | 42091 | 51555 | 1477 |
1026600 | 1026600 | 2021-02-13 | Montgomery | Pennsylvania | 42091 | 51429 | 1476 |
1023355 | 1023355 | 2021-02-12 | Montgomery | Pennsylvania | 42091 | 51197 | 1462 |
1020110 | 1020110 | 2021-02-11 | Montgomery | Pennsylvania | 42091 | 51044 | 1456 |
1016865 | 1016865 | 2021-02-10 | Montgomery | Pennsylvania | 42091 | 50815 | 1449 |
1013620 | 1013620 | 2021-02-09 | Montgomery | Pennsylvania | 42091 | 50615 | 1440 |
1010375 | 1010375 | 2021-02-08 | Montgomery | Pennsylvania | 42091 | 50413 | 1425 |
1007129 | 1007129 | 2021-02-07 | Montgomery | Pennsylvania | 42091 | 50217 | 1425 |
1003883 | 1003883 | 2021-02-06 | Montgomery | Pennsylvania | 42091 | 49877 | 1423 |
1000637 | 1000637 | 2021-02-05 | Montgomery | Pennsylvania | 42091 | 49635 | 1413 |
997391 | 997391 | 2021-02-04 | Montgomery | Pennsylvania | 42091 | 49475 | 1404 |
994145 | 994145 | 2021-02-03 | Montgomery | Pennsylvania | 42091 | 49270 | 1399 |
990899 | 990899 | 2021-02-02 | Montgomery | Pennsylvania | 42091 | 49117 | 1394 |
987653 | 987653 | 2021-02-01 | Montgomery | Pennsylvania | 42091 | 48832 | 1389 |
984406 | 984406 | 2021-01-31 | Montgomery | Pennsylvania | 42091 | 48612 | 1389 |
981159 | 981159 | 2021-01-30 | Montgomery | Pennsylvania | 42091 | 48329 | 1384 |
977913 | 977913 | 2021-01-29 | Montgomery | Pennsylvania | 42091 | 48029 | 1376 |
974668 | 974668 | 2021-01-28 | Montgomery | Pennsylvania | 42091 | 47100 | 1371 |
971423 | 971423 | 2021-01-27 | Montgomery | Pennsylvania | 42091 | 46765 | 1363 |
968178 | 968178 | 2021-01-26 | Montgomery | Pennsylvania | 42091 | 46413 | 1357 |
964934 | 964934 | 2021-01-25 | Montgomery | Pennsylvania | 42091 | 46137 | 1347 |
961689 | 961689 | 2021-01-24 | Montgomery | Pennsylvania | 42091 | 45837 | 1347 |
958444 | 958444 | 2021-01-23 | Montgomery | Pennsylvania | 42091 | 45577 | 1343 |
955198 | 955198 | 2021-01-22 | Montgomery | Pennsylvania | 42091 | 45263 | 1334 |
951953 | 951953 | 2021-01-21 | Montgomery | Pennsylvania | 42091 | 44865 | 1330 |
948708 | 948708 | 2021-01-20 | Montgomery | Pennsylvania | 42091 | 44561 | 1322 |
945462 | 945462 | 2021-01-19 | Montgomery | Pennsylvania | 42091 | 44279 | 1299 |
942215 | 942215 | 2021-01-18 | Montgomery | Pennsylvania | 42091 | 43958 | 1298 |
938970 | 938970 | 2021-01-17 | Montgomery | Pennsylvania | 42091 | 43690 | 1296 |
935725 | 935725 | 2021-01-16 | Montgomery | Pennsylvania | 42091 | 43270 | 1292 |
932480 | 932480 | 2021-01-15 | Montgomery | Pennsylvania | 42091 | 42797 | 1279 |
929235 | 929235 | 2021-01-14 | Montgomery | Pennsylvania | 42091 | 42433 | 1266 |
925990 | 925990 | 2021-01-13 | Montgomery | Pennsylvania | 42091 | 41961 | 1250 |
922744 | 922744 | 2021-01-12 | Montgomery | Pennsylvania | 42091 | 41651 | 1239 |
919499 | 919499 | 2021-01-11 | Montgomery | Pennsylvania | 42091 | 41270 | 1228 |
916254 | 916254 | 2021-01-10 | Montgomery | Pennsylvania | 42091 | 40964 | 1226 |
913009 | 913009 | 2021-01-09 | Montgomery | Pennsylvania | 42091 | 40432 | 1221 |
909764 | 909764 | 2021-01-08 | Montgomery | Pennsylvania | 42091 | 39939 | 1211 |
906519 | 906519 | 2021-01-07 | Montgomery | Pennsylvania | 42091 | 39388 | 1207 |
903273 | 903273 | 2021-01-06 | Montgomery | Pennsylvania | 42091 | 38549 | 1190 |
900028 | 900028 | 2021-01-05 | Montgomery | Pennsylvania | 42091 | 38101 | 1179 |
896783 | 896783 | 2021-01-04 | Montgomery | Pennsylvania | 42091 | 37560 | 1163 |
893537 | 893537 | 2021-01-03 | Montgomery | Pennsylvania | 42091 | 37427 | 1161 |
890291 | 890291 | 2021-01-02 | Montgomery | Pennsylvania | 42091 | 37109 | 1157 |
887044 | 887044 | 2021-01-01 | Montgomery | Pennsylvania | 42091 | 36598 | 1155 |
883799 | 883799 | 2020-12-31 | Montgomery | Pennsylvania | 42091 | 36131 | 1147 |
880554 | 880554 | 2020-12-30 | Montgomery | Pennsylvania | 42091 | 35592 | 1134 |
877309 | 877309 | 2020-12-29 | Montgomery | Pennsylvania | 42091 | 35086 | 1124 |
874064 | 874064 | 2020-12-28 | Montgomery | Pennsylvania | 42091 | 34736 | 1108 |
870819 | 870819 | 2020-12-27 | Montgomery | Pennsylvania | 42091 | 34422 | 1108 |
867574 | 867574 | 2020-12-26 | Montgomery | Pennsylvania | 42091 | 34146 | 1102 |
864329 | 864329 | 2020-12-25 | Montgomery | Pennsylvania | 42091 | 33702 | 1101 |
861084 | 861084 | 2020-12-24 | Montgomery | Pennsylvania | 42091 | 33226 | 1095 |
857839 | 857839 | 2020-12-23 | Montgomery | Pennsylvania | 42091 | 32738 | 1082 |
854594 | 854594 | 2020-12-22 | Montgomery | Pennsylvania | 42091 | 32268 | 1073 |
851349 | 851349 | 2020-12-21 | Montgomery | Pennsylvania | 42091 | 31711 | 1063 |
848104 | 848104 | 2020-12-20 | Montgomery | Pennsylvania | 42091 | 31421 | 1062 |
844859 | 844859 | 2020-12-19 | Montgomery | Pennsylvania | 42091 | 31092 | 1057 |
841613 | 841613 | 2020-12-18 | Montgomery | Pennsylvania | 42091 | 30755 | 1049 |
838368 | 838368 | 2020-12-17 | Montgomery | Pennsylvania | 42091 | 30172 | 1036 |
835122 | 835122 | 2020-12-16 | Montgomery | Pennsylvania | 42091 | 29656 | 1025 |
831876 | 831876 | 2020-12-15 | Montgomery | Pennsylvania | 42091 | 29234 | 1018 |
828629 | 828629 | 2020-12-14 | Montgomery | Pennsylvania | 42091 | 28851 | 1009 |
825383 | 825383 | 2020-12-13 | Montgomery | Pennsylvania | 42091 | 28468 | 1008 |
822136 | 822136 | 2020-12-12 | Montgomery | Pennsylvania | 42091 | 28019 | 1005 |
818890 | 818890 | 2020-12-11 | Montgomery | Pennsylvania | 42091 | 27434 | 1000 |
815644 | 815644 | 2020-12-10 | Montgomery | Pennsylvania | 42091 | 26818 | 991 |
812398 | 812398 | 2020-12-09 | Montgomery | Pennsylvania | 42091 | 26123 | 981 |
809154 | 809154 | 2020-12-08 | Montgomery | Pennsylvania | 42091 | 25825 | 971 |
805909 | 805909 | 2020-12-07 | Montgomery | Pennsylvania | 42091 | 25277 | 962 |
802664 | 802664 | 2020-12-06 | Montgomery | Pennsylvania | 42091 | 25008 | 961 |
799419 | 799419 | 2020-12-05 | Montgomery | Pennsylvania | 42091 | 24495 | 961 |
796174 | 796174 | 2020-12-04 | Montgomery | Pennsylvania | 42091 | 23916 | 955 |
792929 | 792929 | 2020-12-03 | Montgomery | Pennsylvania | 42091 | 23307 | 954 |
789684 | 789684 | 2020-12-02 | Montgomery | Pennsylvania | 42091 | 22618 | 947 |
786439 | 786439 | 2020-12-01 | Montgomery | Pennsylvania | 42091 | 22228 | 941 |
783195 | 783195 | 2020-11-30 | Montgomery | Pennsylvania | 42091 | 22025 | 936 |
779950 | 779950 | 2020-11-29 | Montgomery | Pennsylvania | 42091 | 21729 | 935 |
776704 | 776704 | 2020-11-28 | Montgomery | Pennsylvania | 42091 | 21421 | 934 |
773459 | 773459 | 2020-11-27 | Montgomery | Pennsylvania | 42091 | 21071 | 932 |
770214 | 770214 | 2020-11-26 | Montgomery | Pennsylvania | 42091 | 20766 | 931 |
766968 | 766968 | 2020-11-25 | Montgomery | Pennsylvania | 42091 | 20377 | 928 |
763723 | 763723 | 2020-11-24 | Montgomery | Pennsylvania | 42091 | 20110 | 924 |
760478 | 760478 | 2020-11-23 | Montgomery | Pennsylvania | 42091 | 19851 | 923 |
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);