ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where deaths = 293 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Ohio 74
- North Carolina 66
- Florida 45
- Texas 41
- Louisiana 40
- South Carolina 39
- Oklahoma 37
- Pennsylvania 35
- Georgia 34
- California 29
- Virginia 29
- Illinois 27
- Alabama 26
- Arizona 26
- Washington 26
- Michigan 23
- Iowa 19
- Kentucky 16
- Arkansas 12
- Mississippi 12
- Wisconsin 12
- Indiana 10
- Kansas 10
- New York 10
- West Virginia 9
- Idaho 8
- Maryland 7
- Oregon 7
- Connecticut 6
- Delaware 6
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499616 | 2499616 | 2022-05-13 | Limestone | Alabama | 1083 | 25065 | 293 |
2499782 | 2499782 | 2022-05-13 | Marin | California | 6041 | 38685 | 293 |
2500678 | 2500678 | 2022-05-13 | Pulaski | Kentucky | 21199 | 18157 | 293 |
2500701 | 2500701 | 2022-05-13 | Ascension | Louisiana | 22005 | 35030 | 293 |
2501564 | 2501564 | 2022-05-13 | Rockingham | North Carolina | 37157 | 22198 | 293 |
2497420 | 2497420 | 2022-05-12 | Pulaski | Kentucky | 21199 | 18157 | 293 |
2497443 | 2497443 | 2022-05-12 | Ascension | Louisiana | 22005 | 35010 | 293 |
2498306 | 2498306 | 2022-05-12 | Rockingham | North Carolina | 37157 | 22198 | 293 |
2494162 | 2494162 | 2022-05-11 | Pulaski | Kentucky | 21199 | 18157 | 293 |
2494185 | 2494185 | 2022-05-11 | Ascension | Louisiana | 22005 | 34994 | 293 |
2495048 | 2495048 | 2022-05-11 | Rockingham | North Carolina | 37157 | 22198 | 293 |
2490168 | 2490168 | 2022-05-10 | Nassau | Florida | 12089 | 21949 | 293 |
2490904 | 2490904 | 2022-05-10 | Pulaski | Kentucky | 21199 | 18157 | 293 |
2490927 | 2490927 | 2022-05-10 | Ascension | Louisiana | 22005 | 34976 | 293 |
2486911 | 2486911 | 2022-05-09 | Nassau | Florida | 12089 | 21949 | 293 |
2487647 | 2487647 | 2022-05-09 | Pulaski | Kentucky | 21199 | 18157 | 293 |
2487670 | 2487670 | 2022-05-09 | Ascension | Louisiana | 22005 | 34963 | 293 |
2483653 | 2483653 | 2022-05-08 | Nassau | Florida | 12089 | 21949 | 293 |
2484412 | 2484412 | 2022-05-08 | Ascension | Louisiana | 22005 | 34940 | 293 |
2486395 | 2486395 | 2022-05-08 | Berkeley | West Virginia | 54003 | 36036 | 293 |
2480395 | 2480395 | 2022-05-07 | Nassau | Florida | 12089 | 21949 | 293 |
2481154 | 2481154 | 2022-05-07 | Ascension | Louisiana | 22005 | 34940 | 293 |
2483137 | 2483137 | 2022-05-07 | Berkeley | West Virginia | 54003 | 36036 | 293 |
2477137 | 2477137 | 2022-05-06 | Nassau | Florida | 12089 | 21949 | 293 |
2477896 | 2477896 | 2022-05-06 | Ascension | Louisiana | 22005 | 34940 | 293 |
2479879 | 2479879 | 2022-05-06 | Berkeley | West Virginia | 54003 | 36036 | 293 |
2473879 | 2473879 | 2022-05-05 | Nassau | Florida | 12089 | 21811 | 293 |
2474638 | 2474638 | 2022-05-05 | Ascension | Louisiana | 22005 | 34934 | 293 |
2470622 | 2470622 | 2022-05-04 | Nassau | Florida | 12089 | 21811 | 293 |
2471381 | 2471381 | 2022-05-04 | Ascension | Louisiana | 22005 | 34916 | 293 |
2472383 | 2472383 | 2022-05-04 | Muskingum | Ohio | 39119 | 25360 | 293 |
2467366 | 2467366 | 2022-05-03 | Nassau | Florida | 12089 | 21811 | 293 |
2468125 | 2468125 | 2022-05-03 | Ascension | Louisiana | 22005 | 34907 | 293 |
2469127 | 2469127 | 2022-05-03 | Muskingum | Ohio | 39119 | 25360 | 293 |
2464111 | 2464111 | 2022-05-02 | Nassau | Florida | 12089 | 21811 | 293 |
2464870 | 2464870 | 2022-05-02 | Ascension | Louisiana | 22005 | 34884 | 293 |
2465871 | 2465871 | 2022-05-02 | Muskingum | Ohio | 39119 | 25360 | 293 |
2460855 | 2460855 | 2022-05-01 | Nassau | Florida | 12089 | 21811 | 293 |
2461614 | 2461614 | 2022-05-01 | Ascension | Louisiana | 22005 | 34877 | 293 |
2461939 | 2461939 | 2022-05-01 | Jones | Mississippi | 28067 | 21206 | 293 |
2462616 | 2462616 | 2022-05-01 | Muskingum | Ohio | 39119 | 25360 | 293 |
2457599 | 2457599 | 2022-04-30 | Nassau | Florida | 12089 | 21811 | 293 |
2458358 | 2458358 | 2022-04-30 | Ascension | Louisiana | 22005 | 34877 | 293 |
2458683 | 2458683 | 2022-04-30 | Jones | Mississippi | 28067 | 21206 | 293 |
2459360 | 2459360 | 2022-04-30 | Muskingum | Ohio | 39119 | 25360 | 293 |
2454343 | 2454343 | 2022-04-29 | Nassau | Florida | 12089 | 21811 | 293 |
2455102 | 2455102 | 2022-04-29 | Ascension | Louisiana | 22005 | 34877 | 293 |
2455427 | 2455427 | 2022-04-29 | Jones | Mississippi | 28067 | 21206 | 293 |
2456104 | 2456104 | 2022-04-29 | Muskingum | Ohio | 39119 | 25360 | 293 |
2451087 | 2451087 | 2022-04-28 | Nassau | Florida | 12089 | 21811 | 293 |
2451844 | 2451844 | 2022-04-28 | Acadia | Louisiana | 22001 | 15889 | 293 |
2451846 | 2451846 | 2022-04-28 | Ascension | Louisiana | 22005 | 34873 | 293 |
2452171 | 2452171 | 2022-04-28 | Jones | Mississippi | 28067 | 21206 | 293 |
2452848 | 2452848 | 2022-04-28 | Muskingum | Ohio | 39119 | 25360 | 293 |
2447831 | 2447831 | 2022-04-27 | Nassau | Florida | 12089 | 21811 | 293 |
2448590 | 2448590 | 2022-04-27 | Ascension | Louisiana | 22005 | 34856 | 293 |
2448915 | 2448915 | 2022-04-27 | Jones | Mississippi | 28067 | 21206 | 293 |
2449592 | 2449592 | 2022-04-27 | Muskingum | Ohio | 39119 | 25329 | 293 |
2444575 | 2444575 | 2022-04-26 | Nassau | Florida | 12089 | 21811 | 293 |
2445334 | 2445334 | 2022-04-26 | Ascension | Louisiana | 22005 | 34853 | 293 |
2445659 | 2445659 | 2022-04-26 | Jones | Mississippi | 28067 | 21206 | 293 |
2446335 | 2446335 | 2022-04-26 | Muskingum | Ohio | 39119 | 25329 | 293 |
2441319 | 2441319 | 2022-04-25 | Nassau | Florida | 12089 | 21811 | 293 |
2442078 | 2442078 | 2022-04-25 | Ascension | Louisiana | 22005 | 34849 | 293 |
2443080 | 2443080 | 2022-04-25 | Muskingum | Ohio | 39119 | 25329 | 293 |
2438063 | 2438063 | 2022-04-24 | Nassau | Florida | 12089 | 21811 | 293 |
2438822 | 2438822 | 2022-04-24 | Ascension | Louisiana | 22005 | 34848 | 293 |
2439824 | 2439824 | 2022-04-24 | Muskingum | Ohio | 39119 | 25329 | 293 |
2439980 | 2439980 | 2022-04-24 | Carbon | Pennsylvania | 42025 | 15967 | 293 |
2434807 | 2434807 | 2022-04-23 | Nassau | Florida | 12089 | 21811 | 293 |
2435566 | 2435566 | 2022-04-23 | Ascension | Louisiana | 22005 | 34848 | 293 |
2436568 | 2436568 | 2022-04-23 | Muskingum | Ohio | 39119 | 25329 | 293 |
2436724 | 2436724 | 2022-04-23 | Carbon | Pennsylvania | 42025 | 15962 | 293 |
2431551 | 2431551 | 2022-04-22 | Nassau | Florida | 12089 | 21811 | 293 |
2432310 | 2432310 | 2022-04-22 | Ascension | Louisiana | 22005 | 34848 | 293 |
2433312 | 2433312 | 2022-04-22 | Muskingum | Ohio | 39119 | 25329 | 293 |
2428295 | 2428295 | 2022-04-21 | Nassau | Florida | 12089 | 21722 | 293 |
2429054 | 2429054 | 2022-04-21 | Ascension | Louisiana | 22005 | 34843 | 293 |
2430056 | 2430056 | 2022-04-21 | Muskingum | Ohio | 39119 | 25329 | 293 |
2425039 | 2425039 | 2022-04-20 | Nassau | Florida | 12089 | 21722 | 293 |
2426800 | 2426800 | 2022-04-20 | Muskingum | Ohio | 39119 | 25294 | 293 |
2421783 | 2421783 | 2022-04-19 | Nassau | Florida | 12089 | 21722 | 293 |
2423371 | 2423371 | 2022-04-19 | Henderson | North Carolina | 37089 | 24924 | 293 |
2423544 | 2423544 | 2022-04-19 | Muskingum | Ohio | 39119 | 25294 | 293 |
2423700 | 2423700 | 2022-04-19 | Carbon | Pennsylvania | 42025 | 15935 | 293 |
2424519 | 2424519 | 2022-04-19 | Whatcom | Washington | 53073 | 37741 | 293 |
2418527 | 2418527 | 2022-04-18 | Nassau | Florida | 12089 | 21722 | 293 |
2420114 | 2420114 | 2022-04-18 | Henderson | North Carolina | 37089 | 24924 | 293 |
2420287 | 2420287 | 2022-04-18 | Muskingum | Ohio | 39119 | 25294 | 293 |
2420444 | 2420444 | 2022-04-18 | Carbon | Pennsylvania | 42025 | 15929 | 293 |
2421263 | 2421263 | 2022-04-18 | Whatcom | Washington | 53073 | 37741 | 293 |
2415271 | 2415271 | 2022-04-17 | Nassau | Florida | 12089 | 21722 | 293 |
2416859 | 2416859 | 2022-04-17 | Henderson | North Carolina | 37089 | 24924 | 293 |
2417032 | 2417032 | 2022-04-17 | Muskingum | Ohio | 39119 | 25294 | 293 |
2417188 | 2417188 | 2022-04-17 | Carbon | Pennsylvania | 42025 | 15925 | 293 |
2418007 | 2418007 | 2022-04-17 | Whatcom | Washington | 53073 | 37658 | 293 |
2412015 | 2412015 | 2022-04-16 | Nassau | Florida | 12089 | 21722 | 293 |
2413603 | 2413603 | 2022-04-16 | Henderson | North Carolina | 37089 | 24924 | 293 |
2413776 | 2413776 | 2022-04-16 | Muskingum | Ohio | 39119 | 25294 | 293 |
2413932 | 2413932 | 2022-04-16 | Carbon | Pennsylvania | 42025 | 15921 | 293 |
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);