ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,654 rows where deaths = 116 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Texas 278
- Georgia 237
- Louisiana 196
- Minnesota 186
- Missouri 177
- Tennessee 165
- Ohio 162
- Indiana 155
- Mississippi 152
- North Carolina 144
- Illinois 143
- Virginia 123
- Arkansas 121
- Wisconsin 116
- New York 112
- Alabama 104
- Pennsylvania 89
- West Virginia 84
- Florida 79
- California 75
- Michigan 71
- New Hampshire 67
- Kentucky 66
- Iowa 64
- Maryland 60
- Washington 60
- South Carolina 47
- Kansas 45
- Montana 45
- New Mexico 43
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499827 | 2499827 | 2022-05-13 | Broomfield | Colorado | 8014 | 13997 | 116 |
2499960 | 2499960 | 2022-05-13 | Union | Florida | 12125 | 4321 | 116 |
2500104 | 2500104 | 2022-05-13 | Towns | Georgia | 13281 | 2400 | 116 |
2500792 | 2500792 | 2022-05-13 | Garrett | Maryland | 24023 | 5761 | 116 |
2501162 | 2501162 | 2022-05-13 | Pulaski | Missouri | 29169 | 8918 | 116 |
2501532 | 2501532 | 2022-05-13 | Hoke | North Carolina | 37093 | 15074 | 116 |
2502145 | 2502145 | 2022-05-13 | Hardeman | Tennessee | 47069 | 7606 | 116 |
2502737 | 2502737 | 2022-05-13 | Wyoming | West Virginia | 54109 | 7044 | 116 |
2496569 | 2496569 | 2022-05-12 | Broomfield | Colorado | 8014 | 13949 | 116 |
2496702 | 2496702 | 2022-05-12 | Union | Florida | 12125 | 4321 | 116 |
2496846 | 2496846 | 2022-05-12 | Towns | Georgia | 13281 | 2400 | 116 |
2497313 | 2497313 | 2022-05-12 | Unknown | Kansas | 0 | 116 | |
2497534 | 2497534 | 2022-05-12 | Garrett | Maryland | 24023 | 5757 | 116 |
2497667 | 2497667 | 2022-05-12 | Douglas | Minnesota | 27041 | 11092 | 116 |
2497904 | 2497904 | 2022-05-12 | Pulaski | Missouri | 29169 | 8894 | 116 |
2498204 | 2498204 | 2022-05-12 | Orleans | New York | 36073 | 9116 | 116 |
2498274 | 2498274 | 2022-05-12 | Hoke | North Carolina | 37093 | 15074 | 116 |
2498887 | 2498887 | 2022-05-12 | Hardeman | Tennessee | 47069 | 7606 | 116 |
2499479 | 2499479 | 2022-05-12 | Wyoming | West Virginia | 54109 | 7042 | 116 |
2493311 | 2493311 | 2022-05-11 | Broomfield | Colorado | 8014 | 13868 | 116 |
2493444 | 2493444 | 2022-05-11 | Union | Florida | 12125 | 4321 | 116 |
2493588 | 2493588 | 2022-05-11 | Towns | Georgia | 13281 | 2400 | 116 |
2494055 | 2494055 | 2022-05-11 | Unknown | Kansas | 0 | 116 | |
2494276 | 2494276 | 2022-05-11 | Garrett | Maryland | 24023 | 5755 | 116 |
2494409 | 2494409 | 2022-05-11 | Douglas | Minnesota | 27041 | 11076 | 116 |
2494646 | 2494646 | 2022-05-11 | Pulaski | Missouri | 29169 | 8894 | 116 |
2494946 | 2494946 | 2022-05-11 | Orleans | New York | 36073 | 9084 | 116 |
2495016 | 2495016 | 2022-05-11 | Hoke | North Carolina | 37093 | 15074 | 116 |
2495629 | 2495629 | 2022-05-11 | Hardeman | Tennessee | 47069 | 7606 | 116 |
2496112 | 2496112 | 2022-05-11 | Staunton city | Virginia | 51790 | 5781 | 116 |
2496221 | 2496221 | 2022-05-11 | Wyoming | West Virginia | 54109 | 7040 | 116 |
2490053 | 2490053 | 2022-05-10 | Broomfield | Colorado | 8014 | 13842 | 116 |
2490330 | 2490330 | 2022-05-10 | Towns | Georgia | 13281 | 2398 | 116 |
2490797 | 2490797 | 2022-05-10 | Unknown | Kansas | 0 | 116 | |
2491018 | 2491018 | 2022-05-10 | Garrett | Maryland | 24023 | 5752 | 116 |
2491151 | 2491151 | 2022-05-10 | Douglas | Minnesota | 27041 | 11067 | 116 |
2491388 | 2491388 | 2022-05-10 | Pulaski | Missouri | 29169 | 8894 | 116 |
2491688 | 2491688 | 2022-05-10 | Orleans | New York | 36073 | 9068 | 116 |
2491758 | 2491758 | 2022-05-10 | Hoke | North Carolina | 37093 | 14976 | 116 |
2492371 | 2492371 | 2022-05-10 | Hardeman | Tennessee | 47069 | 7601 | 116 |
2492854 | 2492854 | 2022-05-10 | Staunton city | Virginia | 51790 | 5752 | 116 |
2492963 | 2492963 | 2022-05-10 | Wyoming | West Virginia | 54109 | 7034 | 116 |
2486796 | 2486796 | 2022-05-09 | Broomfield | Colorado | 8014 | 13811 | 116 |
2487073 | 2487073 | 2022-05-09 | Towns | Georgia | 13281 | 2398 | 116 |
2487761 | 2487761 | 2022-05-09 | Garrett | Maryland | 24023 | 5743 | 116 |
2487894 | 2487894 | 2022-05-09 | Douglas | Minnesota | 27041 | 11040 | 116 |
2488130 | 2488130 | 2022-05-09 | Pulaski | Missouri | 29169 | 8894 | 116 |
2488500 | 2488500 | 2022-05-09 | Hoke | North Carolina | 37093 | 14976 | 116 |
2489113 | 2489113 | 2022-05-09 | Hardeman | Tennessee | 47069 | 7601 | 116 |
2489705 | 2489705 | 2022-05-09 | Wyoming | West Virginia | 54109 | 7034 | 116 |
2483538 | 2483538 | 2022-05-08 | Broomfield | Colorado | 8014 | 13762 | 116 |
2483815 | 2483815 | 2022-05-08 | Towns | Georgia | 13281 | 2398 | 116 |
2484503 | 2484503 | 2022-05-08 | Garrett | Maryland | 24023 | 5736 | 116 |
2484636 | 2484636 | 2022-05-08 | Douglas | Minnesota | 27041 | 11026 | 116 |
2484873 | 2484873 | 2022-05-08 | Pulaski | Missouri | 29169 | 8894 | 116 |
2485243 | 2485243 | 2022-05-08 | Hoke | North Carolina | 37093 | 14976 | 116 |
2485856 | 2485856 | 2022-05-08 | Hardeman | Tennessee | 47069 | 7601 | 116 |
2486448 | 2486448 | 2022-05-08 | Wyoming | West Virginia | 54109 | 7032 | 116 |
2480280 | 2480280 | 2022-05-07 | Broomfield | Colorado | 8014 | 13762 | 116 |
2480557 | 2480557 | 2022-05-07 | Towns | Georgia | 13281 | 2398 | 116 |
2481245 | 2481245 | 2022-05-07 | Garrett | Maryland | 24023 | 5736 | 116 |
2481378 | 2481378 | 2022-05-07 | Douglas | Minnesota | 27041 | 11026 | 116 |
2481615 | 2481615 | 2022-05-07 | Pulaski | Missouri | 29169 | 8894 | 116 |
2481985 | 2481985 | 2022-05-07 | Hoke | North Carolina | 37093 | 14976 | 116 |
2482598 | 2482598 | 2022-05-07 | Hardeman | Tennessee | 47069 | 7601 | 116 |
2483190 | 2483190 | 2022-05-07 | Wyoming | West Virginia | 54109 | 7032 | 116 |
2477022 | 2477022 | 2022-05-06 | Broomfield | Colorado | 8014 | 13762 | 116 |
2477299 | 2477299 | 2022-05-06 | Towns | Georgia | 13281 | 2398 | 116 |
2477987 | 2477987 | 2022-05-06 | Garrett | Maryland | 24023 | 5736 | 116 |
2478120 | 2478120 | 2022-05-06 | Douglas | Minnesota | 27041 | 11026 | 116 |
2478357 | 2478357 | 2022-05-06 | Pulaski | Missouri | 29169 | 8894 | 116 |
2478727 | 2478727 | 2022-05-06 | Hoke | North Carolina | 37093 | 14976 | 116 |
2479340 | 2479340 | 2022-05-06 | Hardeman | Tennessee | 47069 | 7601 | 116 |
2479932 | 2479932 | 2022-05-06 | Wyoming | West Virginia | 54109 | 7032 | 116 |
2473764 | 2473764 | 2022-05-05 | Broomfield | Colorado | 8014 | 13745 | 116 |
2474041 | 2474041 | 2022-05-05 | Towns | Georgia | 13281 | 2398 | 116 |
2474729 | 2474729 | 2022-05-05 | Garrett | Maryland | 24023 | 5735 | 116 |
2474862 | 2474862 | 2022-05-05 | Douglas | Minnesota | 27041 | 11015 | 116 |
2475099 | 2475099 | 2022-05-05 | Pulaski | Missouri | 29169 | 8877 | 116 |
2475469 | 2475469 | 2022-05-05 | Hoke | North Carolina | 37093 | 14976 | 116 |
2476082 | 2476082 | 2022-05-05 | Hardeman | Tennessee | 47069 | 7601 | 116 |
2476674 | 2476674 | 2022-05-05 | Wyoming | West Virginia | 54109 | 7029 | 116 |
2470507 | 2470507 | 2022-05-04 | Broomfield | Colorado | 8014 | 13721 | 116 |
2470784 | 2470784 | 2022-05-04 | Towns | Georgia | 13281 | 2398 | 116 |
2471472 | 2471472 | 2022-05-04 | Garrett | Maryland | 24023 | 5735 | 116 |
2471605 | 2471605 | 2022-05-04 | Douglas | Minnesota | 27041 | 11004 | 116 |
2472212 | 2472212 | 2022-05-04 | Hoke | North Carolina | 37093 | 14976 | 116 |
2472825 | 2472825 | 2022-05-04 | Hardeman | Tennessee | 47069 | 7601 | 116 |
2467251 | 2467251 | 2022-05-03 | Broomfield | Colorado | 8014 | 13713 | 116 |
2467384 | 2467384 | 2022-05-03 | Union | Florida | 12125 | 4313 | 116 |
2467528 | 2467528 | 2022-05-03 | Towns | Georgia | 13281 | 2396 | 116 |
2468216 | 2468216 | 2022-05-03 | Garrett | Maryland | 24023 | 5733 | 116 |
2468349 | 2468349 | 2022-05-03 | Douglas | Minnesota | 27041 | 10995 | 116 |
2469569 | 2469569 | 2022-05-03 | Hardeman | Tennessee | 47069 | 7598 | 116 |
2464129 | 2464129 | 2022-05-02 | Union | Florida | 12125 | 4313 | 116 |
2464273 | 2464273 | 2022-05-02 | Towns | Georgia | 13281 | 2396 | 116 |
2464740 | 2464740 | 2022-05-02 | Unknown | Kansas | 0 | 116 | |
2464961 | 2464961 | 2022-05-02 | Garrett | Maryland | 24023 | 5733 | 116 |
2465094 | 2465094 | 2022-05-02 | Douglas | Minnesota | 27041 | 10986 | 116 |
2465619 | 2465619 | 2022-05-02 | Livingston | New York | 36051 | 12088 | 116 |
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);