ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
163 rows where cases = 3355 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 16
- Mississippi 11
- Indiana 10
- North Carolina 9
- Alabama 8
- Arkansas 8
- North Dakota 8
- Oklahoma 8
- Pennsylvania 8
- Tennessee 8
- Illinois 6
- Minnesota 6
- Wisconsin 6
- Georgia 4
- New Mexico 4
- Oregon 4
- Louisiana 3
- Ohio 3
- Puerto Rico 3
- Washington 3
- Arizona 2
- California 2
- Florida 2
- Kansas 2
- Kentucky 2
- Missouri 2
- South Carolina 2
- Colorado 1
- Hawaii 1
- Idaho 1
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2492194 | 2492194 | 2022-05-10 | Orocovis | Puerto Rico | 72107 | 3355 | |
2452781 | 2452781 | 2022-04-28 | Walsh | North Dakota | 38099 | 3355 | 34 |
2449525 | 2449525 | 2022-04-27 | Walsh | North Dakota | 38099 | 3355 | 34 |
2446268 | 2446268 | 2022-04-26 | Walsh | North Dakota | 38099 | 3355 | 34 |
2443013 | 2443013 | 2022-04-25 | Walsh | North Dakota | 38099 | 3355 | 34 |
2439757 | 2439757 | 2022-04-24 | Walsh | North Dakota | 38099 | 3355 | 34 |
2439939 | 2439939 | 2022-04-24 | Curry | Oregon | 41015 | 3355 | 54 |
2436501 | 2436501 | 2022-04-23 | Walsh | North Dakota | 38099 | 3355 | 34 |
2436683 | 2436683 | 2022-04-23 | Curry | Oregon | 41015 | 3355 | 54 |
2433245 | 2433245 | 2022-04-22 | Walsh | North Dakota | 38099 | 3355 | 34 |
2433427 | 2433427 | 2022-04-22 | Curry | Oregon | 41015 | 3355 | 54 |
2382620 | 2382620 | 2022-04-07 | Gunnison | Colorado | 8051 | 3355 | 14 |
2282748 | 2282748 | 2022-03-07 | Nantucket | Massachusetts | 25019 | 3355 | 0 |
2257889 | 2257889 | 2022-02-27 | Salinas | Puerto Rico | 72123 | 3355 | |
2258348 | 2258348 | 2022-02-27 | Tyler | Texas | 48457 | 3355 | 83 |
2255097 | 2255097 | 2022-02-26 | Tyler | Texas | 48457 | 3355 | 83 |
2193892 | 2193892 | 2022-02-08 | Van Buren | Arkansas | 5141 | 3355 | 51 |
2180083 | 2180083 | 2022-02-03 | Bandera | Texas | 48019 | 3355 | 70 |
2168355 | 2168355 | 2022-01-31 | Menard | Illinois | 17129 | 3355 | 22 |
2090212 | 2090212 | 2022-01-07 | Minidoka | Idaho | 16067 | 3355 | 54 |
2073394 | 2073394 | 2022-01-02 | Hale | Alabama | 1065 | 3355 | 91 |
2028417 | 2028417 | 2021-12-19 | Kauai | Hawaii | 15007 | 3355 | 14 |
2001980 | 2001980 | 2021-12-11 | Conway | Arkansas | 5029 | 3355 | 46 |
1998658 | 1998658 | 2021-12-10 | Pickens | Alabama | 1107 | 3355 | 91 |
1995407 | 1995407 | 2021-12-09 | Pickens | Alabama | 1107 | 3355 | 90 |
1992156 | 1992156 | 2021-12-08 | Pickens | Alabama | 1107 | 3355 | 90 |
1988905 | 1988905 | 2021-12-07 | Pickens | Alabama | 1107 | 3355 | 90 |
1990460 | 1990460 | 2021-12-07 | Vernon | Missouri | 29217 | 3355 | 82 |
1939768 | 1939768 | 2021-11-21 | Windsor | Vermont | 50027 | 3355 | 33 |
1919289 | 1919289 | 2021-11-15 | Greene | North Carolina | 37079 | 3355 | 55 |
1899265 | 1899265 | 2021-11-09 | Attala | Mississippi | 28007 | 3355 | 90 |
1892765 | 1892765 | 2021-11-07 | Attala | Mississippi | 28007 | 3355 | 90 |
1889515 | 1889515 | 2021-11-06 | Attala | Mississippi | 28007 | 3355 | 90 |
1886265 | 1886265 | 2021-11-05 | Attala | Mississippi | 28007 | 3355 | 90 |
1846509 | 1846509 | 2021-10-24 | Lawrence | Illinois | 17101 | 3355 | 42 |
1843259 | 1843259 | 2021-10-23 | Lawrence | Illinois | 17101 | 3355 | 42 |
1840009 | 1840009 | 2021-10-22 | Lawrence | Illinois | 17101 | 3355 | 42 |
1780158 | 1780158 | 2021-10-03 | Bledsoe | Tennessee | 47007 | 3355 | 14 |
1776519 | 1776519 | 2021-10-02 | Van Wert | Ohio | 39161 | 3355 | 73 |
1776908 | 1776908 | 2021-10-02 | Bledsoe | Tennessee | 47007 | 3355 | 14 |
1773658 | 1773658 | 2021-10-01 | Bledsoe | Tennessee | 47007 | 3355 | 14 |
1766726 | 1766726 | 2021-09-29 | Holmes | Ohio | 39075 | 3355 | 112 |
1729040 | 1729040 | 2021-09-18 | Logan | Arkansas | 5083 | 3355 | 34 |
1722391 | 1722391 | 2021-09-16 | Barbour | Alabama | 1005 | 3355 | 67 |
1690677 | 1690677 | 2021-09-06 | Posey | Indiana | 18129 | 3355 | 38 |
1687427 | 1687427 | 2021-09-05 | Posey | Indiana | 18129 | 3355 | 38 |
1684177 | 1684177 | 2021-09-04 | Posey | Indiana | 18129 | 3355 | 38 |
1680926 | 1680926 | 2021-09-03 | Posey | Indiana | 18129 | 3355 | 38 |
1672597 | 1672597 | 2021-08-31 | Jackson | Oklahoma | 40065 | 3355 | 57 |
1669349 | 1669349 | 2021-08-30 | Jackson | Oklahoma | 40065 | 3355 | 57 |
1666102 | 1666102 | 2021-08-29 | Jackson | Oklahoma | 40065 | 3355 | 57 |
1662854 | 1662854 | 2021-08-28 | Jackson | Oklahoma | 40065 | 3355 | 57 |
1659606 | 1659606 | 2021-08-27 | Jackson | Oklahoma | 40065 | 3355 | 57 |
1656357 | 1656357 | 2021-08-26 | Jackson | Oklahoma | 40065 | 3355 | 57 |
1653110 | 1653110 | 2021-08-25 | Jackson | Oklahoma | 40065 | 3355 | 57 |
1648172 | 1648172 | 2021-08-24 | Monroe | Georgia | 13207 | 3355 | 110 |
1647137 | 1647137 | 2021-08-23 | Frio | Texas | 48163 | 3355 | 57 |
1643888 | 1643888 | 2021-08-22 | Frio | Texas | 48163 | 3355 | 57 |
1640638 | 1640638 | 2021-08-21 | Frio | Texas | 48163 | 3355 | 57 |
1627039 | 1627039 | 2021-08-17 | Jackson | Ohio | 39079 | 3355 | 54 |
1611887 | 1611887 | 2021-08-12 | Lincoln | Wisconsin | 55069 | 3355 | 97 |
1600913 | 1600913 | 2021-08-09 | Macon | North Carolina | 37113 | 3355 | 41 |
1572010 | 1572010 | 2021-07-31 | Jefferson | Pennsylvania | 42065 | 3355 | 99 |
1568762 | 1568762 | 2021-07-30 | Jefferson | Pennsylvania | 42065 | 3355 | 99 |
1565514 | 1565514 | 2021-07-29 | Jefferson | Pennsylvania | 42065 | 3355 | 99 |
1561058 | 1561058 | 2021-07-28 | Muhlenberg | Kentucky | 21177 | 3355 | 70 |
1554950 | 1554950 | 2021-07-26 | Scott | Mississippi | 28123 | 3355 | 75 |
1550372 | 1550372 | 2021-07-25 | Jackson | Arkansas | 5067 | 3355 | 38 |
1542037 | 1542037 | 2021-07-22 | Lafayette | Missouri | 29107 | 3355 | 57 |
1493166 | 1493166 | 2021-07-07 | Pine | Minnesota | 27115 | 3355 | 23 |
1489330 | 1489330 | 2021-07-06 | White | Indiana | 18181 | 3355 | 55 |
1489919 | 1489919 | 2021-07-06 | Pine | Minnesota | 27115 | 3355 | 23 |
1486672 | 1486672 | 2021-07-05 | Pine | Minnesota | 27115 | 3355 | 23 |
1483426 | 1483426 | 2021-07-04 | Pine | Minnesota | 27115 | 3355 | 23 |
1485222 | 1485222 | 2021-07-04 | Juneau | Wisconsin | 55057 | 3355 | 31 |
1480180 | 1480180 | 2021-07-03 | Pine | Minnesota | 27115 | 3355 | 23 |
1481976 | 1481976 | 2021-07-03 | Juneau | Wisconsin | 55057 | 3355 | 31 |
1478729 | 1478729 | 2021-07-02 | Juneau | Wisconsin | 55057 | 3355 | 31 |
1471349 | 1471349 | 2021-06-30 | Greene | Pennsylvania | 42059 | 3355 | 41 |
1467585 | 1467585 | 2021-06-29 | Lyon | Nevada | 32019 | 3355 | 65 |
1419880 | 1419880 | 2021-06-14 | Kendall | Texas | 48259 | 3355 | 72 |
1416635 | 1416635 | 2021-06-13 | Kendall | Texas | 48259 | 3355 | 72 |
1413389 | 1413389 | 2021-06-12 | Kendall | Texas | 48259 | 3355 | 72 |
1401644 | 1401644 | 2021-06-09 | Jefferson | Indiana | 18077 | 3355 | 85 |
1393129 | 1393129 | 2021-06-06 | Montgomery | North Carolina | 37123 | 3355 | 96 |
1389884 | 1389884 | 2021-06-05 | Montgomery | North Carolina | 37123 | 3355 | 96 |
1386639 | 1386639 | 2021-06-04 | Montgomery | North Carolina | 37123 | 3355 | 96 |
1382900 | 1382900 | 2021-06-03 | Pike | Mississippi | 28113 | 3355 | 107 |
1354046 | 1354046 | 2021-05-25 | Luna | New Mexico | 35029 | 3355 | 92 |
1350800 | 1350800 | 2021-05-24 | Luna | New Mexico | 35029 | 3355 | 92 |
1318745 | 1318745 | 2021-05-14 | Josephine | Oregon | 41033 | 3355 | 70 |
1302242 | 1302242 | 2021-05-09 | Pasquotank | North Carolina | 37139 | 3355 | 80 |
1298994 | 1298994 | 2021-05-08 | Pasquotank | North Carolina | 37139 | 3355 | 80 |
1295748 | 1295748 | 2021-05-07 | Pasquotank | North Carolina | 37139 | 3355 | 80 |
1288763 | 1288763 | 2021-05-05 | Sunflower | Mississippi | 28133 | 3355 | 90 |
1268728 | 1268728 | 2021-04-29 | Geary | Kansas | 20061 | 3355 | 40 |
1265481 | 1265481 | 2021-04-28 | Geary | Kansas | 20061 | 3355 | 40 |
1238967 | 1238967 | 2021-04-20 | Wakulla | Florida | 12129 | 3355 | 54 |
1222843 | 1222843 | 2021-04-15 | Pickens | Georgia | 13227 | 3355 | 74 |
1205172 | 1205172 | 2021-04-09 | Snyder | Pennsylvania | 42109 | 3355 | 82 |
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);