ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
13,177 rows where county = "Monroe" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053663 | 1053663 | 2021-02-22 | Monroe | Arkansas | 5095 | 822 | 17 |
1053871 | 1053871 | 2021-02-22 | Monroe | Florida | 12087 | 5698 | 44 |
1053997 | 1053997 | 2021-02-22 | Monroe | Georgia | 13207 | 2337 | 87 |
1054172 | 1054172 | 2021-02-22 | Monroe | Illinois | 17133 | 4028 | 80 |
1054261 | 1054261 | 2021-02-22 | Monroe | Indiana | 18105 | 10245 | 162 |
1054368 | 1054368 | 2021-02-22 | Monroe | Iowa | 19135 | 873 | 27 |
1054592 | 1054592 | 2021-02-22 | Monroe | Kentucky | 21171 | 1245 | 38 |
1054806 | 1054806 | 2021-02-22 | Monroe | Michigan | 26115 | 9639 | 198 |
1054968 | 1054968 | 2021-02-22 | Monroe | Mississippi | 28095 | 3967 | 125 |
1055073 | 1055073 | 2021-02-22 | Monroe | Missouri | 29137 | 591 | 10 |
1055377 | 1055377 | 2021-02-22 | Monroe | New York | 36055 | 51675 | 976 |
1055621 | 1055621 | 2021-02-22 | Monroe | Ohio | 39111 | 1142 | 37 |
1055812 | 1055812 | 2021-02-22 | Monroe | Pennsylvania | 42089 | 9435 | 262 |
1056093 | 1056093 | 2021-02-22 | Monroe | Tennessee | 47123 | 5228 | 88 |
1056633 | 1056633 | 2021-02-22 | Monroe | West Virginia | 54063 | 932 | 12 |
1056698 | 1056698 | 2021-02-22 | Monroe | Wisconsin | 55081 | 4362 | 32 |
1050308 | 1050308 | 2021-02-21 | Monroe | Alabama | 1099 | 1652 | 38 |
1050416 | 1050416 | 2021-02-21 | Monroe | Arkansas | 5095 | 822 | 17 |
1050624 | 1050624 | 2021-02-21 | Monroe | Florida | 12087 | 5688 | 44 |
1050750 | 1050750 | 2021-02-21 | Monroe | Georgia | 13207 | 2335 | 87 |
1050925 | 1050925 | 2021-02-21 | Monroe | Illinois | 17133 | 4025 | 80 |
1051014 | 1051014 | 2021-02-21 | Monroe | Indiana | 18105 | 10199 | 161 |
1051121 | 1051121 | 2021-02-21 | Monroe | Iowa | 19135 | 873 | 27 |
1051345 | 1051345 | 2021-02-21 | Monroe | Kentucky | 21171 | 1245 | 38 |
1051559 | 1051559 | 2021-02-21 | Monroe | Michigan | 26115 | 9614 | 198 |
1051721 | 1051721 | 2021-02-21 | Monroe | Mississippi | 28095 | 3966 | 125 |
1051826 | 1051826 | 2021-02-21 | Monroe | Missouri | 29137 | 591 | 10 |
1052131 | 1052131 | 2021-02-21 | Monroe | New York | 36055 | 51565 | 972 |
1052375 | 1052375 | 2021-02-21 | Monroe | Ohio | 39111 | 1139 | 37 |
1052566 | 1052566 | 2021-02-21 | Monroe | Pennsylvania | 42089 | 9417 | 261 |
1052847 | 1052847 | 2021-02-21 | Monroe | Tennessee | 47123 | 5215 | 88 |
1053387 | 1053387 | 2021-02-21 | Monroe | West Virginia | 54063 | 931 | 12 |
1053452 | 1053452 | 2021-02-21 | Monroe | Wisconsin | 55081 | 4358 | 32 |
1047061 | 1047061 | 2021-02-20 | Monroe | Alabama | 1099 | 1652 | 38 |
1047169 | 1047169 | 2021-02-20 | Monroe | Arkansas | 5095 | 822 | 17 |
1047377 | 1047377 | 2021-02-20 | Monroe | Florida | 12087 | 5675 | 44 |
1047503 | 1047503 | 2021-02-20 | Monroe | Georgia | 13207 | 2334 | 87 |
1047678 | 1047678 | 2021-02-20 | Monroe | Illinois | 17133 | 4022 | 80 |
1047767 | 1047767 | 2021-02-20 | Monroe | Indiana | 18105 | 10194 | 161 |
1047874 | 1047874 | 2021-02-20 | Monroe | Iowa | 19135 | 873 | 27 |
1048098 | 1048098 | 2021-02-20 | Monroe | Kentucky | 21171 | 1245 | 38 |
1048312 | 1048312 | 2021-02-20 | Monroe | Michigan | 26115 | 9614 | 198 |
1048474 | 1048474 | 2021-02-20 | Monroe | Mississippi | 28095 | 3963 | 125 |
1048579 | 1048579 | 2021-02-20 | Monroe | Missouri | 29137 | 589 | 10 |
1048884 | 1048884 | 2021-02-20 | Monroe | New York | 36055 | 51424 | 969 |
1049128 | 1049128 | 2021-02-20 | Monroe | Ohio | 39111 | 1136 | 37 |
1049319 | 1049319 | 2021-02-20 | Monroe | Pennsylvania | 42089 | 9390 | 261 |
1049600 | 1049600 | 2021-02-20 | Monroe | Tennessee | 47123 | 5216 | 88 |
1050140 | 1050140 | 2021-02-20 | Monroe | West Virginia | 54063 | 931 | 12 |
1050205 | 1050205 | 2021-02-20 | Monroe | Wisconsin | 55081 | 4350 | 32 |
1043816 | 1043816 | 2021-02-19 | Monroe | Alabama | 1099 | 1650 | 38 |
1043924 | 1043924 | 2021-02-19 | Monroe | Arkansas | 5095 | 819 | 17 |
1044132 | 1044132 | 2021-02-19 | Monroe | Florida | 12087 | 5657 | 44 |
1044258 | 1044258 | 2021-02-19 | Monroe | Georgia | 13207 | 2320 | 87 |
1044433 | 1044433 | 2021-02-19 | Monroe | Illinois | 17133 | 4011 | 80 |
1044522 | 1044522 | 2021-02-19 | Monroe | Indiana | 18105 | 10171 | 161 |
1044629 | 1044629 | 2021-02-19 | Monroe | Iowa | 19135 | 873 | 27 |
1044853 | 1044853 | 2021-02-19 | Monroe | Kentucky | 21171 | 1241 | 38 |
1045066 | 1045066 | 2021-02-19 | Monroe | Michigan | 26115 | 9600 | 198 |
1045228 | 1045228 | 2021-02-19 | Monroe | Mississippi | 28095 | 3961 | 125 |
1045333 | 1045333 | 2021-02-19 | Monroe | Missouri | 29137 | 589 | 10 |
1045637 | 1045637 | 2021-02-19 | Monroe | New York | 36055 | 51256 | 968 |
1045881 | 1045881 | 2021-02-19 | Monroe | Ohio | 39111 | 1136 | 37 |
1046072 | 1046072 | 2021-02-19 | Monroe | Pennsylvania | 42089 | 9353 | 260 |
1046353 | 1046353 | 2021-02-19 | Monroe | Tennessee | 47123 | 5197 | 88 |
1046893 | 1046893 | 2021-02-19 | Monroe | West Virginia | 54063 | 930 | 12 |
1046958 | 1046958 | 2021-02-19 | Monroe | Wisconsin | 55081 | 4341 | 31 |
1040571 | 1040571 | 2021-02-18 | Monroe | Alabama | 1099 | 1651 | 37 |
1040679 | 1040679 | 2021-02-18 | Monroe | Arkansas | 5095 | 818 | 17 |
1040887 | 1040887 | 2021-02-18 | Monroe | Florida | 12087 | 5633 | 44 |
1041013 | 1041013 | 2021-02-18 | Monroe | Georgia | 13207 | 2305 | 87 |
1041188 | 1041188 | 2021-02-18 | Monroe | Illinois | 17133 | 4005 | 80 |
1041277 | 1041277 | 2021-02-18 | Monroe | Indiana | 18105 | 10152 | 160 |
1041384 | 1041384 | 2021-02-18 | Monroe | Iowa | 19135 | 873 | 27 |
1041608 | 1041608 | 2021-02-18 | Monroe | Kentucky | 21171 | 1235 | 37 |
1041821 | 1041821 | 2021-02-18 | Monroe | Michigan | 26115 | 9567 | 198 |
1041983 | 1041983 | 2021-02-18 | Monroe | Mississippi | 28095 | 3961 | 125 |
1042088 | 1042088 | 2021-02-18 | Monroe | Missouri | 29137 | 588 | 10 |
1042392 | 1042392 | 2021-02-18 | Monroe | New York | 36055 | 51135 | 964 |
1042636 | 1042636 | 2021-02-18 | Monroe | Ohio | 39111 | 1133 | 37 |
1042827 | 1042827 | 2021-02-18 | Monroe | Pennsylvania | 42089 | 9317 | 259 |
1043108 | 1043108 | 2021-02-18 | Monroe | Tennessee | 47123 | 5190 | 88 |
1043648 | 1043648 | 2021-02-18 | Monroe | West Virginia | 54063 | 929 | 12 |
1043713 | 1043713 | 2021-02-18 | Monroe | Wisconsin | 55081 | 4333 | 31 |
1037326 | 1037326 | 2021-02-17 | Monroe | Alabama | 1099 | 1646 | 37 |
1037434 | 1037434 | 2021-02-17 | Monroe | Arkansas | 5095 | 815 | 17 |
1037642 | 1037642 | 2021-02-17 | Monroe | Florida | 12087 | 5626 | 44 |
1037768 | 1037768 | 2021-02-17 | Monroe | Georgia | 13207 | 2289 | 87 |
1037943 | 1037943 | 2021-02-17 | Monroe | Illinois | 17133 | 3994 | 80 |
1038032 | 1038032 | 2021-02-17 | Monroe | Indiana | 18105 | 10147 | 160 |
1038139 | 1038139 | 2021-02-17 | Monroe | Iowa | 19135 | 873 | 27 |
1038363 | 1038363 | 2021-02-17 | Monroe | Kentucky | 21171 | 1235 | 36 |
1038576 | 1038576 | 2021-02-17 | Monroe | Michigan | 26115 | 9561 | 197 |
1038738 | 1038738 | 2021-02-17 | Monroe | Mississippi | 28095 | 3961 | 125 |
1038843 | 1038843 | 2021-02-17 | Monroe | Missouri | 29137 | 587 | 10 |
1039147 | 1039147 | 2021-02-17 | Monroe | New York | 36055 | 50936 | 960 |
1039391 | 1039391 | 2021-02-17 | Monroe | Ohio | 39111 | 1134 | 37 |
1039582 | 1039582 | 2021-02-17 | Monroe | Pennsylvania | 42089 | 9273 | 259 |
1039863 | 1039863 | 2021-02-17 | Monroe | Tennessee | 47123 | 5168 | 87 |
1040403 | 1040403 | 2021-02-17 | Monroe | West Virginia | 54063 | 928 | 12 |
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);