ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
21,401 rows where county = "Unknown" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Rhode Island 153
- New Jersey 142
- Puerto Rico 141
- Guam 139
- Massachusetts 138
- Louisiana 136
- Arkansas 134
- Georgia 133
- Vermont 131
- Virgin Islands 131
- Minnesota 128
- Michigan 127
- Connecticut 124
- Utah 124
- Maine 122
- Florida 121
- Delaware 111
- Maryland 110
- Northern Mariana Islands 108
- Illinois 100
- New Hampshire 100
- Iowa 95
- Tennessee 82
- Nebraska 71
- North Dakota 67
- Colorado 64
- Nevada 57
- Alaska 53
- Wisconsin 52
- Kentucky 42
- …
fips 1
- - 3,478
county 1
- Unknown · 3,478 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386119 | 386119 | 2020-07-31 | Unknown | Arkansas | 1554 | 0 | |
386253 | 386253 | 2020-07-31 | Unknown | Connecticut | 243 | 0 | |
386258 | 386258 | 2020-07-31 | Unknown | Delaware | 219 | 0 | |
386323 | 386323 | 2020-07-31 | Unknown | Florida | 570 | 0 | |
386472 | 386472 | 2020-07-31 | Unknown | Georgia | 2311 | 6 | |
386488 | 386488 | 2020-07-31 | Unknown | Guam | 1325 | 6 | |
386626 | 386626 | 2020-07-31 | Unknown | Illinois | 1229 | 197 | |
386818 | 386818 | 2020-07-31 | Unknown | Iowa | 5 | 0 | |
387109 | 387109 | 2020-07-31 | Unknown | Louisiana | 124 | 114 | |
387131 | 387131 | 2020-07-31 | Unknown | Maine | 2 | 0 | |
387156 | 387156 | 2020-07-31 | Unknown | Maryland | 0 | 13 | |
387173 | 387173 | 2020-07-31 | Unknown | Massachusetts | 307 | 6 | |
387254 | 387254 | 2020-07-31 | Unknown | Michigan | 30 | 3 | |
387337 | 387337 | 2020-07-31 | Unknown | Minnesota | 156 | 40 | |
387676 | 387676 | 2020-07-31 | Unknown | Nebraska | 102 | 0 | |
387708 | 387708 | 2020-07-31 | Unknown | New Hampshire | 1 | 0 | |
387729 | 387729 | 2020-07-31 | Unknown | New Jersey | 648 | 0 | |
387970 | 387970 | 2020-07-31 | Unknown | North Dakota | 4 | 4 | |
388315 | 388315 | 2020-07-31 | Unknown | Puerto Rico | 970 | 219 | |
388327 | 388327 | 2020-07-31 | Unknown | Rhode Island | 1778 | 12 | |
388527 | 388527 | 2020-07-31 | Unknown | Tennessee | 415 | 0 | |
388809 | 388809 | 2020-07-31 | Unknown | Utah | 15 | 0 | |
388826 | 388826 | 2020-07-31 | Unknown | Vermont | 7 | 0 | |
389000 | 389000 | 2020-07-31 | Unknown | Washington | 2 | 2 | |
389123 | 389123 | 2020-07-31 | Unknown | Wisconsin | 3471 | 7 | |
382811 | 382811 | 2020-07-30 | Unknown | Alaska | 37 | 0 | |
382901 | 382901 | 2020-07-30 | Unknown | Arkansas | 1584 | 0 | |
383035 | 383035 | 2020-07-30 | Unknown | Connecticut | 242 | 0 | |
383040 | 383040 | 2020-07-30 | Unknown | Delaware | 212 | 0 | |
383105 | 383105 | 2020-07-30 | Unknown | Florida | 559 | 0 | |
383254 | 383254 | 2020-07-30 | Unknown | Georgia | 2279 | 7 | |
383270 | 383270 | 2020-07-30 | Unknown | Guam | 1323 | 6 | |
383408 | 383408 | 2020-07-30 | Unknown | Illinois | 1190 | 192 | |
383600 | 383600 | 2020-07-30 | Unknown | Iowa | 7 | 0 | |
383891 | 383891 | 2020-07-30 | Unknown | Louisiana | 124 | 114 | |
383913 | 383913 | 2020-07-30 | Unknown | Maine | 1 | 0 | |
383938 | 383938 | 2020-07-30 | Unknown | Maryland | 0 | 16 | |
383955 | 383955 | 2020-07-30 | Unknown | Massachusetts | 335 | 6 | |
384036 | 384036 | 2020-07-30 | Unknown | Michigan | 22 | 3 | |
384119 | 384119 | 2020-07-30 | Unknown | Minnesota | 158 | 40 | |
384458 | 384458 | 2020-07-30 | Unknown | Nebraska | 43 | 0 | |
384491 | 384491 | 2020-07-30 | Unknown | New Hampshire | 3 | 0 | |
384512 | 384512 | 2020-07-30 | Unknown | New Jersey | 646 | 0 | |
384753 | 384753 | 2020-07-30 | Unknown | North Dakota | 4 | 4 | |
385098 | 385098 | 2020-07-30 | Unknown | Puerto Rico | 990 | 214 | |
385110 | 385110 | 2020-07-30 | Unknown | Rhode Island | 1706 | 12 | |
385310 | 385310 | 2020-07-30 | Unknown | Tennessee | 118 | 0 | |
385592 | 385592 | 2020-07-30 | Unknown | Utah | 5 | 0 | |
385609 | 385609 | 2020-07-30 | Unknown | Vermont | 7 | 0 | |
385783 | 385783 | 2020-07-30 | Unknown | Washington | 2 | 2 | |
385906 | 385906 | 2020-07-30 | Unknown | Wisconsin | 3453 | 7 | |
379594 | 379594 | 2020-07-29 | Unknown | Alaska | 37 | 0 | |
379684 | 379684 | 2020-07-29 | Unknown | Arkansas | 1545 | 0 | |
379818 | 379818 | 2020-07-29 | Unknown | Connecticut | 250 | 0 | |
379823 | 379823 | 2020-07-29 | Unknown | Delaware | 203 | 0 | |
379888 | 379888 | 2020-07-29 | Unknown | Florida | 528 | 0 | |
380037 | 380037 | 2020-07-29 | Unknown | Georgia | 2429 | 6 | |
380053 | 380053 | 2020-07-29 | Unknown | Guam | 1320 | 6 | |
380191 | 380191 | 2020-07-29 | Unknown | Illinois | 1191 | 192 | |
380383 | 380383 | 2020-07-29 | Unknown | Iowa | 1 | 0 | |
380674 | 380674 | 2020-07-29 | Unknown | Louisiana | 124 | 114 | |
380696 | 380696 | 2020-07-29 | Unknown | Maine | 1 | 0 | |
380721 | 380721 | 2020-07-29 | Unknown | Maryland | 0 | 25 | |
380738 | 380738 | 2020-07-29 | Unknown | Massachusetts | 334 | 6 | |
380819 | 380819 | 2020-07-29 | Unknown | Michigan | 18 | 2 | |
380902 | 380902 | 2020-07-29 | Unknown | Minnesota | 154 | 40 | |
380985 | 380985 | 2020-07-29 | Unknown | Mississippi | 186 | 2 | |
381294 | 381294 | 2020-07-29 | Unknown | New Jersey | 655 | 0 | |
381535 | 381535 | 2020-07-29 | Unknown | North Dakota | 4 | 4 | |
381880 | 381880 | 2020-07-29 | Unknown | Puerto Rico | 986 | 211 | |
381892 | 381892 | 2020-07-29 | Unknown | Rhode Island | 1556 | 12 | |
382092 | 382092 | 2020-07-29 | Unknown | Tennessee | 199 | 4 | |
382374 | 382374 | 2020-07-29 | Unknown | Utah | 5 | 0 | |
382391 | 382391 | 2020-07-29 | Unknown | Vermont | 7 | 0 | |
382565 | 382565 | 2020-07-29 | Unknown | Washington | 2 | 2 | |
382688 | 382688 | 2020-07-29 | Unknown | Wisconsin | 3418 | 7 | |
376378 | 376378 | 2020-07-28 | Unknown | Alaska | 35 | 0 | |
376468 | 376468 | 2020-07-28 | Unknown | Arkansas | 1514 | 0 | |
376601 | 376601 | 2020-07-28 | Unknown | Connecticut | 245 | 0 | |
376606 | 376606 | 2020-07-28 | Unknown | Delaware | 192 | 0 | |
376671 | 376671 | 2020-07-28 | Unknown | Florida | 517 | 0 | |
376820 | 376820 | 2020-07-28 | Unknown | Georgia | 2334 | 7 | |
376836 | 376836 | 2020-07-28 | Unknown | Guam | 1318 | 6 | |
376974 | 376974 | 2020-07-28 | Unknown | Illinois | 1191 | 192 | |
377166 | 377166 | 2020-07-28 | Unknown | Iowa | 8 | 0 | |
377457 | 377457 | 2020-07-28 | Unknown | Louisiana | 122 | 112 | |
377479 | 377479 | 2020-07-28 | Unknown | Maine | 1 | 0 | |
377504 | 377504 | 2020-07-28 | Unknown | Maryland | 0 | 14 | |
377521 | 377521 | 2020-07-28 | Unknown | Massachusetts | 327 | 6 | |
377602 | 377602 | 2020-07-28 | Unknown | Michigan | 15 | 2 | |
377685 | 377685 | 2020-07-28 | Unknown | Minnesota | 226 | 40 | |
377768 | 377768 | 2020-07-28 | Unknown | Mississippi | 98 | 1 | |
378076 | 378076 | 2020-07-28 | Unknown | New Jersey | 680 | 0 | |
378109 | 378109 | 2020-07-28 | Unknown | New Mexico | 19 | 0 | |
378318 | 378318 | 2020-07-28 | Unknown | North Dakota | 4 | 4 | |
378663 | 378663 | 2020-07-28 | Unknown | Puerto Rico | 969 | 209 | |
378675 | 378675 | 2020-07-28 | Unknown | Rhode Island | 2112 | 18 | |
378875 | 378875 | 2020-07-28 | Unknown | Tennessee | 171 | 1 | |
379157 | 379157 | 2020-07-28 | Unknown | Utah | 4 | 0 | |
379174 | 379174 | 2020-07-28 | Unknown | Vermont | 7 | 0 |
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);