ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
427 rows where cases = 1210 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Puerto Rico 43
- Nebraska 41
- Texas 20
- Virginia 20
- Iowa 19
- Minnesota 18
- North Carolina 18
- Kansas 16
- Georgia 15
- Missouri 15
- Mississippi 14
- Indiana 12
- Kentucky 12
- Louisiana 12
- Washington 12
- Michigan 11
- Arkansas 10
- Tennessee 10
- Oklahoma 9
- Illinois 8
- Maine 8
- Wisconsin 8
- Idaho 7
- Oregon 7
- California 6
- Florida 6
- Colorado 5
- North Dakota 5
- Alabama 4
- New York 4
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500544 | 2500544 | 2022-05-13 | Ottawa | Kansas | 20143 | 1210 | 17 |
2497286 | 2497286 | 2022-05-12 | Ottawa | Kansas | 20143 | 1210 | 17 |
2494028 | 2494028 | 2022-05-11 | Ottawa | Kansas | 20143 | 1210 | 17 |
2490770 | 2490770 | 2022-05-10 | Ottawa | Kansas | 20143 | 1210 | 17 |
2487513 | 2487513 | 2022-05-09 | Ottawa | Kansas | 20143 | 1210 | 17 |
2484255 | 2484255 | 2022-05-08 | Ottawa | Kansas | 20143 | 1210 | 17 |
2485007 | 2485007 | 2022-05-08 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2486005 | 2486005 | 2022-05-08 | Goliad | Texas | 48175 | 1210 | 32 |
2480997 | 2480997 | 2022-05-07 | Ottawa | Kansas | 20143 | 1210 | 17 |
2481749 | 2481749 | 2022-05-07 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2482747 | 2482747 | 2022-05-07 | Goliad | Texas | 48175 | 1210 | 32 |
2477739 | 2477739 | 2022-05-06 | Ottawa | Kansas | 20143 | 1210 | 17 |
2478491 | 2478491 | 2022-05-06 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2475233 | 2475233 | 2022-05-05 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2471976 | 2471976 | 2022-05-04 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2468720 | 2468720 | 2022-05-03 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2465464 | 2465464 | 2022-05-02 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2462209 | 2462209 | 2022-05-01 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2458953 | 2458953 | 2022-04-30 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2455697 | 2455697 | 2022-04-29 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2452441 | 2452441 | 2022-04-28 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2449185 | 2449185 | 2022-04-27 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2445928 | 2445928 | 2022-04-26 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2442673 | 2442673 | 2022-04-25 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2439417 | 2439417 | 2022-04-24 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2436161 | 2436161 | 2022-04-23 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2432905 | 2432905 | 2022-04-22 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2429649 | 2429649 | 2022-04-21 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2426393 | 2426393 | 2022-04-20 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2423137 | 2423137 | 2022-04-19 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2419880 | 2419880 | 2022-04-18 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2416625 | 2416625 | 2022-04-17 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2413369 | 2413369 | 2022-04-16 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2410113 | 2410113 | 2022-04-15 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2406857 | 2406857 | 2022-04-14 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2403601 | 2403601 | 2022-04-13 | Jefferson | Nebraska | 31095 | 1210 | 7 |
2401719 | 2401719 | 2022-04-12 | San Juan | Washington | 53055 | 1210 | 2 |
2398464 | 2398464 | 2022-04-11 | San Juan | Washington | 53055 | 1210 | 2 |
2395209 | 2395209 | 2022-04-10 | San Juan | Washington | 53055 | 1210 | 2 |
2391953 | 2391953 | 2022-04-09 | San Juan | Washington | 53055 | 1210 | 2 |
2388697 | 2388697 | 2022-04-08 | San Juan | Washington | 53055 | 1210 | 2 |
2385442 | 2385442 | 2022-04-07 | San Juan | Washington | 53055 | 1210 | 2 |
2382187 | 2382187 | 2022-04-06 | San Juan | Washington | 53055 | 1210 | 2 |
2358040 | 2358040 | 2022-03-30 | Jefferson | Nebraska | 31095 | 1210 | 6 |
2351534 | 2351534 | 2022-03-28 | Jefferson | Nebraska | 31095 | 1210 | 6 |
2348282 | 2348282 | 2022-03-27 | Jefferson | Nebraska | 31095 | 1210 | 6 |
2345029 | 2345029 | 2022-03-26 | Jefferson | Nebraska | 31095 | 1210 | 6 |
2341776 | 2341776 | 2022-03-25 | Jefferson | Nebraska | 31095 | 1210 | 6 |
2338523 | 2338523 | 2022-03-24 | Jefferson | Nebraska | 31095 | 1210 | 6 |
2302389 | 2302389 | 2022-03-13 | Lincoln | Minnesota | 27081 | 1210 | 6 |
2299137 | 2299137 | 2022-03-12 | Lincoln | Minnesota | 27081 | 1210 | 6 |
2295885 | 2295885 | 2022-03-11 | Lincoln | Minnesota | 27081 | 1210 | 6 |
2264954 | 2264954 | 2022-03-01 | Cumberland | Virginia | 51049 | 1210 | 23 |
2186662 | 2186662 | 2022-02-05 | Garza | Texas | 48169 | 1210 | 26 |
2180279 | 2180279 | 2022-02-03 | San Saba | Texas | 48411 | 1210 | 31 |
2174342 | 2174342 | 2022-02-02 | Lafayette | Arkansas | 5073 | 1210 | 28 |
2170476 | 2170476 | 2022-01-31 | McCulloch | Texas | 48307 | 1210 | 42 |
2159955 | 2159955 | 2022-01-28 | McHenry | North Dakota | 38049 | 1210 | 29 |
2157564 | 2157564 | 2022-01-27 | Kane | Utah | 49025 | 1210 | 13 |
2147642 | 2147642 | 2022-01-24 | Hartley | Texas | 48205 | 1210 | 3 |
2144388 | 2144388 | 2022-01-23 | Hartley | Texas | 48205 | 1210 | 3 |
2134246 | 2134246 | 2022-01-20 | Ceiba | Puerto Rico | 72037 | 1210 | |
2125599 | 2125599 | 2022-01-18 | Modoc | California | 6049 | 1210 | 11 |
2122347 | 2122347 | 2022-01-17 | Modoc | California | 6049 | 1210 | 11 |
2119095 | 2119095 | 2022-01-16 | Modoc | California | 6049 | 1210 | 11 |
2115843 | 2115843 | 2022-01-15 | Modoc | California | 6049 | 1210 | 11 |
2112592 | 2112592 | 2022-01-14 | Modoc | California | 6049 | 1210 | 11 |
2103235 | 2103235 | 2022-01-11 | Calhoun | Illinois | 17013 | 1210 | 7 |
2064070 | 2064070 | 2021-12-30 | Hancock | Georgia | 13141 | 1210 | 83 |
2064082 | 2064082 | 2021-12-30 | Jenkins | Georgia | 13165 | 1210 | 63 |
2062851 | 2062851 | 2021-12-29 | Hamlin | South Dakota | 46057 | 1210 | 40 |
2060216 | 2060216 | 2021-12-28 | Calhoun | West Virginia | 54013 | 1210 | 9 |
2030877 | 2030877 | 2021-12-19 | Northampton | Virginia | 51131 | 1210 | 48 |
2027626 | 2027626 | 2021-12-18 | Northampton | Virginia | 51131 | 1210 | 48 |
2024375 | 2024375 | 2021-12-17 | Northampton | Virginia | 51131 | 1210 | 48 |
2018734 | 2018734 | 2021-12-16 | Edwards | Illinois | 17047 | 1210 | 21 |
2013798 | 2013798 | 2021-12-14 | Kiowa | Oklahoma | 40075 | 1210 | 45 |
2008636 | 2008636 | 2021-12-13 | Lake | Colorado | 8065 | 1210 | 1 |
2010547 | 2010547 | 2021-12-13 | Kiowa | Oklahoma | 40075 | 1210 | 45 |
2007296 | 2007296 | 2021-12-12 | Kiowa | Oklahoma | 40075 | 1210 | 45 |
2004045 | 2004045 | 2021-12-11 | Kiowa | Oklahoma | 40075 | 1210 | 45 |
2000794 | 2000794 | 2021-12-10 | Kiowa | Oklahoma | 40075 | 1210 | 45 |
1995512 | 1995512 | 2021-12-09 | Monroe | Arkansas | 5095 | 1210 | 25 |
1997544 | 1997544 | 2021-12-09 | Kiowa | Oklahoma | 40075 | 1210 | 45 |
1994293 | 1994293 | 2021-12-08 | Kiowa | Oklahoma | 40075 | 1210 | 45 |
1972900 | 1972900 | 2021-12-02 | Rio Blanco | Colorado | 8103 | 1210 | 10 |
1967679 | 1967679 | 2021-11-30 | Ozark | Missouri | 29153 | 1210 | 42 |
1963331 | 1963331 | 2021-11-29 | Lincoln | Georgia | 13181 | 1210 | 33 |
1961941 | 1961941 | 2021-11-28 | Barceloneta | Puerto Rico | 72017 | 1210 | |
1950008 | 1950008 | 2021-11-25 | Newton | Arkansas | 5101 | 1210 | 39 |
1897797 | 1897797 | 2021-11-08 | Pepin | Wisconsin | 55091 | 1210 | 10 |
1891246 | 1891246 | 2021-11-06 | Webster | West Virginia | 54101 | 1210 | 18 |
1864142 | 1864142 | 2021-10-29 | Pembina | North Dakota | 38067 | 1210 | 12 |
1858167 | 1858167 | 2021-10-27 | Hancock | Tennessee | 47067 | 1210 | 20 |
1853385 | 1853385 | 2021-10-26 | Crittenden | Kentucky | 21055 | 1210 | 35 |
1854918 | 1854918 | 2021-10-26 | Hancock | Tennessee | 47067 | 1210 | 20 |
1830640 | 1830640 | 2021-10-19 | Cumberland | Kentucky | 21057 | 1210 | 19 |
1822780 | 1822780 | 2021-10-16 | Orange | Vermont | 50017 | 1210 | 5 |
1808065 | 1808065 | 2021-10-12 | Piscataquis | Maine | 23021 | 1210 | 10 |
1804814 | 1804814 | 2021-10-11 | Piscataquis | Maine | 23021 | 1210 | 10 |
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);