ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
7,863 rows where deaths = 63 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: county, fips
state >30
- Georgia 509
- Texas 449
- Tennessee 438
- North Carolina 375
- Kentucky 366
- Missouri 339
- Ohio 328
- New York 319
- Virginia 313
- Alabama 300
- Iowa 281
- Arkansas 266
- Wisconsin 250
- California 243
- Indiana 243
- Mississippi 234
- Michigan 224
- Illinois 222
- Louisiana 209
- Minnesota 187
- Oklahoma 185
- South Carolina 163
- Colorado 162
- Montana 153
- Kansas 140
- West Virginia 125
- Pennsylvania 114
- Oregon 105
- Maryland 79
- Idaho 73
- …
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499719 | 2499719 | 2022-05-13 | Jackson | Arkansas | 5067 | 6135 | 63 |
2500472 | 2500472 | 2022-05-13 | Wright | Iowa | 19197 | 3626 | 63 |
2500516 | 2500516 | 2022-05-13 | Jefferson | Kansas | 20087 | 4832 | 63 |
2501076 | 2501076 | 2022-05-13 | Adair | Missouri | 29001 | 6095 | 63 |
2501159 | 2501159 | 2022-05-13 | Pike | Missouri | 29163 | 4264 | 63 |
2501418 | 2501418 | 2022-05-13 | San Miguel | New Mexico | 35047 | 5926 | 63 |
2501843 | 2501843 | 2022-05-13 | Wasco | Oregon | 41065 | 5218 | 63 |
2502118 | 2502118 | 2022-05-13 | Cannon | Tennessee | 47015 | 4227 | 63 |
2502154 | 2502154 | 2022-05-13 | Jackson | Tennessee | 47087 | 3211 | 63 |
2496461 | 2496461 | 2022-05-12 | Jackson | Arkansas | 5067 | 6134 | 63 |
2497214 | 2497214 | 2022-05-12 | Wright | Iowa | 19197 | 3626 | 63 |
2497258 | 2497258 | 2022-05-12 | Jefferson | Kansas | 20087 | 4823 | 63 |
2497818 | 2497818 | 2022-05-12 | Adair | Missouri | 29001 | 6095 | 63 |
2497901 | 2497901 | 2022-05-12 | Pike | Missouri | 29163 | 4263 | 63 |
2498160 | 2498160 | 2022-05-12 | San Miguel | New Mexico | 35047 | 5925 | 63 |
2498585 | 2498585 | 2022-05-12 | Wasco | Oregon | 41065 | 5212 | 63 |
2498860 | 2498860 | 2022-05-12 | Cannon | Tennessee | 47015 | 4227 | 63 |
2498896 | 2498896 | 2022-05-12 | Jackson | Tennessee | 47087 | 3211 | 63 |
2493203 | 2493203 | 2022-05-11 | Jackson | Arkansas | 5067 | 6134 | 63 |
2493956 | 2493956 | 2022-05-11 | Wright | Iowa | 19197 | 3626 | 63 |
2494000 | 2494000 | 2022-05-11 | Jefferson | Kansas | 20087 | 4823 | 63 |
2494560 | 2494560 | 2022-05-11 | Adair | Missouri | 29001 | 6095 | 63 |
2494643 | 2494643 | 2022-05-11 | Pike | Missouri | 29163 | 4263 | 63 |
2494902 | 2494902 | 2022-05-11 | San Miguel | New Mexico | 35047 | 5917 | 63 |
2495327 | 2495327 | 2022-05-11 | Wasco | Oregon | 41065 | 5205 | 63 |
2495602 | 2495602 | 2022-05-11 | Cannon | Tennessee | 47015 | 4227 | 63 |
2495638 | 2495638 | 2022-05-11 | Jackson | Tennessee | 47087 | 3211 | 63 |
2489945 | 2489945 | 2022-05-10 | Jackson | Arkansas | 5067 | 6134 | 63 |
2490698 | 2490698 | 2022-05-10 | Wright | Iowa | 19197 | 3614 | 63 |
2490742 | 2490742 | 2022-05-10 | Jefferson | Kansas | 20087 | 4823 | 63 |
2491302 | 2491302 | 2022-05-10 | Adair | Missouri | 29001 | 6095 | 63 |
2491385 | 2491385 | 2022-05-10 | Pike | Missouri | 29163 | 4263 | 63 |
2491644 | 2491644 | 2022-05-10 | San Miguel | New Mexico | 35047 | 5913 | 63 |
2492069 | 2492069 | 2022-05-10 | Wasco | Oregon | 41065 | 5201 | 63 |
2492344 | 2492344 | 2022-05-10 | Cannon | Tennessee | 47015 | 4219 | 63 |
2492380 | 2492380 | 2022-05-10 | Jackson | Tennessee | 47087 | 3208 | 63 |
2492987 | 2492987 | 2022-05-10 | Green Lake | Wisconsin | 55047 | 5236 | 63 |
2486688 | 2486688 | 2022-05-09 | Jackson | Arkansas | 5067 | 6133 | 63 |
2487441 | 2487441 | 2022-05-09 | Wright | Iowa | 19197 | 3614 | 63 |
2487485 | 2487485 | 2022-05-09 | Jefferson | Kansas | 20087 | 4823 | 63 |
2488044 | 2488044 | 2022-05-09 | Adair | Missouri | 29001 | 6095 | 63 |
2488127 | 2488127 | 2022-05-09 | Pike | Missouri | 29163 | 4263 | 63 |
2488811 | 2488811 | 2022-05-09 | Wasco | Oregon | 41065 | 5194 | 63 |
2489086 | 2489086 | 2022-05-09 | Cannon | Tennessee | 47015 | 4219 | 63 |
2489122 | 2489122 | 2022-05-09 | Jackson | Tennessee | 47087 | 3208 | 63 |
2489729 | 2489729 | 2022-05-09 | Green Lake | Wisconsin | 55047 | 5229 | 63 |
2483430 | 2483430 | 2022-05-08 | Jackson | Arkansas | 5067 | 6132 | 63 |
2483877 | 2483877 | 2022-05-08 | Minidoka | Idaho | 16067 | 4232 | 63 |
2484183 | 2484183 | 2022-05-08 | Wright | Iowa | 19197 | 3614 | 63 |
2484227 | 2484227 | 2022-05-08 | Jefferson | Kansas | 20087 | 4823 | 63 |
2484787 | 2484787 | 2022-05-08 | Adair | Missouri | 29001 | 6095 | 63 |
2484870 | 2484870 | 2022-05-08 | Pike | Missouri | 29163 | 4263 | 63 |
2485554 | 2485554 | 2022-05-08 | Wasco | Oregon | 41065 | 5188 | 63 |
2485829 | 2485829 | 2022-05-08 | Cannon | Tennessee | 47015 | 4219 | 63 |
2485865 | 2485865 | 2022-05-08 | Jackson | Tennessee | 47087 | 3208 | 63 |
2486472 | 2486472 | 2022-05-08 | Green Lake | Wisconsin | 55047 | 5218 | 63 |
2480172 | 2480172 | 2022-05-07 | Jackson | Arkansas | 5067 | 6131 | 63 |
2480619 | 2480619 | 2022-05-07 | Minidoka | Idaho | 16067 | 4232 | 63 |
2480925 | 2480925 | 2022-05-07 | Wright | Iowa | 19197 | 3614 | 63 |
2480969 | 2480969 | 2022-05-07 | Jefferson | Kansas | 20087 | 4823 | 63 |
2481529 | 2481529 | 2022-05-07 | Adair | Missouri | 29001 | 6095 | 63 |
2481612 | 2481612 | 2022-05-07 | Pike | Missouri | 29163 | 4263 | 63 |
2482296 | 2482296 | 2022-05-07 | Wasco | Oregon | 41065 | 5188 | 63 |
2482571 | 2482571 | 2022-05-07 | Cannon | Tennessee | 47015 | 4219 | 63 |
2482607 | 2482607 | 2022-05-07 | Jackson | Tennessee | 47087 | 3208 | 63 |
2483214 | 2483214 | 2022-05-07 | Green Lake | Wisconsin | 55047 | 5218 | 63 |
2476914 | 2476914 | 2022-05-06 | Jackson | Arkansas | 5067 | 6129 | 63 |
2477361 | 2477361 | 2022-05-06 | Minidoka | Idaho | 16067 | 4232 | 63 |
2477667 | 2477667 | 2022-05-06 | Wright | Iowa | 19197 | 3614 | 63 |
2477711 | 2477711 | 2022-05-06 | Jefferson | Kansas | 20087 | 4823 | 63 |
2478271 | 2478271 | 2022-05-06 | Adair | Missouri | 29001 | 6095 | 63 |
2478354 | 2478354 | 2022-05-06 | Pike | Missouri | 29163 | 4263 | 63 |
2479038 | 2479038 | 2022-05-06 | Wasco | Oregon | 41065 | 5188 | 63 |
2479313 | 2479313 | 2022-05-06 | Cannon | Tennessee | 47015 | 4219 | 63 |
2479349 | 2479349 | 2022-05-06 | Jackson | Tennessee | 47087 | 3208 | 63 |
2479956 | 2479956 | 2022-05-06 | Green Lake | Wisconsin | 55047 | 5218 | 63 |
2473656 | 2473656 | 2022-05-05 | Jackson | Arkansas | 5067 | 6129 | 63 |
2474103 | 2474103 | 2022-05-05 | Minidoka | Idaho | 16067 | 4232 | 63 |
2474409 | 2474409 | 2022-05-05 | Wright | Iowa | 19197 | 3614 | 63 |
2474453 | 2474453 | 2022-05-05 | Jefferson | Kansas | 20087 | 4814 | 63 |
2475013 | 2475013 | 2022-05-05 | Adair | Missouri | 29001 | 6095 | 63 |
2475096 | 2475096 | 2022-05-05 | Pike | Missouri | 29163 | 4252 | 63 |
2475780 | 2475780 | 2022-05-05 | Wasco | Oregon | 41065 | 5184 | 63 |
2476055 | 2476055 | 2022-05-05 | Cannon | Tennessee | 47015 | 4219 | 63 |
2476091 | 2476091 | 2022-05-05 | Jackson | Tennessee | 47087 | 3208 | 63 |
2476698 | 2476698 | 2022-05-05 | Green Lake | Wisconsin | 55047 | 5210 | 63 |
2470399 | 2470399 | 2022-05-04 | Jackson | Arkansas | 5067 | 6129 | 63 |
2470846 | 2470846 | 2022-05-04 | Minidoka | Idaho | 16067 | 4232 | 63 |
2471152 | 2471152 | 2022-05-04 | Wright | Iowa | 19197 | 3614 | 63 |
2471196 | 2471196 | 2022-05-04 | Jefferson | Kansas | 20087 | 4814 | 63 |
2471839 | 2471839 | 2022-05-04 | Pike | Missouri | 29163 | 4238 | 63 |
2472523 | 2472523 | 2022-05-04 | Wasco | Oregon | 41065 | 5182 | 63 |
2472798 | 2472798 | 2022-05-04 | Cannon | Tennessee | 47015 | 4219 | 63 |
2472834 | 2472834 | 2022-05-04 | Jackson | Tennessee | 47087 | 3208 | 63 |
2473440 | 2473440 | 2022-05-04 | Green Lake | Wisconsin | 55047 | 5203 | 63 |
2467143 | 2467143 | 2022-05-03 | Jackson | Arkansas | 5067 | 6118 | 63 |
2467590 | 2467590 | 2022-05-03 | Minidoka | Idaho | 16067 | 4231 | 63 |
2467896 | 2467896 | 2022-05-03 | Wright | Iowa | 19197 | 3613 | 63 |
2467940 | 2467940 | 2022-05-03 | Jefferson | Kansas | 20087 | 4814 | 63 |
2468583 | 2468583 | 2022-05-03 | Pike | Missouri | 29163 | 4238 | 63 |
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);