ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
4,342 rows where deaths = 110 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- North Carolina 361
- Texas 312
- Georgia 239
- Tennessee 239
- Virginia 236
- Illinois 183
- Ohio 172
- Indiana 171
- Michigan 166
- Louisiana 165
- Mississippi 165
- New York 128
- Missouri 125
- California 121
- Wisconsin 120
- Iowa 118
- Florida 110
- Arkansas 108
- Minnesota 104
- Alabama 98
- Kentucky 88
- Maryland 75
- Pennsylvania 68
- New Hampshire 65
- Nevada 60
- Idaho 57
- Washington 50
- Oklahoma 46
- Wyoming 45
- Nebraska 43
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499965 | 2499965 | 2022-05-13 | Washington | Florida | 12133 | 6642 | 110 |
2499982 | 2499982 | 2022-05-13 | Burke | Georgia | 13033 | 5315 | 110 |
2500060 | 2500060 | 2022-05-13 | Madison | Georgia | 13195 | 6950 | 110 |
2500422 | 2500422 | 2022-05-13 | Jasper | Iowa | 19099 | 8707 | 110 |
2500705 | 2500705 | 2022-05-13 | Bienville | Louisiana | 22013 | 3992 | 110 |
2500776 | 2500776 | 2022-05-13 | Somerset | Maine | 23025 | 10213 | 110 |
2500798 | 2500798 | 2022-05-13 | Queen Anne's | Maryland | 24035 | 7246 | 110 |
2500842 | 2500842 | 2022-05-13 | Dickinson | Michigan | 26043 | 7490 | 110 |
2501079 | 2501079 | 2022-05-13 | Audrain | Missouri | 29007 | 5717 | 110 |
2501304 | 2501304 | 2022-05-13 | Lincoln | Nebraska | 31111 | 8706 | 110 |
2501344 | 2501344 | 2022-05-13 | Churchill | Nevada | 32001 | 6599 | 110 |
2501904 | 2501904 | 2022-05-13 | Susquehanna | Pennsylvania | 42115 | 8188 | 110 |
2502151 | 2502151 | 2022-05-13 | Hickman | Tennessee | 47081 | 6850 | 110 |
2496707 | 2496707 | 2022-05-12 | Washington | Florida | 12133 | 6642 | 110 |
2496724 | 2496724 | 2022-05-12 | Burke | Georgia | 13033 | 5315 | 110 |
2496802 | 2496802 | 2022-05-12 | Madison | Georgia | 13195 | 6950 | 110 |
2497164 | 2497164 | 2022-05-12 | Jasper | Iowa | 19099 | 8707 | 110 |
2497447 | 2497447 | 2022-05-12 | Bienville | Louisiana | 22013 | 3992 | 110 |
2497518 | 2497518 | 2022-05-12 | Somerset | Maine | 23025 | 10196 | 110 |
2497540 | 2497540 | 2022-05-12 | Queen Anne's | Maryland | 24035 | 7236 | 110 |
2497584 | 2497584 | 2022-05-12 | Dickinson | Michigan | 26043 | 7490 | 110 |
2497821 | 2497821 | 2022-05-12 | Audrain | Missouri | 29007 | 5718 | 110 |
2498046 | 2498046 | 2022-05-12 | Lincoln | Nebraska | 31111 | 8698 | 110 |
2498086 | 2498086 | 2022-05-12 | Churchill | Nevada | 32001 | 6599 | 110 |
2498646 | 2498646 | 2022-05-12 | Susquehanna | Pennsylvania | 42115 | 8188 | 110 |
2498893 | 2498893 | 2022-05-12 | Hickman | Tennessee | 47081 | 6850 | 110 |
2493449 | 2493449 | 2022-05-11 | Washington | Florida | 12133 | 6642 | 110 |
2493466 | 2493466 | 2022-05-11 | Burke | Georgia | 13033 | 5315 | 110 |
2493544 | 2493544 | 2022-05-11 | Madison | Georgia | 13195 | 6950 | 110 |
2493906 | 2493906 | 2022-05-11 | Jasper | Iowa | 19099 | 8707 | 110 |
2494189 | 2494189 | 2022-05-11 | Bienville | Louisiana | 22013 | 3990 | 110 |
2494260 | 2494260 | 2022-05-11 | Somerset | Maine | 23025 | 10175 | 110 |
2494282 | 2494282 | 2022-05-11 | Queen Anne's | Maryland | 24035 | 7223 | 110 |
2494326 | 2494326 | 2022-05-11 | Dickinson | Michigan | 26043 | 7490 | 110 |
2494563 | 2494563 | 2022-05-11 | Audrain | Missouri | 29007 | 5718 | 110 |
2494788 | 2494788 | 2022-05-11 | Lincoln | Nebraska | 31111 | 8698 | 110 |
2494828 | 2494828 | 2022-05-11 | Churchill | Nevada | 32001 | 6599 | 110 |
2495388 | 2495388 | 2022-05-11 | Susquehanna | Pennsylvania | 42115 | 8188 | 110 |
2495635 | 2495635 | 2022-05-11 | Hickman | Tennessee | 47081 | 6850 | 110 |
2490191 | 2490191 | 2022-05-10 | Washington | Florida | 12133 | 6642 | 110 |
2490208 | 2490208 | 2022-05-10 | Burke | Georgia | 13033 | 5312 | 110 |
2490286 | 2490286 | 2022-05-10 | Madison | Georgia | 13195 | 6941 | 110 |
2490648 | 2490648 | 2022-05-10 | Jasper | Iowa | 19099 | 8680 | 110 |
2490931 | 2490931 | 2022-05-10 | Bienville | Louisiana | 22013 | 3990 | 110 |
2491002 | 2491002 | 2022-05-10 | Somerset | Maine | 23025 | 10161 | 110 |
2491024 | 2491024 | 2022-05-10 | Queen Anne's | Maryland | 24035 | 7221 | 110 |
2491305 | 2491305 | 2022-05-10 | Audrain | Missouri | 29007 | 5718 | 110 |
2491530 | 2491530 | 2022-05-10 | Lincoln | Nebraska | 31111 | 8730 | 110 |
2491570 | 2491570 | 2022-05-10 | Churchill | Nevada | 32001 | 6586 | 110 |
2492377 | 2492377 | 2022-05-10 | Hickman | Tennessee | 47081 | 6844 | 110 |
2486934 | 2486934 | 2022-05-09 | Washington | Florida | 12133 | 6642 | 110 |
2486951 | 2486951 | 2022-05-09 | Burke | Georgia | 13033 | 5312 | 110 |
2487029 | 2487029 | 2022-05-09 | Madison | Georgia | 13195 | 6941 | 110 |
2487391 | 2487391 | 2022-05-09 | Jasper | Iowa | 19099 | 8680 | 110 |
2487674 | 2487674 | 2022-05-09 | Bienville | Louisiana | 22013 | 3990 | 110 |
2487767 | 2487767 | 2022-05-09 | Queen Anne's | Maryland | 24035 | 7211 | 110 |
2488047 | 2488047 | 2022-05-09 | Audrain | Missouri | 29007 | 5718 | 110 |
2488272 | 2488272 | 2022-05-09 | Lincoln | Nebraska | 31111 | 8730 | 110 |
2488312 | 2488312 | 2022-05-09 | Churchill | Nevada | 32001 | 6586 | 110 |
2489119 | 2489119 | 2022-05-09 | Hickman | Tennessee | 47081 | 6844 | 110 |
2483676 | 2483676 | 2022-05-08 | Washington | Florida | 12133 | 6642 | 110 |
2483693 | 2483693 | 2022-05-08 | Burke | Georgia | 13033 | 5312 | 110 |
2483771 | 2483771 | 2022-05-08 | Madison | Georgia | 13195 | 6941 | 110 |
2484133 | 2484133 | 2022-05-08 | Jasper | Iowa | 19099 | 8680 | 110 |
2484416 | 2484416 | 2022-05-08 | Bienville | Louisiana | 22013 | 3990 | 110 |
2484509 | 2484509 | 2022-05-08 | Queen Anne's | Maryland | 24035 | 7202 | 110 |
2484790 | 2484790 | 2022-05-08 | Audrain | Missouri | 29007 | 5718 | 110 |
2485015 | 2485015 | 2022-05-08 | Lincoln | Nebraska | 31111 | 8726 | 110 |
2485055 | 2485055 | 2022-05-08 | Churchill | Nevada | 32001 | 6586 | 110 |
2485862 | 2485862 | 2022-05-08 | Hickman | Tennessee | 47081 | 6844 | 110 |
2480418 | 2480418 | 2022-05-07 | Washington | Florida | 12133 | 6642 | 110 |
2480435 | 2480435 | 2022-05-07 | Burke | Georgia | 13033 | 5312 | 110 |
2480513 | 2480513 | 2022-05-07 | Madison | Georgia | 13195 | 6941 | 110 |
2480875 | 2480875 | 2022-05-07 | Jasper | Iowa | 19099 | 8680 | 110 |
2481158 | 2481158 | 2022-05-07 | Bienville | Louisiana | 22013 | 3990 | 110 |
2481251 | 2481251 | 2022-05-07 | Queen Anne's | Maryland | 24035 | 7202 | 110 |
2481532 | 2481532 | 2022-05-07 | Audrain | Missouri | 29007 | 5718 | 110 |
2481757 | 2481757 | 2022-05-07 | Lincoln | Nebraska | 31111 | 8726 | 110 |
2481797 | 2481797 | 2022-05-07 | Churchill | Nevada | 32001 | 6586 | 110 |
2482604 | 2482604 | 2022-05-07 | Hickman | Tennessee | 47081 | 6844 | 110 |
2477160 | 2477160 | 2022-05-06 | Washington | Florida | 12133 | 6642 | 110 |
2477177 | 2477177 | 2022-05-06 | Burke | Georgia | 13033 | 5312 | 110 |
2477255 | 2477255 | 2022-05-06 | Madison | Georgia | 13195 | 6941 | 110 |
2477617 | 2477617 | 2022-05-06 | Jasper | Iowa | 19099 | 8680 | 110 |
2477900 | 2477900 | 2022-05-06 | Bienville | Louisiana | 22013 | 3990 | 110 |
2477993 | 2477993 | 2022-05-06 | Queen Anne's | Maryland | 24035 | 7202 | 110 |
2478274 | 2478274 | 2022-05-06 | Audrain | Missouri | 29007 | 5718 | 110 |
2478499 | 2478499 | 2022-05-06 | Lincoln | Nebraska | 31111 | 8726 | 110 |
2478539 | 2478539 | 2022-05-06 | Churchill | Nevada | 32001 | 6586 | 110 |
2479346 | 2479346 | 2022-05-06 | Hickman | Tennessee | 47081 | 6844 | 110 |
2473902 | 2473902 | 2022-05-05 | Washington | Florida | 12133 | 6632 | 110 |
2473919 | 2473919 | 2022-05-05 | Burke | Georgia | 13033 | 5312 | 110 |
2473997 | 2473997 | 2022-05-05 | Madison | Georgia | 13195 | 6941 | 110 |
2474359 | 2474359 | 2022-05-05 | Jasper | Iowa | 19099 | 8680 | 110 |
2474642 | 2474642 | 2022-05-05 | Bienville | Louisiana | 22013 | 3990 | 110 |
2474735 | 2474735 | 2022-05-05 | Queen Anne's | Maryland | 24035 | 7192 | 110 |
2475241 | 2475241 | 2022-05-05 | Lincoln | Nebraska | 31111 | 8726 | 110 |
2475281 | 2475281 | 2022-05-05 | Churchill | Nevada | 32001 | 6586 | 110 |
2476088 | 2476088 | 2022-05-05 | Hickman | Tennessee | 47081 | 6844 | 110 |
2470645 | 2470645 | 2022-05-04 | Washington | Florida | 12133 | 6632 | 110 |
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);