ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
800 rows where county = "Montgomery" and state = "Maryland" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1077442 | 1077442 | 2021-03-01 | Montgomery | Maryland | 24031 | 63440 | 1412 |
1074196 | 1074196 | 2021-02-28 | Montgomery | Maryland | 24031 | 63321 | 1412 |
1070950 | 1070950 | 2021-02-27 | Montgomery | Maryland | 24031 | 63211 | 1410 |
1067705 | 1067705 | 2021-02-26 | Montgomery | Maryland | 24031 | 63084 | 1408 |
1064460 | 1064460 | 2021-02-25 | Montgomery | Maryland | 24031 | 62941 | 1408 |
1061216 | 1061216 | 2021-02-24 | Montgomery | Maryland | 24031 | 62812 | 1399 |
1057970 | 1057970 | 2021-02-23 | Montgomery | Maryland | 24031 | 62671 | 1397 |
1054724 | 1054724 | 2021-02-22 | Montgomery | Maryland | 24031 | 62568 | 1398 |
1051477 | 1051477 | 2021-02-21 | Montgomery | Maryland | 24031 | 62481 | 1396 |
1048230 | 1048230 | 2021-02-20 | Montgomery | Maryland | 24031 | 62381 | 1395 |
1044984 | 1044984 | 2021-02-19 | Montgomery | Maryland | 24031 | 62279 | 1395 |
1041739 | 1041739 | 2021-02-18 | Montgomery | Maryland | 24031 | 62130 | 1393 |
1038494 | 1038494 | 2021-02-17 | Montgomery | Maryland | 24031 | 61987 | 1382 |
1035249 | 1035249 | 2021-02-16 | Montgomery | Maryland | 24031 | 61880 | 1382 |
1032004 | 1032004 | 2021-02-15 | Montgomery | Maryland | 24031 | 61788 | 1381 |
1028757 | 1028757 | 2021-02-14 | Montgomery | Maryland | 24031 | 61687 | 1372 |
1025511 | 1025511 | 2021-02-13 | Montgomery | Maryland | 24031 | 61562 | 1370 |
1022266 | 1022266 | 2021-02-12 | Montgomery | Maryland | 24031 | 61374 | 1368 |
1019021 | 1019021 | 2021-02-11 | Montgomery | Maryland | 24031 | 61204 | 1363 |
1015776 | 1015776 | 2021-02-10 | Montgomery | Maryland | 24031 | 61045 | 1360 |
1012531 | 1012531 | 2021-02-09 | Montgomery | Maryland | 24031 | 60879 | 1351 |
1009286 | 1009286 | 2021-02-08 | Montgomery | Maryland | 24031 | 60677 | 1347 |
1006039 | 1006039 | 2021-02-07 | Montgomery | Maryland | 24031 | 60523 | 1342 |
1002793 | 1002793 | 2021-02-06 | Montgomery | Maryland | 24031 | 60279 | 1338 |
999548 | 999548 | 2021-02-05 | Montgomery | Maryland | 24031 | 60084 | 1334 |
996302 | 996302 | 2021-02-04 | Montgomery | Maryland | 24031 | 59826 | 1324 |
993056 | 993056 | 2021-02-03 | Montgomery | Maryland | 24031 | 59483 | 1320 |
989810 | 989810 | 2021-02-02 | Montgomery | Maryland | 24031 | 59336 | 1313 |
986563 | 986563 | 2021-02-01 | Montgomery | Maryland | 24031 | 59199 | 1310 |
983316 | 983316 | 2021-01-31 | Montgomery | Maryland | 24031 | 59009 | 1304 |
980070 | 980070 | 2021-01-30 | Montgomery | Maryland | 24031 | 58754 | 1300 |
976824 | 976824 | 2021-01-29 | Montgomery | Maryland | 24031 | 58352 | 1298 |
973579 | 973579 | 2021-01-28 | Montgomery | Maryland | 24031 | 58055 | 1294 |
970334 | 970334 | 2021-01-27 | Montgomery | Maryland | 24031 | 57729 | 1292 |
967089 | 967089 | 2021-01-26 | Montgomery | Maryland | 24031 | 57370 | 1284 |
963845 | 963845 | 2021-01-25 | Montgomery | Maryland | 24031 | 57173 | 1279 |
960600 | 960600 | 2021-01-24 | Montgomery | Maryland | 24031 | 56773 | 1275 |
957354 | 957354 | 2021-01-23 | Montgomery | Maryland | 24031 | 56372 | 1269 |
954109 | 954109 | 2021-01-22 | Montgomery | Maryland | 24031 | 55995 | 1264 |
950864 | 950864 | 2021-01-21 | Montgomery | Maryland | 24031 | 55575 | 1256 |
947618 | 947618 | 2021-01-20 | Montgomery | Maryland | 24031 | 55247 | 1245 |
944371 | 944371 | 2021-01-19 | Montgomery | Maryland | 24031 | 54879 | 1240 |
941126 | 941126 | 2021-01-18 | Montgomery | Maryland | 24031 | 54569 | 1234 |
937881 | 937881 | 2021-01-17 | Montgomery | Maryland | 24031 | 54285 | 1226 |
934636 | 934636 | 2021-01-16 | Montgomery | Maryland | 24031 | 53876 | 1221 |
931391 | 931391 | 2021-01-15 | Montgomery | Maryland | 24031 | 53327 | 1217 |
928146 | 928146 | 2021-01-14 | Montgomery | Maryland | 24031 | 52886 | 1211 |
924900 | 924900 | 2021-01-13 | Montgomery | Maryland | 24031 | 52411 | 1203 |
921655 | 921655 | 2021-01-12 | Montgomery | Maryland | 24031 | 52058 | 1189 |
918410 | 918410 | 2021-01-11 | Montgomery | Maryland | 24031 | 51570 | 1183 |
915165 | 915165 | 2021-01-10 | Montgomery | Maryland | 24031 | 51110 | 1180 |
911920 | 911920 | 2021-01-09 | Montgomery | Maryland | 24031 | 50471 | 1174 |
908675 | 908675 | 2021-01-08 | Montgomery | Maryland | 24031 | 49849 | 1169 |
905429 | 905429 | 2021-01-07 | Montgomery | Maryland | 24031 | 49300 | 1162 |
902184 | 902184 | 2021-01-06 | Montgomery | Maryland | 24031 | 48907 | 1157 |
898939 | 898939 | 2021-01-05 | Montgomery | Maryland | 24031 | 48394 | 1147 |
895694 | 895694 | 2021-01-04 | Montgomery | Maryland | 24031 | 48132 | 1140 |
892447 | 892447 | 2021-01-03 | Montgomery | Maryland | 24031 | 47618 | 1138 |
889201 | 889201 | 2021-01-02 | Montgomery | Maryland | 24031 | 47190 | 1132 |
885955 | 885955 | 2021-01-01 | Montgomery | Maryland | 24031 | 46760 | 1129 |
882710 | 882710 | 2020-12-31 | Montgomery | Maryland | 24031 | 46243 | 1124 |
879465 | 879465 | 2020-12-30 | Montgomery | Maryland | 24031 | 45834 | 1120 |
876220 | 876220 | 2020-12-29 | Montgomery | Maryland | 24031 | 45384 | 1111 |
872975 | 872975 | 2020-12-28 | Montgomery | Maryland | 24031 | 45093 | 1104 |
869730 | 869730 | 2020-12-27 | Montgomery | Maryland | 24031 | 44683 | 1098 |
866485 | 866485 | 2020-12-26 | Montgomery | Maryland | 24031 | 44330 | 1093 |
863240 | 863240 | 2020-12-25 | Montgomery | Maryland | 24031 | 43961 | 1092 |
859995 | 859995 | 2020-12-24 | Montgomery | Maryland | 24031 | 43497 | 1080 |
856750 | 856750 | 2020-12-23 | Montgomery | Maryland | 24031 | 43019 | 1076 |
853505 | 853505 | 2020-12-22 | Montgomery | Maryland | 24031 | 42595 | 1069 |
850260 | 850260 | 2020-12-21 | Montgomery | Maryland | 24031 | 42216 | 1064 |
847015 | 847015 | 2020-12-20 | Montgomery | Maryland | 24031 | 41825 | 1060 |
843769 | 843769 | 2020-12-19 | Montgomery | Maryland | 24031 | 41531 | 1059 |
840524 | 840524 | 2020-12-18 | Montgomery | Maryland | 24031 | 41217 | 1057 |
837279 | 837279 | 2020-12-17 | Montgomery | Maryland | 24031 | 40791 | 1053 |
834033 | 834033 | 2020-12-16 | Montgomery | Maryland | 24031 | 40544 | 1039 |
830786 | 830786 | 2020-12-15 | Montgomery | Maryland | 24031 | 40106 | 1034 |
827540 | 827540 | 2020-12-14 | Montgomery | Maryland | 24031 | 39765 | 1024 |
824293 | 824293 | 2020-12-13 | Montgomery | Maryland | 24031 | 39360 | 1022 |
821047 | 821047 | 2020-12-12 | Montgomery | Maryland | 24031 | 38856 | 1017 |
817801 | 817801 | 2020-12-11 | Montgomery | Maryland | 24031 | 38234 | 1012 |
814555 | 814555 | 2020-12-10 | Montgomery | Maryland | 24031 | 37782 | 1002 |
811310 | 811310 | 2020-12-09 | Montgomery | Maryland | 24031 | 37238 | 1000 |
808065 | 808065 | 2020-12-08 | Montgomery | Maryland | 24031 | 36895 | 993 |
804820 | 804820 | 2020-12-07 | Montgomery | Maryland | 24031 | 36493 | 990 |
801575 | 801575 | 2020-12-06 | Montgomery | Maryland | 24031 | 36043 | 983 |
798330 | 798330 | 2020-12-05 | Montgomery | Maryland | 24031 | 35583 | 980 |
795085 | 795085 | 2020-12-04 | Montgomery | Maryland | 24031 | 35100 | 977 |
791840 | 791840 | 2020-12-03 | Montgomery | Maryland | 24031 | 34467 | 970 |
788595 | 788595 | 2020-12-02 | Montgomery | Maryland | 24031 | 34201 | 966 |
785350 | 785350 | 2020-12-01 | Montgomery | Maryland | 24031 | 33947 | 960 |
782106 | 782106 | 2020-11-30 | Montgomery | Maryland | 24031 | 33442 | 954 |
778860 | 778860 | 2020-11-29 | Montgomery | Maryland | 24031 | 33145 | 951 |
775615 | 775615 | 2020-11-28 | Montgomery | Maryland | 24031 | 32832 | 947 |
772370 | 772370 | 2020-11-27 | Montgomery | Maryland | 24031 | 32643 | 944 |
769125 | 769125 | 2020-11-26 | Montgomery | Maryland | 24031 | 32301 | 939 |
765879 | 765879 | 2020-11-25 | Montgomery | Maryland | 24031 | 32047 | 936 |
762634 | 762634 | 2020-11-24 | Montgomery | Maryland | 24031 | 31664 | 935 |
759389 | 759389 | 2020-11-23 | Montgomery | Maryland | 24031 | 31431 | 932 |
756142 | 756142 | 2020-11-22 | Montgomery | Maryland | 24031 | 31218 | 931 |
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);