ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
67 rows where cases = 5200 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 28
- Missouri 8
- Mississippi 7
- Georgia 5
- Washington 5
- Wisconsin 5
- Idaho 4
- North Carolina 4
- Tennessee 3
- Virginia 3
- Alabama 2
- Ohio 2
- Texas 2
- Utah 2
- Arkansas 1
- California 1
- Florida 1
- Indiana 1
- Kentucky 1
- Minnesota 1
- New Mexico 1
- New York 1
- North Dakota 1
- Oklahoma 1
- Pennsylvania 1
- Puerto Rico 1
- South Carolina 1
- South Dakota 1
- West Virginia 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2408330 | 2408330 | 2022-04-14 | Langlade | Wisconsin | 55067 | 5200 | 90 |
2404769 | 2404769 | 2022-04-13 | Carbon | Utah | 49007 | 5200 | 46 |
2405074 | 2405074 | 2022-04-13 | Langlade | Wisconsin | 55067 | 5200 | 90 |
2401514 | 2401514 | 2022-04-12 | Carbon | Utah | 49007 | 5200 | 46 |
2338635 | 2338635 | 2022-03-24 | Lincoln | New Mexico | 35027 | 5200 | 65 |
2340025 | 2340025 | 2022-03-24 | Vilas | Wisconsin | 55125 | 5200 | 88 |
2325287 | 2325287 | 2022-03-20 | Winston | Mississippi | 28159 | 5200 | 103 |
2322033 | 2322033 | 2022-03-19 | Winston | Mississippi | 28159 | 5200 | 103 |
2318779 | 2318779 | 2022-03-18 | Winston | Mississippi | 28159 | 5200 | 103 |
2315526 | 2315526 | 2022-03-17 | Winston | Mississippi | 28159 | 5200 | 103 |
2312273 | 2312273 | 2022-03-16 | Winston | Mississippi | 28159 | 5200 | 103 |
2309020 | 2309020 | 2022-03-15 | Winston | Mississippi | 28159 | 5200 | 103 |
2305768 | 2305768 | 2022-03-14 | Winston | Mississippi | 28159 | 5200 | 103 |
2284814 | 2284814 | 2022-03-08 | Pickens | Alabama | 1107 | 5200 | 98 |
2283432 | 2283432 | 2022-03-07 | Caswell | North Carolina | 37033 | 5200 | 43 |
2259235 | 2259235 | 2022-02-28 | Mitchell | Georgia | 13205 | 5200 | 111 |
2245201 | 2245201 | 2022-02-23 | Gillespie | Texas | 48171 | 5200 | 103 |
2193499 | 2193499 | 2022-02-07 | Scott | Virginia | 51169 | 5200 | 95 |
2122722 | 2122722 | 2022-01-17 | Latah | Idaho | 16057 | 5200 | 41 |
2119470 | 2119470 | 2022-01-16 | Latah | Idaho | 16057 | 5200 | 41 |
2116218 | 2116218 | 2022-01-15 | Latah | Idaho | 16057 | 5200 | 41 |
2112967 | 2112967 | 2022-01-14 | Latah | Idaho | 16057 | 5200 | 41 |
1962680 | 1962680 | 2021-11-28 | Kittitas | Washington | 53037 | 5200 | 55 |
1959429 | 1959429 | 2021-11-27 | Kittitas | Washington | 53037 | 5200 | 55 |
1956178 | 1956178 | 2021-11-26 | Kittitas | Washington | 53037 | 5200 | 55 |
1952927 | 1952927 | 2021-11-25 | Kittitas | Washington | 53037 | 5200 | 55 |
1949676 | 1949676 | 2021-11-24 | Kittitas | Washington | 53037 | 5200 | 55 |
1930097 | 1930097 | 2021-11-18 | Manassas city | Virginia | 51683 | 5200 | 53 |
1906626 | 1906626 | 2021-11-11 | Clarion | Pennsylvania | 42031 | 5200 | 130 |
1907561 | 1907561 | 2021-11-11 | Trempealeau | Wisconsin | 55121 | 5200 | 52 |
1870155 | 1870155 | 2021-10-31 | Lawrence | Missouri | 29109 | 5200 | 103 |
1866906 | 1866906 | 2021-10-30 | Lawrence | Missouri | 29109 | 5200 | 103 |
1853743 | 1853743 | 2021-10-26 | Polk | Minnesota | 27119 | 5200 | 80 |
1854933 | 1854933 | 2021-10-26 | Lauderdale | Tennessee | 47097 | 5200 | 64 |
1850691 | 1850691 | 2021-10-25 | Pulaski | Missouri | 29169 | 5200 | 79 |
1730975 | 1730975 | 2021-09-18 | Fulton | Ohio | 39051 | 5200 | 82 |
1675204 | 1675204 | 2021-09-01 | Howell | Missouri | 29091 | 5200 | 65 |
1636740 | 1636740 | 2021-08-20 | Williams | North Dakota | 38105 | 5200 | 41 |
1613527 | 1613527 | 2021-08-13 | Phelps | Missouri | 29161 | 5200 | 155 |
1576704 | 1576704 | 2021-08-02 | Murray | Georgia | 13213 | 5200 | 92 |
1491660 | 1491660 | 2021-07-06 | Mercer | West Virginia | 54055 | 5200 | 128 |
1438183 | 1438183 | 2021-06-20 | Pettis | Missouri | 29159 | 5200 | 77 |
1434936 | 1434936 | 2021-06-19 | Pettis | Missouri | 29159 | 5200 | 77 |
1422924 | 1422924 | 2021-06-15 | Fayette | Tennessee | 47047 | 5200 | 85 |
1308825 | 1308825 | 2021-05-11 | Athens | Ohio | 39009 | 5200 | 58 |
1299383 | 1299383 | 2021-05-08 | Guaynabo | Puerto Rico | 72061 | 5200 | |
1272913 | 1272913 | 2021-04-30 | Genesee | New York | 36037 | 5200 | 121 |
1141909 | 1141909 | 2021-03-21 | Noble | Indiana | 18113 | 5200 | 82 |
1117643 | 1117643 | 2021-03-13 | Brown | South Dakota | 46013 | 5200 | 89 |
1079156 | 1079156 | 2021-03-01 | Augusta | Virginia | 51015 | 5200 | 59 |
1063666 | 1063666 | 2021-02-25 | Coffee | Georgia | 13069 | 5200 | 150 |
1006980 | 1006980 | 2021-02-07 | Cherokee | Oklahoma | 40021 | 5200 | 38 |
934442 | 934442 | 2021-01-16 | Christian | Kentucky | 21047 | 5200 | 69 |
926553 | 926553 | 2021-01-13 | Wise | Texas | 48497 | 5200 | 76 |
915936 | 915936 | 2021-01-10 | Surry | North Carolina | 37171 | 5200 | 92 |
854204 | 854204 | 2020-12-22 | Caldwell | North Carolina | 37027 | 5200 | 27 |
829607 | 829607 | 2020-12-15 | Lauderdale | Alabama | 1077 | 5200 | 61 |
790795 | 790795 | 2020-12-03 | Saline | Arkansas | 5125 | 5200 | 59 |
700194 | 700194 | 2020-11-05 | Columbia | Georgia | 13073 | 5200 | 71 |
624341 | 624341 | 2020-10-12 | Florence | South Carolina | 45041 | 5200 | 198 |
614787 | 614787 | 2020-10-09 | Sumner | Tennessee | 47165 | 5200 | 104 |
607690 | 607690 | 2020-10-07 | Union | North Carolina | 37179 | 5200 | 59 |
569997 | 569997 | 2020-09-25 | Racine | Wisconsin | 55101 | 5200 | 95 |
547745 | 547745 | 2020-09-19 | Santa Rosa | Florida | 12113 | 5200 | 69 |
505725 | 505725 | 2020-09-06 | Cherokee | Georgia | 13057 | 5200 | 81 |
416491 | 416491 | 2020-08-09 | St. Louis city | Missouri | 29510 | 5200 | 174 |
190925 | 190925 | 2020-05-30 | San Bernardino | California | 6071 | 5200 | 204 |
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);