ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
164 rows where cases = 3031 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Oklahoma 16
- Mississippi 12
- Georgia 11
- Tennessee 9
- Virginia 9
- Arkansas 8
- Indiana 7
- Missouri 7
- California 6
- New York 6
- Texas 6
- Alabama 5
- Colorado 5
- Ohio 5
- Pennsylvania 5
- Puerto Rico 5
- Michigan 4
- Minnesota 4
- Florida 3
- Idaho 3
- Illinois 3
- Kentucky 3
- Maryland 3
- Nevada 3
- Alaska 2
- Maine 2
- North Carolina 2
- South Carolina 2
- Wisconsin 2
- Louisiana 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2447750 | 2447750 | 2022-04-27 | Moffat | Colorado | 8081 | 3031 | 51 |
2426864 | 2426864 | 2022-04-20 | Johnston | Oklahoma | 40069 | 3031 | 54 |
2423608 | 2423608 | 2022-04-19 | Johnston | Oklahoma | 40069 | 3031 | 54 |
2420351 | 2420351 | 2022-04-18 | Johnston | Oklahoma | 40069 | 3031 | 54 |
2417096 | 2417096 | 2022-04-17 | Johnston | Oklahoma | 40069 | 3031 | 54 |
2413840 | 2413840 | 2022-04-16 | Johnston | Oklahoma | 40069 | 3031 | 54 |
2410584 | 2410584 | 2022-04-15 | Johnston | Oklahoma | 40069 | 3031 | 54 |
2407328 | 2407328 | 2022-04-14 | Johnston | Oklahoma | 40069 | 3031 | 54 |
2398834 | 2398834 | 2022-04-12 | Mariposa | California | 6043 | 3031 | 34 |
2400016 | 2400016 | 2022-04-12 | Pope | Minnesota | 27121 | 3031 | 17 |
2396760 | 2396760 | 2022-04-11 | Pope | Minnesota | 27121 | 3031 | 17 |
2381285 | 2381285 | 2022-04-06 | Johnston | Oklahoma | 40069 | 3031 | 53 |
2378030 | 2378030 | 2022-04-05 | Johnston | Oklahoma | 40069 | 3031 | 53 |
2374776 | 2374776 | 2022-04-04 | Johnston | Oklahoma | 40069 | 3031 | 53 |
2371524 | 2371524 | 2022-04-03 | Johnston | Oklahoma | 40069 | 3031 | 53 |
2368271 | 2368271 | 2022-04-02 | Johnston | Oklahoma | 40069 | 3031 | 53 |
2365018 | 2365018 | 2022-04-01 | Johnston | Oklahoma | 40069 | 3031 | 53 |
2361765 | 2361765 | 2022-03-31 | Johnston | Oklahoma | 40069 | 3031 | 53 |
2295735 | 2295735 | 2022-03-11 | Kent | Maryland | 24029 | 3031 | 66 |
2263466 | 2263466 | 2022-03-01 | Perry | Mississippi | 28111 | 3031 | 63 |
2260215 | 2260215 | 2022-02-28 | Perry | Mississippi | 28111 | 3031 | 63 |
2228297 | 2228297 | 2022-02-18 | Unknown | Northern Mariana Islands | 3031 | 2 | |
2188770 | 2188770 | 2022-02-06 | Mississippi | Missouri | 29133 | 3031 | 52 |
2185517 | 2185517 | 2022-02-05 | Mississippi | Missouri | 29133 | 3031 | 52 |
2166009 | 2166009 | 2022-01-30 | Osage | Missouri | 29151 | 3031 | 39 |
2166556 | 2166556 | 2022-01-30 | Morgan | Ohio | 39115 | 3031 | 48 |
2163301 | 2163301 | 2022-01-29 | Morgan | Ohio | 39115 | 3031 | 48 |
2163854 | 2163854 | 2022-01-29 | Comanche | Texas | 48093 | 3031 | 72 |
2148243 | 2148243 | 2022-01-25 | Ketchikan Gateway Borough | Alaska | 2130 | 3031 | 15 |
2144991 | 2144991 | 2022-01-24 | Ketchikan Gateway Borough | Alaska | 2130 | 3031 | 15 |
2119668 | 2119668 | 2022-01-16 | Tipton | Indiana | 18159 | 3031 | 77 |
2116416 | 2116416 | 2022-01-15 | Tipton | Indiana | 18159 | 3031 | 77 |
2113165 | 2113165 | 2022-01-14 | Tipton | Indiana | 18159 | 3031 | 77 |
2082208 | 2082208 | 2022-01-04 | Barranquitas | Puerto Rico | 72019 | 3031 | |
2079776 | 2079776 | 2022-01-03 | Burnett | Wisconsin | 55013 | 3031 | 36 |
2076186 | 2076186 | 2022-01-02 | Robertson | Texas | 48395 | 3031 | 68 |
2072935 | 2072935 | 2022-01-01 | Robertson | Texas | 48395 | 3031 | 68 |
2069684 | 2069684 | 2021-12-31 | Robertson | Texas | 48395 | 3031 | 68 |
2066433 | 2066433 | 2021-12-30 | Robertson | Texas | 48395 | 3031 | 68 |
2053011 | 2053011 | 2021-12-26 | San Sebastian | Puerto Rico | 72131 | 3031 | |
2039907 | 2039907 | 2021-12-22 | Fulton | Pennsylvania | 42057 | 3031 | 44 |
2032213 | 2032213 | 2021-12-20 | Powell | Kentucky | 21197 | 3031 | 27 |
1977042 | 1977042 | 2021-12-03 | Franklin | Maine | 23007 | 3031 | 35 |
1949976 | 1949976 | 2021-11-25 | Cross | Arkansas | 5037 | 3031 | 66 |
1946725 | 1946725 | 2021-11-24 | Cross | Arkansas | 5037 | 3031 | 66 |
1900452 | 1900452 | 2021-11-09 | Sequatchie | Tennessee | 47153 | 3031 | 33 |
1896203 | 1896203 | 2021-11-08 | Texas | Missouri | 29215 | 3031 | 43 |
1860278 | 1860278 | 2021-10-28 | Chickasaw | Mississippi | 28017 | 3031 | 67 |
1857029 | 1857029 | 2021-10-27 | Chickasaw | Mississippi | 28017 | 3031 | 67 |
1838475 | 1838475 | 2021-10-21 | Humacao | Puerto Rico | 72069 | 3031 | |
1833146 | 1833146 | 2021-10-20 | Montezuma | Colorado | 8083 | 3031 | 36 |
1808077 | 1808077 | 2021-10-12 | Caroline | Maryland | 24011 | 3031 | 42 |
1802702 | 1802702 | 2021-10-10 | Aguadilla | Puerto Rico | 72005 | 3031 | |
1799453 | 1799453 | 2021-10-09 | Aguadilla | Puerto Rico | 72005 | 3031 | |
1760742 | 1760742 | 2021-09-27 | Trousdale | Tennessee | 47169 | 3031 | 24 |
1755181 | 1755181 | 2021-09-26 | Routt | Colorado | 8107 | 3031 | 22 |
1751933 | 1751933 | 2021-09-25 | Routt | Colorado | 8107 | 3031 | 22 |
1748684 | 1748684 | 2021-09-24 | Routt | Colorado | 8107 | 3031 | 22 |
1733904 | 1733904 | 2021-09-19 | Churchill | Nevada | 32001 | 3031 | 54 |
1735184 | 1735184 | 2021-09-19 | Staunton city | Virginia | 51790 | 3031 | 75 |
1729036 | 1729036 | 2021-09-18 | Lawrence | Arkansas | 5075 | 3031 | 49 |
1730654 | 1730654 | 2021-09-18 | Churchill | Nevada | 32001 | 3031 | 54 |
1731934 | 1731934 | 2021-09-18 | Staunton city | Virginia | 51790 | 3031 | 75 |
1727404 | 1727404 | 2021-09-17 | Churchill | Nevada | 32001 | 3031 | 54 |
1728684 | 1728684 | 2021-09-17 | Staunton city | Virginia | 51790 | 3031 | 75 |
1722553 | 1722553 | 2021-09-16 | Phillips | Arkansas | 5107 | 3031 | 65 |
1723763 | 1723763 | 2021-09-16 | Meeker | Minnesota | 27093 | 3031 | 49 |
1712696 | 1712696 | 2021-09-13 | Monroe | Alabama | 1099 | 3031 | 44 |
1674149 | 1674149 | 2021-09-01 | McDuffie | Georgia | 13189 | 3031 | 56 |
1664424 | 1664424 | 2021-08-29 | Pike | Georgia | 13231 | 3031 | 47 |
1661176 | 1661176 | 2021-08-28 | Pike | Georgia | 13231 | 3031 | 47 |
1657928 | 1657928 | 2021-08-27 | Pike | Georgia | 13231 | 3031 | 47 |
1654603 | 1654603 | 2021-08-26 | Cook | Georgia | 13075 | 3031 | 46 |
1651051 | 1651051 | 2021-08-25 | Cleburne | Arkansas | 5023 | 3031 | 79 |
1643267 | 1643267 | 2021-08-22 | Fayette | Ohio | 39047 | 3031 | 50 |
1618946 | 1618946 | 2021-08-15 | Peach | Georgia | 13225 | 3031 | 72 |
1615698 | 1615698 | 2021-08-14 | Peach | Georgia | 13225 | 3031 | 72 |
1612449 | 1612449 | 2021-08-13 | Peach | Georgia | 13225 | 3031 | 72 |
1596277 | 1596277 | 2021-08-08 | Cassia | Idaho | 16031 | 3031 | 28 |
1593028 | 1593028 | 2021-08-07 | Cassia | Idaho | 16031 | 3031 | 28 |
1589779 | 1589779 | 2021-08-06 | Cassia | Idaho | 16031 | 3031 | 28 |
1590707 | 1590707 | 2021-08-06 | Audrain | Missouri | 29007 | 3031 | 58 |
1586024 | 1586024 | 2021-08-05 | Winston | Alabama | 1133 | 3031 | 73 |
1561017 | 1561017 | 2021-07-28 | Harlan | Kentucky | 21095 | 3031 | 93 |
1555064 | 1555064 | 2021-07-26 | Saline | Missouri | 29195 | 3031 | 39 |
1511442 | 1511442 | 2021-07-13 | Unknown | Arkansas | 3031 | 0 | |
1504965 | 1504965 | 2021-07-11 | Glenn | California | 6021 | 3031 | 27 |
1501719 | 1501719 | 2021-07-10 | Glenn | California | 6021 | 3031 | 27 |
1498473 | 1498473 | 2021-07-09 | Glenn | California | 6021 | 3031 | 27 |
1495564 | 1495564 | 2021-07-08 | Unknown | Georgia | 3031 | 4 | |
1493211 | 1493211 | 2021-07-07 | Copiah | Mississippi | 28029 | 3031 | 66 |
1490013 | 1490013 | 2021-07-06 | Simpson | Mississippi | 28127 | 3031 | 89 |
1394861 | 1394861 | 2021-06-07 | Gilmer | Georgia | 13123 | 3031 | 87 |
1381232 | 1381232 | 2021-06-02 | Warren | Virginia | 51187 | 3031 | 59 |
1375324 | 1375324 | 2021-06-01 | Unknown | Florida | 3031 | 0 | |
1377987 | 1377987 | 2021-06-01 | Warren | Virginia | 51187 | 3031 | 58 |
1374741 | 1374741 | 2021-05-31 | Warren | Virginia | 51187 | 3031 | 58 |
1364822 | 1364822 | 2021-05-28 | Willacy | Texas | 48489 | 3031 | 88 |
1329813 | 1329813 | 2021-05-18 | Bradford | Florida | 12007 | 3031 | 57 |
1308641 | 1308641 | 2021-05-11 | Orleans | New York | 36073 | 3031 | 83 |
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);