ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
23,678 rows where fips = "" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state >30
- Missouri 208
- New York 163
- 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
- …
county 4
- Unknown 3,478
- New York City 153
- Kansas City 134
- Joplin 37
fips 1
- - · 3,802 ✖
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 | |
387480 | 387480 | 2020-07-31 | Joplin | Missouri | 436 | 20 | |
387481 | 387481 | 2020-07-31 | Kansas City | Missouri | 5798 | 69 | |
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 | |
387791 | 387791 | 2020-07-31 | New York City | New York | 229834 | 23002 | |
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 | |
384262 | 384262 | 2020-07-30 | Joplin | Missouri | 432 | 19 | |
384263 | 384263 | 2020-07-30 | Kansas City | Missouri | 5672 | 64 | |
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 | |
384574 | 384574 | 2020-07-30 | New York City | New York | 229551 | 22996 | |
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 | |
381046 | 381046 | 2020-07-29 | Joplin | Missouri | 426 | 19 | |
381047 | 381047 | 2020-07-29 | Kansas City | Missouri | 5428 | 62 | |
381294 | 381294 | 2020-07-29 | Unknown | New Jersey | 655 | 0 | |
381356 | 381356 | 2020-07-29 | New York City | New York | 229237 | 22982 | |
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 |
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);