ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
679 rows where deaths = 315 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Wisconsin 60
- Michigan 52
- Florida 45
- Pennsylvania 42
- Texas 38
- Georgia 37
- Ohio 35
- North Carolina 32
- Alabama 28
- Tennessee 28
- Virginia 28
- Arkansas 26
- California 24
- Iowa 20
- Indiana 19
- Oregon 17
- Massachusetts 15
- Illinois 13
- Louisiana 12
- Maine 10
- Missouri 9
- Arizona 8
- Maryland 8
- Mississippi 8
- Oklahoma 8
- Washington 8
- New York 7
- South Carolina 7
- Idaho 5
- New Hampshire 5
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499958 | 2499958 | 2022-05-13 | Suwannee | Florida | 12121 | 12972 | 315 |
2501010 | 2501010 | 2022-05-13 | Forrest | Mississippi | 28035 | 22076 | 315 |
2501094 | 2501094 | 2022-05-13 | Cass | Missouri | 29037 | 25249 | 315 |
2496700 | 2496700 | 2022-05-12 | Suwannee | Florida | 12121 | 12972 | 315 |
2497752 | 2497752 | 2022-05-12 | Forrest | Mississippi | 28035 | 22076 | 315 |
2497836 | 2497836 | 2022-05-12 | Cass | Missouri | 29037 | 25185 | 315 |
2493192 | 2493192 | 2022-05-11 | Faulkner | Arkansas | 5045 | 35218 | 315 |
2493442 | 2493442 | 2022-05-11 | Suwannee | Florida | 12121 | 12972 | 315 |
2494494 | 2494494 | 2022-05-11 | Forrest | Mississippi | 28035 | 22076 | 315 |
2494578 | 2494578 | 2022-05-11 | Cass | Missouri | 29037 | 25185 | 315 |
2489934 | 2489934 | 2022-05-10 | Faulkner | Arkansas | 5045 | 35208 | 315 |
2490184 | 2490184 | 2022-05-10 | Suwannee | Florida | 12121 | 12972 | 315 |
2491236 | 2491236 | 2022-05-10 | Forrest | Mississippi | 28035 | 22076 | 315 |
2491320 | 2491320 | 2022-05-10 | Cass | Missouri | 29037 | 25185 | 315 |
2486677 | 2486677 | 2022-05-09 | Faulkner | Arkansas | 5045 | 35190 | 315 |
2486787 | 2486787 | 2022-05-09 | Yolo | California | 6113 | 40736 | 315 |
2486927 | 2486927 | 2022-05-09 | Suwannee | Florida | 12121 | 12972 | 315 |
2487979 | 2487979 | 2022-05-09 | Forrest | Mississippi | 28035 | 22076 | 315 |
2488062 | 2488062 | 2022-05-09 | Cass | Missouri | 29037 | 25185 | 315 |
2483419 | 2483419 | 2022-05-08 | Faulkner | Arkansas | 5045 | 35188 | 315 |
2483529 | 2483529 | 2022-05-08 | Yolo | California | 6113 | 40736 | 315 |
2483669 | 2483669 | 2022-05-08 | Suwannee | Florida | 12121 | 12972 | 315 |
2484805 | 2484805 | 2022-05-08 | Cass | Missouri | 29037 | 25185 | 315 |
2480161 | 2480161 | 2022-05-07 | Faulkner | Arkansas | 5045 | 35187 | 315 |
2480271 | 2480271 | 2022-05-07 | Yolo | California | 6113 | 40736 | 315 |
2480411 | 2480411 | 2022-05-07 | Suwannee | Florida | 12121 | 12972 | 315 |
2481547 | 2481547 | 2022-05-07 | Cass | Missouri | 29037 | 25185 | 315 |
2476903 | 2476903 | 2022-05-06 | Faulkner | Arkansas | 5045 | 35173 | 315 |
2477013 | 2477013 | 2022-05-06 | Yolo | California | 6113 | 40736 | 315 |
2477153 | 2477153 | 2022-05-06 | Suwannee | Florida | 12121 | 12972 | 315 |
2478289 | 2478289 | 2022-05-06 | Cass | Missouri | 29037 | 25185 | 315 |
2473645 | 2473645 | 2022-05-05 | Faulkner | Arkansas | 5045 | 35169 | 315 |
2473755 | 2473755 | 2022-05-05 | Yolo | California | 6113 | 40596 | 315 |
2473895 | 2473895 | 2022-05-05 | Suwannee | Florida | 12121 | 12949 | 315 |
2475031 | 2475031 | 2022-05-05 | Cass | Missouri | 29037 | 25103 | 315 |
2470388 | 2470388 | 2022-05-04 | Faulkner | Arkansas | 5045 | 35160 | 315 |
2470498 | 2470498 | 2022-05-04 | Yolo | California | 6113 | 40596 | 315 |
2470638 | 2470638 | 2022-05-04 | Suwannee | Florida | 12121 | 12949 | 315 |
2467132 | 2467132 | 2022-05-03 | Faulkner | Arkansas | 5045 | 35148 | 315 |
2467242 | 2467242 | 2022-05-03 | Yolo | California | 6113 | 40596 | 315 |
2467382 | 2467382 | 2022-05-03 | Suwannee | Florida | 12121 | 12949 | 315 |
2463877 | 2463877 | 2022-05-02 | Faulkner | Arkansas | 5045 | 35141 | 315 |
2464127 | 2464127 | 2022-05-02 | Suwannee | Florida | 12121 | 12949 | 315 |
2460621 | 2460621 | 2022-05-01 | Faulkner | Arkansas | 5045 | 35140 | 315 |
2460871 | 2460871 | 2022-05-01 | Suwannee | Florida | 12121 | 12949 | 315 |
2457365 | 2457365 | 2022-04-30 | Faulkner | Arkansas | 5045 | 35138 | 315 |
2457615 | 2457615 | 2022-04-30 | Suwannee | Florida | 12121 | 12949 | 315 |
2454109 | 2454109 | 2022-04-29 | Faulkner | Arkansas | 5045 | 35127 | 315 |
2454359 | 2454359 | 2022-04-29 | Suwannee | Florida | 12121 | 12949 | 315 |
2450853 | 2450853 | 2022-04-28 | Faulkner | Arkansas | 5045 | 35118 | 315 |
2451103 | 2451103 | 2022-04-28 | Suwannee | Florida | 12121 | 12949 | 315 |
2447597 | 2447597 | 2022-04-27 | Faulkner | Arkansas | 5045 | 35109 | 315 |
2447847 | 2447847 | 2022-04-27 | Suwannee | Florida | 12121 | 12949 | 315 |
2444341 | 2444341 | 2022-04-26 | Faulkner | Arkansas | 5045 | 35107 | 315 |
2441085 | 2441085 | 2022-04-25 | Faulkner | Arkansas | 5045 | 35092 | 315 |
2437829 | 2437829 | 2022-04-24 | Faulkner | Arkansas | 5045 | 35091 | 315 |
2434573 | 2434573 | 2022-04-23 | Faulkner | Arkansas | 5045 | 35090 | 315 |
2431317 | 2431317 | 2022-04-22 | Faulkner | Arkansas | 5045 | 35088 | 315 |
2428061 | 2428061 | 2022-04-21 | Faulkner | Arkansas | 5045 | 35082 | 315 |
2424805 | 2424805 | 2022-04-20 | Faulkner | Arkansas | 5045 | 35072 | 315 |
2422291 | 2422291 | 2022-04-19 | Pottawattamie | Iowa | 19155 | 24276 | 315 |
2419035 | 2419035 | 2022-04-18 | Pottawattamie | Iowa | 19155 | 24276 | 315 |
2415779 | 2415779 | 2022-04-17 | Pottawattamie | Iowa | 19155 | 24276 | 315 |
2412523 | 2412523 | 2022-04-16 | Pottawattamie | Iowa | 19155 | 24276 | 315 |
2409267 | 2409267 | 2022-04-15 | Pottawattamie | Iowa | 19155 | 24276 | 315 |
2406011 | 2406011 | 2022-04-14 | Pottawattamie | Iowa | 19155 | 24276 | 315 |
2407427 | 2407427 | 2022-04-14 | Crawford | Pennsylvania | 42039 | 19788 | 315 |
2402755 | 2402755 | 2022-04-13 | Pottawattamie | Iowa | 19155 | 24276 | 315 |
2404171 | 2404171 | 2022-04-13 | Crawford | Pennsylvania | 42039 | 19780 | 315 |
2399501 | 2399501 | 2022-04-12 | Pottawattamie | Iowa | 19155 | 24261 | 315 |
2400916 | 2400916 | 2022-04-12 | Crawford | Pennsylvania | 42039 | 19776 | 315 |
2401844 | 2401844 | 2022-04-12 | Sheboygan | Wisconsin | 55117 | 32490 | 315 |
2396245 | 2396245 | 2022-04-11 | Pottawattamie | Iowa | 19155 | 24261 | 315 |
2397661 | 2397661 | 2022-04-11 | Crawford | Pennsylvania | 42039 | 19769 | 315 |
2392990 | 2392990 | 2022-04-10 | Pottawattamie | Iowa | 19155 | 24261 | 315 |
2394406 | 2394406 | 2022-04-10 | Crawford | Pennsylvania | 42039 | 19766 | 315 |
2389734 | 2389734 | 2022-04-09 | Pottawattamie | Iowa | 19155 | 24261 | 315 |
2391150 | 2391150 | 2022-04-09 | Crawford | Pennsylvania | 42039 | 19765 | 315 |
2386478 | 2386478 | 2022-04-08 | Pottawattamie | Iowa | 19155 | 24261 | 315 |
2387894 | 2387894 | 2022-04-08 | Crawford | Pennsylvania | 42039 | 19763 | 315 |
2383224 | 2383224 | 2022-04-07 | Pottawattamie | Iowa | 19155 | 24261 | 315 |
2384639 | 2384639 | 2022-04-07 | Crawford | Pennsylvania | 42039 | 19761 | 315 |
2379969 | 2379969 | 2022-04-06 | Pottawattamie | Iowa | 19155 | 24261 | 315 |
2373100 | 2373100 | 2022-04-04 | Rockdale | Georgia | 13247 | 18447 | 315 |
2369847 | 2369847 | 2022-04-03 | Rockdale | Georgia | 13247 | 18444 | 315 |
2366594 | 2366594 | 2022-04-02 | Rockdale | Georgia | 13247 | 18444 | 315 |
2363341 | 2363341 | 2022-04-01 | Rockdale | Georgia | 13247 | 18444 | 315 |
2360087 | 2360087 | 2022-03-31 | Rockdale | Georgia | 13247 | 18443 | 315 |
2355688 | 2355688 | 2022-03-29 | Unknown | Tennessee | 19425 | 315 | |
2348482 | 2348482 | 2022-03-27 | Burke | North Carolina | 37023 | 24991 | 315 |
2345229 | 2345229 | 2022-03-26 | Burke | North Carolina | 37023 | 24991 | 315 |
2341976 | 2341976 | 2022-03-25 | Burke | North Carolina | 37023 | 24991 | 315 |
2317057 | 2317057 | 2022-03-17 | Portsmouth city | Virginia | 51740 | 20662 | 315 |
2313026 | 2313026 | 2022-03-16 | Josephine | Oregon | 41033 | 16221 | 315 |
2313804 | 2313804 | 2022-03-16 | Portsmouth city | Virginia | 51740 | 20662 | 315 |
2308720 | 2308720 | 2022-03-15 | Penobscot | Maine | 23019 | 26921 | 315 |
2309773 | 2309773 | 2022-03-15 | Josephine | Oregon | 41033 | 16210 | 315 |
2310510 | 2310510 | 2022-03-15 | Hampton city | Virginia | 51650 | 27456 | 315 |
2310551 | 2310551 | 2022-03-15 | Portsmouth city | Virginia | 51740 | 20662 | 315 |
2305469 | 2305469 | 2022-03-14 | Penobscot | Maine | 23019 | 26879 | 315 |
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);