ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
737 rows where deaths = 338 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Indiana 66
- Texas 66
- North Carolina 51
- Wisconsin 51
- Georgia 48
- Pennsylvania 42
- Missouri 37
- Illinois 30
- Ohio 30
- Tennessee 27
- South Carolina 24
- Washington 21
- Iowa 20
- Michigan 20
- Alabama 19
- Maryland 19
- West Virginia 16
- California 15
- Florida 13
- Colorado 11
- New Jersey 11
- Kentucky 10
- Oklahoma 10
- Oregon 9
- South Dakota 8
- Arizona 7
- Arkansas 7
- Louisiana 7
- Minnesota 6
- Virginia 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501517 | 2501517 | 2022-05-13 | Durham | North Carolina | 37063 | 76734 | 338 |
2501751 | 2501751 | 2022-05-13 | Creek | Oklahoma | 40037 | 18245 | 338 |
2502606 | 2502606 | 2022-05-13 | Portsmouth city | Virginia | 51740 | 21144 | 338 |
2498259 | 2498259 | 2022-05-12 | Durham | North Carolina | 37063 | 76725 | 338 |
2498493 | 2498493 | 2022-05-12 | Creek | Oklahoma | 40037 | 18245 | 338 |
2499348 | 2499348 | 2022-05-12 | Portsmouth city | Virginia | 51740 | 21131 | 338 |
2495001 | 2495001 | 2022-05-11 | Durham | North Carolina | 37063 | 76510 | 338 |
2496090 | 2496090 | 2022-05-11 | Portsmouth city | Virginia | 51740 | 21115 | 338 |
2488795 | 2488795 | 2022-05-09 | Josephine | Oregon | 41033 | 16575 | 338 |
2485118 | 2485118 | 2022-05-08 | Lea | New Mexico | 35025 | 20166 | 338 |
2486371 | 2486371 | 2022-05-08 | Kitsap | Washington | 53035 | 40671 | 338 |
2481860 | 2481860 | 2022-05-07 | Lea | New Mexico | 35025 | 20166 | 338 |
2483113 | 2483113 | 2022-05-07 | Kitsap | Washington | 53035 | 40671 | 338 |
2476942 | 2476942 | 2022-05-06 | Saline | Arkansas | 5125 | 30964 | 338 |
2478602 | 2478602 | 2022-05-06 | Lea | New Mexico | 35025 | 20166 | 338 |
2479855 | 2479855 | 2022-05-06 | Kitsap | Washington | 53035 | 40671 | 338 |
2473684 | 2473684 | 2022-05-05 | Saline | Arkansas | 5125 | 30954 | 338 |
2476597 | 2476597 | 2022-05-05 | Kitsap | Washington | 53035 | 40671 | 338 |
2470427 | 2470427 | 2022-05-04 | Saline | Arkansas | 5125 | 30938 | 338 |
2471791 | 2471791 | 2022-05-04 | Franklin | Missouri | 29071 | 22675 | 338 |
2473339 | 2473339 | 2022-05-04 | Kitsap | Washington | 53035 | 40671 | 338 |
2467171 | 2467171 | 2022-05-03 | Saline | Arkansas | 5125 | 30928 | 338 |
2468535 | 2468535 | 2022-05-03 | Franklin | Missouri | 29071 | 22675 | 338 |
2470083 | 2470083 | 2022-05-03 | Kitsap | Washington | 53035 | 41003 | 338 |
2463916 | 2463916 | 2022-05-02 | Saline | Arkansas | 5125 | 30921 | 338 |
2465279 | 2465279 | 2022-05-02 | Franklin | Missouri | 29071 | 22675 | 338 |
2466827 | 2466827 | 2022-05-02 | Kitsap | Washington | 53035 | 41003 | 338 |
2462024 | 2462024 | 2022-05-01 | Franklin | Missouri | 29071 | 22675 | 338 |
2463572 | 2463572 | 2022-05-01 | Kitsap | Washington | 53035 | 40344 | 338 |
2458768 | 2458768 | 2022-04-30 | Franklin | Missouri | 29071 | 22675 | 338 |
2460316 | 2460316 | 2022-04-30 | Kitsap | Washington | 53035 | 40344 | 338 |
2455512 | 2455512 | 2022-04-29 | Franklin | Missouri | 29071 | 22675 | 338 |
2457060 | 2457060 | 2022-04-29 | Kitsap | Washington | 53035 | 40344 | 338 |
2452256 | 2452256 | 2022-04-28 | Franklin | Missouri | 29071 | 22675 | 338 |
2453804 | 2453804 | 2022-04-28 | Kitsap | Washington | 53035 | 40204 | 338 |
2449000 | 2449000 | 2022-04-27 | Franklin | Missouri | 29071 | 22675 | 338 |
2449924 | 2449924 | 2022-04-27 | Oconee | South Carolina | 45073 | 24197 | 338 |
2450548 | 2450548 | 2022-04-27 | Kitsap | Washington | 53035 | 40204 | 338 |
2444248 | 2444248 | 2022-04-26 | Lee | Alabama | 1081 | 37746 | 338 |
2445743 | 2445743 | 2022-04-26 | Franklin | Missouri | 29071 | 22675 | 338 |
2446667 | 2446667 | 2022-04-26 | Oconee | South Carolina | 45073 | 24197 | 338 |
2440992 | 2440992 | 2022-04-25 | Lee | Alabama | 1081 | 37742 | 338 |
2442488 | 2442488 | 2022-04-25 | Franklin | Missouri | 29071 | 22675 | 338 |
2443412 | 2443412 | 2022-04-25 | Oconee | South Carolina | 45073 | 24197 | 338 |
2437736 | 2437736 | 2022-04-24 | Lee | Alabama | 1081 | 37700 | 338 |
2439232 | 2439232 | 2022-04-24 | Franklin | Missouri | 29071 | 22675 | 338 |
2440156 | 2440156 | 2022-04-24 | Oconee | South Carolina | 45073 | 24197 | 338 |
2434480 | 2434480 | 2022-04-23 | Lee | Alabama | 1081 | 37700 | 338 |
2435976 | 2435976 | 2022-04-23 | Franklin | Missouri | 29071 | 22675 | 338 |
2436900 | 2436900 | 2022-04-23 | Oconee | South Carolina | 45073 | 24197 | 338 |
2431224 | 2431224 | 2022-04-22 | Lee | Alabama | 1081 | 37700 | 338 |
2432720 | 2432720 | 2022-04-22 | Franklin | Missouri | 29071 | 22675 | 338 |
2433644 | 2433644 | 2022-04-22 | Oconee | South Carolina | 45073 | 24197 | 338 |
2427968 | 2427968 | 2022-04-21 | Lee | Alabama | 1081 | 37697 | 338 |
2429464 | 2429464 | 2022-04-21 | Franklin | Missouri | 29071 | 22675 | 338 |
2430388 | 2430388 | 2022-04-21 | Oconee | South Carolina | 45073 | 24197 | 338 |
2431012 | 2431012 | 2022-04-21 | Kitsap | Washington | 53035 | 39722 | 338 |
2424712 | 2424712 | 2022-04-20 | Lee | Alabama | 1081 | 37692 | 338 |
2426208 | 2426208 | 2022-04-20 | Franklin | Missouri | 29071 | 22675 | 338 |
2427132 | 2427132 | 2022-04-20 | Oconee | South Carolina | 45073 | 24197 | 338 |
2427756 | 2427756 | 2022-04-20 | Kitsap | Washington | 53035 | 39722 | 338 |
2421456 | 2421456 | 2022-04-19 | Lee | Alabama | 1081 | 37684 | 338 |
2422952 | 2422952 | 2022-04-19 | Franklin | Missouri | 29071 | 22675 | 338 |
2423876 | 2423876 | 2022-04-19 | Oconee | South Carolina | 45073 | 24197 | 338 |
2418200 | 2418200 | 2022-04-18 | Lee | Alabama | 1081 | 37673 | 338 |
2419695 | 2419695 | 2022-04-18 | Franklin | Missouri | 29071 | 22675 | 338 |
2420620 | 2420620 | 2022-04-18 | Oconee | South Carolina | 45073 | 24170 | 338 |
2414944 | 2414944 | 2022-04-17 | Lee | Alabama | 1081 | 37673 | 338 |
2416440 | 2416440 | 2022-04-17 | Franklin | Missouri | 29071 | 22675 | 338 |
2417364 | 2417364 | 2022-04-17 | Oconee | South Carolina | 45073 | 24170 | 338 |
2411688 | 2411688 | 2022-04-16 | Lee | Alabama | 1081 | 37673 | 338 |
2413184 | 2413184 | 2022-04-16 | Franklin | Missouri | 29071 | 22675 | 338 |
2414108 | 2414108 | 2022-04-16 | Oconee | South Carolina | 45073 | 24170 | 338 |
2408432 | 2408432 | 2022-04-15 | Lee | Alabama | 1081 | 37673 | 338 |
2409928 | 2409928 | 2022-04-15 | Franklin | Missouri | 29071 | 22675 | 338 |
2410852 | 2410852 | 2022-04-15 | Oconee | South Carolina | 45073 | 24170 | 338 |
2406672 | 2406672 | 2022-04-14 | Franklin | Missouri | 29071 | 22675 | 338 |
2407596 | 2407596 | 2022-04-14 | Oconee | South Carolina | 45073 | 24170 | 338 |
2403416 | 2403416 | 2022-04-13 | Franklin | Missouri | 29071 | 22675 | 338 |
2404340 | 2404340 | 2022-04-13 | Oconee | South Carolina | 45073 | 24170 | 338 |
2405054 | 2405054 | 2022-04-13 | Dodge | Wisconsin | 55027 | 27207 | 338 |
2400161 | 2400161 | 2022-04-12 | Franklin | Missouri | 29071 | 22675 | 338 |
2401085 | 2401085 | 2022-04-12 | Oconee | South Carolina | 45073 | 24170 | 338 |
2401799 | 2401799 | 2022-04-12 | Dodge | Wisconsin | 55027 | 27202 | 338 |
2396906 | 2396906 | 2022-04-11 | Franklin | Missouri | 29071 | 22675 | 338 |
2398516 | 2398516 | 2022-04-11 | Raleigh | West Virginia | 54081 | 22690 | 338 |
2398544 | 2398544 | 2022-04-11 | Dodge | Wisconsin | 55027 | 27198 | 338 |
2393651 | 2393651 | 2022-04-10 | Franklin | Missouri | 29071 | 22675 | 338 |
2395261 | 2395261 | 2022-04-10 | Raleigh | West Virginia | 54081 | 22686 | 338 |
2395289 | 2395289 | 2022-04-10 | Dodge | Wisconsin | 55027 | 27189 | 338 |
2390395 | 2390395 | 2022-04-09 | Franklin | Missouri | 29071 | 22675 | 338 |
2392005 | 2392005 | 2022-04-09 | Raleigh | West Virginia | 54081 | 22686 | 338 |
2392033 | 2392033 | 2022-04-09 | Dodge | Wisconsin | 55027 | 27189 | 338 |
2387139 | 2387139 | 2022-04-08 | Franklin | Missouri | 29071 | 22675 | 338 |
2388749 | 2388749 | 2022-04-08 | Raleigh | West Virginia | 54081 | 22686 | 338 |
2388777 | 2388777 | 2022-04-08 | Dodge | Wisconsin | 55027 | 27189 | 338 |
2383884 | 2383884 | 2022-04-07 | Franklin | Missouri | 29071 | 22675 | 338 |
2385494 | 2385494 | 2022-04-07 | Raleigh | West Virginia | 54081 | 22685 | 338 |
2385522 | 2385522 | 2022-04-07 | Dodge | Wisconsin | 55027 | 27175 | 338 |
2380629 | 2380629 | 2022-04-06 | Franklin | Missouri | 29071 | 22675 | 338 |
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);