ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

5,119 rows where county = "Monroe" sorted by date descending

✎ View and edit SQL

This data as json, yaml, copyable, CSV (advanced)

Suggested facets: date (date)

state

fips

county

  • Monroe · 5,119 ✖
Link rowid date ▲ county state fips cases deaths
959512 959512 2021-01-24 Monroe Alabama 1099 1524 21
959620 959620 2021-01-24 Monroe Arkansas 5095 667 14
959828 959828 2021-01-24 Monroe Florida 12087 5158 39
959954 959954 2021-01-24 Monroe Georgia 13207 2050 78
960129 960129 2021-01-24 Monroe Illinois 17133 3673 71
960217 960217 2021-01-24 Monroe Indiana 18105 9429 117
960324 960324 2021-01-24 Monroe Iowa 19135 822 20
960548 960548 2021-01-24 Monroe Kentucky 21171 1118 33
960762 960762 2021-01-24 Monroe Michigan 26115 8909 176
960924 960924 2021-01-24 Monroe Mississippi 28095 3686 110
961029 961029 2021-01-24 Monroe Missouri 29137 570 7
961333 961333 2021-01-24 Monroe New York 36055 46065 822
961577 961577 2021-01-24 Monroe Ohio 39111 1010 32
961768 961768 2021-01-24 Monroe Pennsylvania 42089 8147 238
962049 962049 2021-01-24 Monroe Tennessee 47123 4716 63
962589 962589 2021-01-24 Monroe West Virginia 54063 850 11
962654 962654 2021-01-24 Monroe Wisconsin 55081 4073 31
956266 956266 2021-01-23 Monroe Alabama 1099 1520 21
956374 956374 2021-01-23 Monroe Arkansas 5095 660 14
956582 956582 2021-01-23 Monroe Florida 12087 5135 39
956708 956708 2021-01-23 Monroe Georgia 13207 2042 78
956883 956883 2021-01-23 Monroe Illinois 17133 3667 71
956971 956971 2021-01-23 Monroe Indiana 18105 9388 114
957078 957078 2021-01-23 Monroe Iowa 19135 822 20
957302 957302 2021-01-23 Monroe Kentucky 21171 1116 33
957516 957516 2021-01-23 Monroe Michigan 26115 8909 176
957678 957678 2021-01-23 Monroe Mississippi 28095 3671 108
957783 957783 2021-01-23 Monroe Missouri 29137 568 7
958088 958088 2021-01-23 Monroe New York 36055 45707 816
958332 958332 2021-01-23 Monroe Ohio 39111 1007 32
958523 958523 2021-01-23 Monroe Pennsylvania 42089 8102 237
958804 958804 2021-01-23 Monroe Tennessee 47123 4703 63
959344 959344 2021-01-23 Monroe West Virginia 54063 849 11
959409 959409 2021-01-23 Monroe Wisconsin 55081 4054 31
953021 953021 2021-01-22 Monroe Alabama 1099 1513 20
953129 953129 2021-01-22 Monroe Arkansas 5095 653 14
953337 953337 2021-01-22 Monroe Florida 12087 5105 39
953463 953463 2021-01-22 Monroe Georgia 13207 2024 78
953638 953638 2021-01-22 Monroe Illinois 17133 3651 71
953726 953726 2021-01-22 Monroe Indiana 18105 9343 114
953833 953833 2021-01-22 Monroe Iowa 19135 819 19
954057 954057 2021-01-22 Monroe Kentucky 21171 1111 33
954271 954271 2021-01-22 Monroe Michigan 26115 8876 173
954433 954433 2021-01-22 Monroe Mississippi 28095 3651 106
954538 954538 2021-01-22 Monroe Missouri 29137 567 7
954842 954842 2021-01-22 Monroe New York 36055 45401 804
955086 955086 2021-01-22 Monroe Ohio 39111 1006 31
955277 955277 2021-01-22 Monroe Pennsylvania 42089 8025 235
955558 955558 2021-01-22 Monroe Tennessee 47123 4670 63
956098 956098 2021-01-22 Monroe West Virginia 54063 845 11
956163 956163 2021-01-22 Monroe Wisconsin 55081 4033 31
949776 949776 2021-01-21 Monroe Alabama 1099 1507 18
949884 949884 2021-01-21 Monroe Arkansas 5095 640 14
950092 950092 2021-01-21 Monroe Florida 12087 5057 40
950218 950218 2021-01-21 Monroe Georgia 13207 2006 78
950393 950393 2021-01-21 Monroe Illinois 17133 3628 71
950481 950481 2021-01-21 Monroe Indiana 18105 9304 114
950588 950588 2021-01-21 Monroe Iowa 19135 814 19
950812 950812 2021-01-21 Monroe Kentucky 21171 1107 33
951026 951026 2021-01-21 Monroe Michigan 26115 8825 171
951188 951188 2021-01-21 Monroe Mississippi 28095 3628 105
951293 951293 2021-01-21 Monroe Missouri 29137 565 7
951597 951597 2021-01-21 Monroe New York 36055 45003 791
951841 951841 2021-01-21 Monroe Ohio 39111 1003 31
952032 952032 2021-01-21 Monroe Pennsylvania 42089 7940 234
952313 952313 2021-01-21 Monroe Tennessee 47123 4640 63
952853 952853 2021-01-21 Monroe West Virginia 54063 839 11
952918 952918 2021-01-21 Monroe Wisconsin 55081 3993 31
946530 946530 2021-01-20 Monroe Alabama 1099 1498 18
946638 946638 2021-01-20 Monroe Arkansas 5095 629 14
946846 946846 2021-01-20 Monroe Florida 12087 5024 37
946972 946972 2021-01-20 Monroe Georgia 13207 1987 78
947147 947147 2021-01-20 Monroe Illinois 17133 3608 71
947235 947235 2021-01-20 Monroe Indiana 18105 9227 113
947342 947342 2021-01-20 Monroe Iowa 19135 813 19
947566 947566 2021-01-20 Monroe Kentucky 21171 1103 32
947780 947780 2021-01-20 Monroe Michigan 26115 8774 172
947942 947942 2021-01-20 Monroe Mississippi 28095 3591 105
948047 948047 2021-01-20 Monroe Missouri 29137 563 7
948352 948352 2021-01-20 Monroe New York 36055 44632 780
948596 948596 2021-01-20 Monroe Ohio 39111 991 31
948787 948787 2021-01-20 Monroe Pennsylvania 42089 7882 232
949068 949068 2021-01-20 Monroe Tennessee 47123 4627 63
949608 949608 2021-01-20 Monroe West Virginia 54063 834 11
949673 949673 2021-01-20 Monroe Wisconsin 55081 3959 29
943283 943283 2021-01-19 Monroe Alabama 1099 1473 17
943391 943391 2021-01-19 Monroe Arkansas 5095 619 13
943599 943599 2021-01-19 Monroe Florida 12087 4993 37
943725 943725 2021-01-19 Monroe Georgia 13207 1970 76
943900 943900 2021-01-19 Monroe Illinois 17133 3587 70
943988 943988 2021-01-19 Monroe Indiana 18105 9194 112
944095 944095 2021-01-19 Monroe Iowa 19135 812 18
944319 944319 2021-01-19 Monroe Kentucky 21171 1096 32
944533 944533 2021-01-19 Monroe Michigan 26115 8722 173
944695 944695 2021-01-19 Monroe Mississippi 28095 3558 105
944800 944800 2021-01-19 Monroe Missouri 29137 562 7
945105 945105 2021-01-19 Monroe New York 36055 44319 769
945350 945350 2021-01-19 Monroe Ohio 39111 972 29
945541 945541 2021-01-19 Monroe Pennsylvania 42089 7820 230
945822 945822 2021-01-19 Monroe Tennessee 47123 4594 62

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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]);