ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where cases = 10044 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state 21
- Mississippi 6
- Alabama 3
- Idaho 3
- South Carolina 3
- Florida 2
- Georgia 2
- Indiana 2
- Ohio 2
- Arkansas 1
- California 1
- Connecticut 1
- Illinois 1
- Kentucky 1
- Louisiana 1
- Maryland 1
- Massachusetts 1
- Nebraska 1
- Pennsylvania 1
- Puerto Rico 1
- Tennessee 1
- Texas 1
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2416323 | 2416323 | 2022-04-17 | Alcorn | Mississippi | 28003 | 10044 | 160 |
2413067 | 2413067 | 2022-04-16 | Alcorn | Mississippi | 28003 | 10044 | 160 |
2409811 | 2409811 | 2022-04-15 | Alcorn | Mississippi | 28003 | 10044 | 160 |
2406555 | 2406555 | 2022-04-14 | Alcorn | Mississippi | 28003 | 10044 | 160 |
2403299 | 2403299 | 2022-04-13 | Alcorn | Mississippi | 28003 | 10044 | 160 |
2400045 | 2400045 | 2022-04-12 | Alcorn | Mississippi | 28003 | 10044 | 160 |
2270196 | 2270196 | 2022-03-03 | Dodge | Nebraska | 31053 | 10044 | 90 |
2257923 | 2257923 | 2022-02-27 | Chester | South Carolina | 45023 | 10044 | 136 |
2254672 | 2254672 | 2022-02-26 | Chester | South Carolina | 45023 | 10044 | 136 |
2251421 | 2251421 | 2022-02-25 | Chester | South Carolina | 45023 | 10044 | 136 |
2240394 | 2240394 | 2022-02-22 | Natchitoches | Louisiana | 22069 | 10044 | 157 |
2215339 | 2215339 | 2022-02-14 | Logan | Ohio | 39091 | 10044 | 153 |
1938913 | 1938913 | 2021-11-21 | Belmont | Ohio | 39013 | 10044 | 231 |
1789922 | 1789922 | 2021-10-06 | Dickson | Tennessee | 47043 | 10044 | 159 |
1651992 | 1651992 | 2021-08-25 | Laurel | Kentucky | 21125 | 10044 | 87 |
1625685 | 1625685 | 2021-08-17 | Kosciusko | Indiana | 18085 | 10044 | 129 |
1556761 | 1556761 | 2021-07-27 | Lauderdale | Alabama | 1077 | 10044 | 253 |
1537837 | 1537837 | 2021-07-21 | Twin Falls | Idaho | 16083 | 10044 | 133 |
1498298 | 1498298 | 2021-07-09 | Cullman | Alabama | 1043 | 10044 | 202 |
1459537 | 1459537 | 2021-06-27 | Napa | California | 6055 | 10044 | 81 |
1293801 | 1293801 | 2021-05-07 | Elmore | Alabama | 1051 | 10044 | 205 |
1207313 | 1207313 | 2021-04-10 | Charles | Maryland | 24017 | 10044 | 179 |
1189994 | 1189994 | 2021-04-05 | Garland | Arkansas | 5051 | 10044 | 255 |
1145117 | 1145117 | 2021-03-22 | Delaware | Indiana | 18035 | 10044 | 188 |
1104499 | 1104499 | 2021-03-09 | Monroe | Pennsylvania | 42089 | 10044 | 273 |
1055845 | 1055845 | 2021-02-22 | Bayamon | Puerto Rico | 72021 | 10044 | |
1037588 | 1037588 | 2021-02-17 | Middlesex | Connecticut | 9007 | 10044 | 335 |
933846 | 933846 | 2021-01-16 | Coweta | Georgia | 13077 | 10044 | 98 |
920903 | 920903 | 2021-01-12 | Houston | Georgia | 13153 | 10044 | 148 |
862588 | 862588 | 2020-12-25 | Bonneville | Idaho | 16019 | 10044 | 108 |
859343 | 859343 | 2020-12-24 | Bonneville | Idaho | 16019 | 10044 | 108 |
664414 | 664414 | 2020-10-25 | Alachua | Florida | 12001 | 10044 | 74 |
664470 | 664470 | 2020-10-25 | Seminole | Florida | 12117 | 10044 | 236 |
551844 | 551844 | 2020-09-20 | Norfolk | Massachusetts | 25021 | 10044 | 1047 |
540422 | 540422 | 2020-09-16 | Lubbock | Texas | 48303 | 10044 | 113 |
309836 | 309836 | 2020-07-07 | Lake | Illinois | 17097 | 10044 | 425 |
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);