ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
681 rows where deaths = 325 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Illinois 62
- Texas 57
- North Carolina 52
- Alabama 31
- Michigan 31
- Tennessee 31
- South Carolina 29
- Louisiana 26
- Pennsylvania 26
- Arkansas 23
- Maine 23
- Maryland 23
- Florida 19
- Ohio 19
- Georgia 17
- Indiana 17
- Wisconsin 17
- Arizona 12
- Mississippi 12
- New York 12
- Kentucky 10
- Oregon 10
- Colorado 9
- Minnesota 9
- Washington 9
- Delaware 8
- New Hampshire 8
- California 7
- Nebraska 7
- New Mexico 7
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2491723 | 2491723 | 2022-05-10 | Burke | North Carolina | 37023 | 25244 | 325 |
2488465 | 2488465 | 2022-05-09 | Burke | North Carolina | 37023 | 25244 | 325 |
2485208 | 2485208 | 2022-05-08 | Burke | North Carolina | 37023 | 25244 | 325 |
2481950 | 2481950 | 2022-05-07 | Burke | North Carolina | 37023 | 25244 | 325 |
2478692 | 2478692 | 2022-05-06 | Burke | North Carolina | 37023 | 25244 | 325 |
2475434 | 2475434 | 2022-05-05 | Burke | North Carolina | 37023 | 25244 | 325 |
2472177 | 2472177 | 2022-05-04 | Burke | North Carolina | 37023 | 25244 | 325 |
2455174 | 2455174 | 2022-04-29 | Penobscot | Maine | 23019 | 28398 | 325 |
2451918 | 2451918 | 2022-04-28 | Penobscot | Maine | 23019 | 28358 | 325 |
2448662 | 2448662 | 2022-04-27 | Penobscot | Maine | 23019 | 28285 | 325 |
2445406 | 2445406 | 2022-04-26 | Penobscot | Maine | 23019 | 28220 | 325 |
2442150 | 2442150 | 2022-04-25 | Penobscot | Maine | 23019 | 28158 | 325 |
2438894 | 2438894 | 2022-04-24 | Penobscot | Maine | 23019 | 28158 | 325 |
2435638 | 2435638 | 2022-04-23 | Penobscot | Maine | 23019 | 28158 | 325 |
2432382 | 2432382 | 2022-04-22 | Penobscot | Maine | 23019 | 28123 | 325 |
2429126 | 2429126 | 2022-04-21 | Penobscot | Maine | 23019 | 28055 | 325 |
2425870 | 2425870 | 2022-04-20 | Penobscot | Maine | 23019 | 27997 | 325 |
2422614 | 2422614 | 2022-04-19 | Penobscot | Maine | 23019 | 27923 | 325 |
2419358 | 2419358 | 2022-04-18 | Penobscot | Maine | 23019 | 27923 | 325 |
2416102 | 2416102 | 2022-04-17 | Penobscot | Maine | 23019 | 27923 | 325 |
2412846 | 2412846 | 2022-04-16 | Penobscot | Maine | 23019 | 27923 | 325 |
2409590 | 2409590 | 2022-04-15 | Penobscot | Maine | 23019 | 27875 | 325 |
2406334 | 2406334 | 2022-04-14 | Penobscot | Maine | 23019 | 27796 | 325 |
2408166 | 2408166 | 2022-04-14 | Portsmouth city | Virginia | 51740 | 20871 | 325 |
2403078 | 2403078 | 2022-04-13 | Penobscot | Maine | 23019 | 27724 | 325 |
2399824 | 2399824 | 2022-04-12 | Penobscot | Maine | 23019 | 27627 | 325 |
2388985 | 2388985 | 2022-04-09 | Craighead | Arkansas | 5031 | 37594 | 325 |
2385730 | 2385730 | 2022-04-08 | Craighead | Arkansas | 5031 | 37593 | 325 |
2382475 | 2382475 | 2022-04-07 | Craighead | Arkansas | 5031 | 37592 | 325 |
2379220 | 2379220 | 2022-04-06 | Craighead | Arkansas | 5031 | 37585 | 325 |
2381345 | 2381345 | 2022-04-06 | Josephine | Oregon | 41033 | 16320 | 325 |
2375966 | 2375966 | 2022-04-05 | Craighead | Arkansas | 5031 | 37583 | 325 |
2378090 | 2378090 | 2022-04-05 | Josephine | Oregon | 41033 | 16318 | 325 |
2372714 | 2372714 | 2022-04-04 | Craighead | Arkansas | 5031 | 37580 | 325 |
2373253 | 2373253 | 2022-04-04 | McLean | Illinois | 17113 | 49626 | 325 |
2374836 | 2374836 | 2022-04-04 | Josephine | Oregon | 41033 | 16317 | 325 |
2369461 | 2369461 | 2022-04-03 | Craighead | Arkansas | 5031 | 37579 | 325 |
2370000 | 2370000 | 2022-04-03 | McLean | Illinois | 17113 | 49574 | 325 |
2371226 | 2371226 | 2022-04-03 | Saratoga | New York | 36091 | 46072 | 325 |
2366208 | 2366208 | 2022-04-02 | Craighead | Arkansas | 5031 | 37579 | 325 |
2366747 | 2366747 | 2022-04-02 | McLean | Illinois | 17113 | 49574 | 325 |
2367973 | 2367973 | 2022-04-02 | Saratoga | New York | 36091 | 46041 | 325 |
2362955 | 2362955 | 2022-04-01 | Craighead | Arkansas | 5031 | 37576 | 325 |
2363494 | 2363494 | 2022-04-01 | McLean | Illinois | 17113 | 49574 | 325 |
2364720 | 2364720 | 2022-04-01 | Saratoga | New York | 36091 | 46007 | 325 |
2359701 | 2359701 | 2022-03-31 | Craighead | Arkansas | 5031 | 37573 | 325 |
2360240 | 2360240 | 2022-03-31 | McLean | Illinois | 17113 | 49535 | 325 |
2360864 | 2360864 | 2022-03-31 | Lenawee | Michigan | 26091 | 25892 | 325 |
2361405 | 2361405 | 2022-03-31 | Lea | New Mexico | 35025 | 20121 | 325 |
2361466 | 2361466 | 2022-03-31 | Saratoga | New York | 36091 | 45959 | 325 |
2356447 | 2356447 | 2022-03-30 | Craighead | Arkansas | 5031 | 37556 | 325 |
2356986 | 2356986 | 2022-03-30 | McLean | Illinois | 17113 | 49507 | 325 |
2357610 | 2357610 | 2022-03-30 | Lenawee | Michigan | 26091 | 25892 | 325 |
2358212 | 2358212 | 2022-03-30 | Saratoga | New York | 36091 | 45929 | 325 |
2353194 | 2353194 | 2022-03-29 | Craighead | Arkansas | 5031 | 37553 | 325 |
2353733 | 2353733 | 2022-03-29 | McLean | Illinois | 17113 | 49477 | 325 |
2354295 | 2354295 | 2022-03-29 | Wicomico | Maryland | 24045 | 19621 | 325 |
2354958 | 2354958 | 2022-03-29 | Saratoga | New York | 36091 | 45898 | 325 |
2349840 | 2349840 | 2022-03-28 | DeKalb | Alabama | 1049 | 18737 | 325 |
2349942 | 2349942 | 2022-03-28 | Craighead | Arkansas | 5031 | 37536 | 325 |
2350481 | 2350481 | 2022-03-28 | McLean | Illinois | 17113 | 49451 | 325 |
2351043 | 2351043 | 2022-03-28 | Wicomico | Maryland | 24045 | 19618 | 325 |
2351705 | 2351705 | 2022-03-28 | Saratoga | New York | 36091 | 45873 | 325 |
2346689 | 2346689 | 2022-03-27 | Craighead | Arkansas | 5031 | 37534 | 325 |
2347228 | 2347228 | 2022-03-27 | McLean | Illinois | 17113 | 49410 | 325 |
2347790 | 2347790 | 2022-03-27 | Wicomico | Maryland | 24045 | 19616 | 325 |
2348023 | 2348023 | 2022-03-27 | Madison | Mississippi | 28089 | 23950 | 325 |
2348453 | 2348453 | 2022-03-27 | Saratoga | New York | 36091 | 45854 | 325 |
2343436 | 2343436 | 2022-03-26 | Craighead | Arkansas | 5031 | 37534 | 325 |
2343975 | 2343975 | 2022-03-26 | McLean | Illinois | 17113 | 49410 | 325 |
2344537 | 2344537 | 2022-03-26 | Wicomico | Maryland | 24045 | 19615 | 325 |
2344770 | 2344770 | 2022-03-26 | Madison | Mississippi | 28089 | 23950 | 325 |
2345200 | 2345200 | 2022-03-26 | Saratoga | New York | 36091 | 45829 | 325 |
2340183 | 2340183 | 2022-03-25 | Craighead | Arkansas | 5031 | 37523 | 325 |
2340722 | 2340722 | 2022-03-25 | McLean | Illinois | 17113 | 49410 | 325 |
2341284 | 2341284 | 2022-03-25 | Wicomico | Maryland | 24045 | 19611 | 325 |
2341517 | 2341517 | 2022-03-25 | Madison | Mississippi | 28089 | 23950 | 325 |
2336930 | 2336930 | 2022-03-24 | Craighead | Arkansas | 5031 | 37519 | 325 |
2337469 | 2337469 | 2022-03-24 | McLean | Illinois | 17113 | 49395 | 325 |
2338031 | 2338031 | 2022-03-24 | Wicomico | Maryland | 24045 | 19611 | 325 |
2338264 | 2338264 | 2022-03-24 | Madison | Mississippi | 28089 | 23950 | 325 |
2333676 | 2333676 | 2022-03-23 | Craighead | Arkansas | 5031 | 37467 | 325 |
2334215 | 2334215 | 2022-03-23 | McLean | Illinois | 17113 | 49380 | 325 |
2334777 | 2334777 | 2022-03-23 | Wicomico | Maryland | 24045 | 19606 | 325 |
2335010 | 2335010 | 2022-03-23 | Madison | Mississippi | 28089 | 23950 | 325 |
2335500 | 2335500 | 2022-03-23 | Harnett | North Carolina | 37085 | 32620 | 325 |
2330422 | 2330422 | 2022-03-22 | Craighead | Arkansas | 5031 | 37442 | 325 |
2330961 | 2330961 | 2022-03-22 | McLean | Illinois | 17113 | 49362 | 325 |
2331523 | 2331523 | 2022-03-22 | Wicomico | Maryland | 24045 | 19604 | 325 |
2331756 | 2331756 | 2022-03-22 | Madison | Mississippi | 28089 | 23950 | 325 |
2333468 | 2333468 | 2022-03-22 | Dodge | Wisconsin | 55027 | 27004 | 325 |
2327709 | 2327709 | 2022-03-21 | McLean | Illinois | 17113 | 49349 | 325 |
2328271 | 2328271 | 2022-03-21 | Wicomico | Maryland | 24045 | 19600 | 325 |
2328504 | 2328504 | 2022-03-21 | Madison | Mississippi | 28089 | 23950 | 325 |
2324456 | 2324456 | 2022-03-20 | McLean | Illinois | 17113 | 49308 | 325 |
2325018 | 2325018 | 2022-03-20 | Wicomico | Maryland | 24045 | 19599 | 325 |
2321202 | 2321202 | 2022-03-19 | McLean | Illinois | 17113 | 49308 | 325 |
2321764 | 2321764 | 2022-03-19 | Wicomico | Maryland | 24045 | 19593 | 325 |
2317948 | 2317948 | 2022-03-18 | McLean | Illinois | 17113 | 49308 | 325 |
2314202 | 2314202 | 2022-03-17 | Saline | Arkansas | 5125 | 30704 | 325 |
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);