ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
798 rows where county = "Montgomery" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1195417 | 1195417 | 2021-04-06 | Montgomery | Pennsylvania | 42091 | 61499 | 1617 |
1192169 | 1192169 | 2021-04-05 | Montgomery | Pennsylvania | 42091 | 61280 | 1612 |
1188920 | 1188920 | 2021-04-04 | Montgomery | Pennsylvania | 42091 | 61007 | 1612 |
1185673 | 1185673 | 2021-04-03 | Montgomery | Pennsylvania | 42091 | 60687 | 1612 |
1182426 | 1182426 | 2021-04-02 | Montgomery | Pennsylvania | 42091 | 60315 | 1612 |
1179179 | 1179179 | 2021-04-01 | Montgomery | Pennsylvania | 42091 | 60008 | 1612 |
1175932 | 1175932 | 2021-03-31 | Montgomery | Pennsylvania | 42091 | 59801 | 1610 |
1172685 | 1172685 | 2021-03-30 | Montgomery | Pennsylvania | 42091 | 59562 | 1608 |
1169438 | 1169438 | 2021-03-29 | Montgomery | Pennsylvania | 42091 | 59243 | 1606 |
1166190 | 1166190 | 2021-03-28 | Montgomery | Pennsylvania | 42091 | 59046 | 1604 |
1162942 | 1162942 | 2021-03-27 | Montgomery | Pennsylvania | 42091 | 58804 | 1603 |
1159693 | 1159693 | 2021-03-26 | Montgomery | Pennsylvania | 42091 | 58534 | 1600 |
1156446 | 1156446 | 2021-03-25 | Montgomery | Pennsylvania | 42091 | 58282 | 1598 |
1153199 | 1153199 | 2021-03-24 | Montgomery | Pennsylvania | 42091 | 58076 | 1598 |
1149952 | 1149952 | 2021-03-23 | Montgomery | Pennsylvania | 42091 | 57799 | 1596 |
1146705 | 1146705 | 2021-03-22 | Montgomery | Pennsylvania | 42091 | 57655 | 1593 |
1143458 | 1143458 | 2021-03-21 | Montgomery | Pennsylvania | 42091 | 57547 | 1593 |
1140211 | 1140211 | 2021-03-20 | Montgomery | Pennsylvania | 42091 | 57387 | 1591 |
1136965 | 1136965 | 2021-03-19 | Montgomery | Pennsylvania | 42091 | 57055 | 1590 |
1133719 | 1133719 | 2021-03-18 | Montgomery | Pennsylvania | 42091 | 56841 | 1588 |
1130471 | 1130471 | 2021-03-17 | Montgomery | Pennsylvania | 42091 | 56687 | 1585 |
1127224 | 1127224 | 2021-03-16 | Montgomery | Pennsylvania | 42091 | 56511 | 1584 |
1123978 | 1123978 | 2021-03-15 | Montgomery | Pennsylvania | 42091 | 56338 | 1581 |
1120732 | 1120732 | 2021-03-14 | Montgomery | Pennsylvania | 42091 | 56232 | 1576 |
1117485 | 1117485 | 2021-03-13 | Montgomery | Pennsylvania | 42091 | 56065 | 1576 |
1114238 | 1114238 | 2021-03-12 | Montgomery | Pennsylvania | 42091 | 55927 | 1576 |
1110992 | 1110992 | 2021-03-11 | Montgomery | Pennsylvania | 42091 | 55716 | 1572 |
1107746 | 1107746 | 2021-03-10 | Montgomery | Pennsylvania | 42091 | 55594 | 1571 |
1104500 | 1104500 | 2021-03-09 | Montgomery | Pennsylvania | 42091 | 55442 | 1570 |
1101254 | 1101254 | 2021-03-08 | Montgomery | Pennsylvania | 42091 | 55332 | 1569 |
1098008 | 1098008 | 2021-03-07 | Montgomery | Pennsylvania | 42091 | 55218 | 1569 |
1094760 | 1094760 | 2021-03-06 | Montgomery | Pennsylvania | 42091 | 54952 | 1567 |
1091514 | 1091514 | 2021-03-05 | Montgomery | Pennsylvania | 42091 | 54736 | 1565 |
1088268 | 1088268 | 2021-03-04 | Montgomery | Pennsylvania | 42091 | 54580 | 1562 |
1085023 | 1085023 | 2021-03-03 | Montgomery | Pennsylvania | 42091 | 54364 | 1559 |
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 |
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);