ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,551 rows where deaths = 189 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 187
- Ohio 96
- Georgia 95
- Pennsylvania 84
- Virginia 75
- Tennessee 69
- South Carolina 64
- Michigan 57
- Mississippi 57
- New York 57
- North Carolina 51
- Indiana 41
- Illinois 38
- Alabama 35
- California 34
- Missouri 33
- Kentucky 32
- Connecticut 31
- Louisiana 31
- New Jersey 31
- Florida 30
- Oklahoma 29
- Wisconsin 29
- New Mexico 24
- West Virginia 24
- Arkansas 23
- Washington 21
- Kansas 16
- Montana 15
- North Dakota 15
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501049 | 2501049 | 2022-05-13 | Pike | Mississippi | 28113 | 9751 | 189 |
2501397 | 2501397 | 2022-05-13 | Cibola | New Mexico | 35006 | 8048 | 189 |
2501649 | 2501649 | 2022-05-13 | Auglaize | Ohio | 39011 | 11642 | 189 |
2502773 | 2502773 | 2022-05-13 | Manitowoc | Wisconsin | 55071 | 20803 | 189 |
2497791 | 2497791 | 2022-05-12 | Pike | Mississippi | 28113 | 9751 | 189 |
2498139 | 2498139 | 2022-05-12 | Cibola | New Mexico | 35006 | 8044 | 189 |
2498391 | 2498391 | 2022-05-12 | Auglaize | Ohio | 39011 | 11642 | 189 |
2499515 | 2499515 | 2022-05-12 | Manitowoc | Wisconsin | 55071 | 20776 | 189 |
2494533 | 2494533 | 2022-05-11 | Pike | Mississippi | 28113 | 9751 | 189 |
2494881 | 2494881 | 2022-05-11 | Cibola | New Mexico | 35006 | 8034 | 189 |
2495133 | 2495133 | 2022-05-11 | Auglaize | Ohio | 39011 | 11618 | 189 |
2496257 | 2496257 | 2022-05-11 | Manitowoc | Wisconsin | 55071 | 20754 | 189 |
2490353 | 2490353 | 2022-05-10 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2491275 | 2491275 | 2022-05-10 | Pike | Mississippi | 28113 | 9751 | 189 |
2491875 | 2491875 | 2022-05-10 | Auglaize | Ohio | 39011 | 11618 | 189 |
2492999 | 2492999 | 2022-05-10 | Manitowoc | Wisconsin | 55071 | 20730 | 189 |
2487096 | 2487096 | 2022-05-09 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2487449 | 2487449 | 2022-05-09 | Butler | Kansas | 20015 | 19057 | 189 |
2488018 | 2488018 | 2022-05-09 | Pike | Mississippi | 28113 | 9751 | 189 |
2488617 | 2488617 | 2022-05-09 | Auglaize | Ohio | 39011 | 11618 | 189 |
2483838 | 2483838 | 2022-05-08 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2484191 | 2484191 | 2022-05-08 | Butler | Kansas | 20015 | 19057 | 189 |
2484760 | 2484760 | 2022-05-08 | Pike | Mississippi | 28113 | 9747 | 189 |
2485360 | 2485360 | 2022-05-08 | Auglaize | Ohio | 39011 | 11618 | 189 |
2480580 | 2480580 | 2022-05-07 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2480933 | 2480933 | 2022-05-07 | Butler | Kansas | 20015 | 19057 | 189 |
2481502 | 2481502 | 2022-05-07 | Pike | Mississippi | 28113 | 9747 | 189 |
2482102 | 2482102 | 2022-05-07 | Auglaize | Ohio | 39011 | 11618 | 189 |
2477322 | 2477322 | 2022-05-06 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2477675 | 2477675 | 2022-05-06 | Butler | Kansas | 20015 | 19057 | 189 |
2478244 | 2478244 | 2022-05-06 | Pike | Mississippi | 28113 | 9747 | 189 |
2478844 | 2478844 | 2022-05-06 | Auglaize | Ohio | 39011 | 11618 | 189 |
2474064 | 2474064 | 2022-05-05 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2474417 | 2474417 | 2022-05-05 | Butler | Kansas | 20015 | 19033 | 189 |
2474986 | 2474986 | 2022-05-05 | Pike | Mississippi | 28113 | 9747 | 189 |
2475586 | 2475586 | 2022-05-05 | Auglaize | Ohio | 39011 | 11618 | 189 |
2470807 | 2470807 | 2022-05-04 | Hawaii | Hawaii | 15001 | 27707 | 189 |
2471160 | 2471160 | 2022-05-04 | Butler | Kansas | 20015 | 19033 | 189 |
2471729 | 2471729 | 2022-05-04 | Pike | Mississippi | 28113 | 9747 | 189 |
2472329 | 2472329 | 2022-05-04 | Auglaize | Ohio | 39011 | 11600 | 189 |
2467904 | 2467904 | 2022-05-03 | Butler | Kansas | 20015 | 19033 | 189 |
2468473 | 2468473 | 2022-05-03 | Pike | Mississippi | 28113 | 9747 | 189 |
2469073 | 2469073 | 2022-05-03 | Auglaize | Ohio | 39011 | 11600 | 189 |
2464649 | 2464649 | 2022-05-02 | Butler | Kansas | 20015 | 19033 | 189 |
2465218 | 2465218 | 2022-05-02 | Pike | Mississippi | 28113 | 9747 | 189 |
2465817 | 2465817 | 2022-05-02 | Auglaize | Ohio | 39011 | 11600 | 189 |
2461393 | 2461393 | 2022-05-01 | Butler | Kansas | 20015 | 19033 | 189 |
2461962 | 2461962 | 2022-05-01 | Pike | Mississippi | 28113 | 9741 | 189 |
2462386 | 2462386 | 2022-05-01 | St. Lawrence | New York | 36089 | 22189 | 189 |
2462562 | 2462562 | 2022-05-01 | Auglaize | Ohio | 39011 | 11600 | 189 |
2458137 | 2458137 | 2022-04-30 | Butler | Kansas | 20015 | 19033 | 189 |
2458706 | 2458706 | 2022-04-30 | Pike | Mississippi | 28113 | 9741 | 189 |
2459130 | 2459130 | 2022-04-30 | St. Lawrence | New York | 36089 | 22167 | 189 |
2459306 | 2459306 | 2022-04-30 | Auglaize | Ohio | 39011 | 11600 | 189 |
2454881 | 2454881 | 2022-04-29 | Butler | Kansas | 20015 | 19033 | 189 |
2455450 | 2455450 | 2022-04-29 | Pike | Mississippi | 28113 | 9741 | 189 |
2455874 | 2455874 | 2022-04-29 | St. Lawrence | New York | 36089 | 22133 | 189 |
2456050 | 2456050 | 2022-04-29 | Auglaize | Ohio | 39011 | 11600 | 189 |
2451625 | 2451625 | 2022-04-28 | Butler | Kansas | 20015 | 19012 | 189 |
2452194 | 2452194 | 2022-04-28 | Pike | Mississippi | 28113 | 9741 | 189 |
2452618 | 2452618 | 2022-04-28 | St. Lawrence | New York | 36089 | 22072 | 189 |
2452794 | 2452794 | 2022-04-28 | Auglaize | Ohio | 39011 | 11600 | 189 |
2448369 | 2448369 | 2022-04-27 | Butler | Kansas | 20015 | 19012 | 189 |
2448938 | 2448938 | 2022-04-27 | Pike | Mississippi | 28113 | 9741 | 189 |
2449352 | 2449352 | 2022-04-27 | Oswego | New York | 36075 | 28017 | 189 |
2449538 | 2449538 | 2022-04-27 | Auglaize | Ohio | 39011 | 11590 | 189 |
2449900 | 2449900 | 2022-04-27 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2445682 | 2445682 | 2022-04-26 | Pike | Mississippi | 28113 | 9741 | 189 |
2446095 | 2446095 | 2022-04-26 | Oswego | New York | 36075 | 27958 | 189 |
2446281 | 2446281 | 2022-04-26 | Auglaize | Ohio | 39011 | 11590 | 189 |
2446643 | 2446643 | 2022-04-26 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2442426 | 2442426 | 2022-04-25 | Pike | Mississippi | 28113 | 9736 | 189 |
2443026 | 2443026 | 2022-04-25 | Auglaize | Ohio | 39011 | 11590 | 189 |
2443388 | 2443388 | 2022-04-25 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2439170 | 2439170 | 2022-04-24 | Pike | Mississippi | 28113 | 9736 | 189 |
2439770 | 2439770 | 2022-04-24 | Auglaize | Ohio | 39011 | 11590 | 189 |
2440132 | 2440132 | 2022-04-24 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2435914 | 2435914 | 2022-04-23 | Pike | Mississippi | 28113 | 9736 | 189 |
2436514 | 2436514 | 2022-04-23 | Auglaize | Ohio | 39011 | 11590 | 189 |
2436876 | 2436876 | 2022-04-23 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2432658 | 2432658 | 2022-04-22 | Pike | Mississippi | 28113 | 9736 | 189 |
2433258 | 2433258 | 2022-04-22 | Auglaize | Ohio | 39011 | 11590 | 189 |
2433620 | 2433620 | 2022-04-22 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2429402 | 2429402 | 2022-04-21 | Pike | Mississippi | 28113 | 9736 | 189 |
2429752 | 2429752 | 2022-04-21 | Curry | New Mexico | 35009 | 12669 | 189 |
2430002 | 2430002 | 2022-04-21 | Auglaize | Ohio | 39011 | 11590 | 189 |
2430364 | 2430364 | 2022-04-21 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2426146 | 2426146 | 2022-04-20 | Pike | Mississippi | 28113 | 9736 | 189 |
2426496 | 2426496 | 2022-04-20 | Curry | New Mexico | 35009 | 12660 | 189 |
2426746 | 2426746 | 2022-04-20 | Auglaize | Ohio | 39011 | 11577 | 189 |
2427108 | 2427108 | 2022-04-20 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2422890 | 2422890 | 2022-04-19 | Pike | Mississippi | 28113 | 9736 | 189 |
2423240 | 2423240 | 2022-04-19 | Curry | New Mexico | 35009 | 12656 | 189 |
2423490 | 2423490 | 2022-04-19 | Auglaize | Ohio | 39011 | 11577 | 189 |
2423852 | 2423852 | 2022-04-19 | Chesterfield | South Carolina | 45025 | 11807 | 189 |
2419634 | 2419634 | 2022-04-18 | Pike | Mississippi | 28113 | 9736 | 189 |
2419983 | 2419983 | 2022-04-18 | Curry | New Mexico | 35009 | 12651 | 189 |
2420233 | 2420233 | 2022-04-18 | Auglaize | Ohio | 39011 | 11577 | 189 |
2416378 | 2416378 | 2022-04-17 | Pike | Mississippi | 28113 | 9736 | 189 |
2416728 | 2416728 | 2022-04-17 | Curry | New Mexico | 35009 | 12632 | 189 |
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);