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 149
- New Jersey 138
- Puerto Rico 137
- Guam 135
- Massachusetts 134
- Louisiana 132
- Virgin Islands 131
- Arkansas 130
- Georgia 129
- Vermont 127
- Minnesota 124
- Michigan 123
- Connecticut 120
- Utah 120
- Maine 118
- Florida 117
- Northern Mariana Islands 108
- Delaware 107
- Maryland 106
- New Hampshire 98
- Illinois 96
- Iowa 91
- Tennessee 78
- Nebraska 69
- Colorado 64
- North Dakota 63
- Nevada 57
- Alaska 50
- Wisconsin 49
- Kentucky 42
- …
fips 1
- - 3,378
county 1
- Unknown · 3,378 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
379348 | 379348 | 2020-07-28 | Unknown | Washington | 2 | 2 | |
379471 | 379471 | 2020-07-28 | Unknown | Wisconsin | 3367 | 7 | |
373164 | 373164 | 2020-07-27 | Unknown | Alaska | 26 | 0 | |
373254 | 373254 | 2020-07-27 | Unknown | Arkansas | 1499 | 0 | |
373387 | 373387 | 2020-07-27 | Unknown | Connecticut | 242 | 0 | |
373392 | 373392 | 2020-07-27 | Unknown | Delaware | 192 | 0 | |
373457 | 373457 | 2020-07-27 | Unknown | Florida | 501 | 0 | |
373606 | 373606 | 2020-07-27 | Unknown | Georgia | 2202 | 6 | |
373622 | 373622 | 2020-07-27 | Unknown | Guam | 1315 | 6 | |
373759 | 373759 | 2020-07-27 | Unknown | Illinois | 1191 | 192 | |
373951 | 373951 | 2020-07-27 | Unknown | Iowa | 2 | 0 | |
374242 | 374242 | 2020-07-27 | Unknown | Louisiana | 122 | 112 | |
374264 | 374264 | 2020-07-27 | Unknown | Maine | 1 | 0 | |
374289 | 374289 | 2020-07-27 | Unknown | Maryland | 0 | 14 | |
374306 | 374306 | 2020-07-27 | Unknown | Massachusetts | 328 | 6 | |
374387 | 374387 | 2020-07-27 | Unknown | Michigan | 13 | 2 | |
374470 | 374470 | 2020-07-27 | Unknown | Minnesota | 220 | 40 | |
374553 | 374553 | 2020-07-27 | Unknown | Mississippi | 60 | 1 | |
374808 | 374808 | 2020-07-27 | Unknown | Nebraska | 54 | 0 | |
374861 | 374861 | 2020-07-27 | Unknown | New Jersey | 701 | 0 | |
375101 | 375101 | 2020-07-27 | Unknown | North Dakota | 4 | 4 | |
375268 | 375268 | 2020-07-27 | Unknown | Oklahoma | 1 | 0 | |
375447 | 375447 | 2020-07-27 | Unknown | Puerto Rico | 927 | 201 | |
375459 | 375459 | 2020-07-27 | Unknown | Rhode Island | 1902 | 17 | |
375659 | 375659 | 2020-07-27 | Unknown | Tennessee | 283 | 2 | |
375941 | 375941 | 2020-07-27 | Unknown | Utah | 4 | 0 | |
375958 | 375958 | 2020-07-27 | Unknown | Vermont | 7 | 0 | |
376132 | 376132 | 2020-07-27 | Unknown | Washington | 2 | 2 | |
376255 | 376255 | 2020-07-27 | Unknown | Wisconsin | 3345 | 7 | |
369952 | 369952 | 2020-07-26 | Unknown | Alaska | 22 | 0 | |
370042 | 370042 | 2020-07-26 | Unknown | Arkansas | 1400 | 0 | |
370175 | 370175 | 2020-07-26 | Unknown | Connecticut | 222 | 0 | |
370180 | 370180 | 2020-07-26 | Unknown | Delaware | 187 | 0 | |
370245 | 370245 | 2020-07-26 | Unknown | Florida | 489 | 0 | |
370394 | 370394 | 2020-07-26 | Unknown | Georgia | 2099 | 6 | |
370410 | 370410 | 2020-07-26 | Unknown | Guam | 1306 | 6 | |
370547 | 370547 | 2020-07-26 | Unknown | Illinois | 1191 | 192 | |
370739 | 370739 | 2020-07-26 | Unknown | Iowa | 5 | 0 | |
371030 | 371030 | 2020-07-26 | Unknown | Louisiana | 122 | 112 | |
371052 | 371052 | 2020-07-26 | Unknown | Maine | 1 | 0 | |
371077 | 371077 | 2020-07-26 | Unknown | Maryland | 0 | 15 | |
371094 | 371094 | 2020-07-26 | Unknown | Massachusetts | 325 | 6 | |
371175 | 371175 | 2020-07-26 | Unknown | Michigan | 11 | 2 | |
371258 | 371258 | 2020-07-26 | Unknown | Minnesota | 207 | 40 | |
371341 | 371341 | 2020-07-26 | Unknown | Mississippi | 34 | 0 | |
371596 | 371596 | 2020-07-26 | Unknown | Nebraska | 2 | 0 | |
371649 | 371649 | 2020-07-26 | Unknown | New Jersey | 707 | 0 | |
371889 | 371889 | 2020-07-26 | Unknown | North Dakota | 4 | 4 | |
372234 | 372234 | 2020-07-26 | Unknown | Puerto Rico | 893 | 201 | |
372246 | 372246 | 2020-07-26 | Unknown | Rhode Island | 1611 | 15 | |
372446 | 372446 | 2020-07-26 | Unknown | Tennessee | 402 | 1 | |
372728 | 372728 | 2020-07-26 | Unknown | Utah | 53 | 0 | |
372744 | 372744 | 2020-07-26 | Unknown | Vermont | 7 | 0 | |
372918 | 372918 | 2020-07-26 | Unknown | Washington | 2 | 2 | |
373041 | 373041 | 2020-07-26 | Unknown | Wisconsin | 3352 | 7 | |
366742 | 366742 | 2020-07-25 | Unknown | Alaska | 16 | 0 | |
366832 | 366832 | 2020-07-25 | Unknown | Arkansas | 1381 | 0 | |
366965 | 366965 | 2020-07-25 | Unknown | Connecticut | 222 | 0 | |
366970 | 366970 | 2020-07-25 | Unknown | Delaware | 182 | 0 | |
367035 | 367035 | 2020-07-25 | Unknown | Florida | 462 | 0 | |
367184 | 367184 | 2020-07-25 | Unknown | Georgia | 2057 | 7 | |
367200 | 367200 | 2020-07-25 | Unknown | Guam | 1306 | 6 | |
367337 | 367337 | 2020-07-25 | Unknown | Illinois | 1230 | 192 | |
367529 | 367529 | 2020-07-25 | Unknown | Iowa | 8 | 0 | |
367820 | 367820 | 2020-07-25 | Unknown | Louisiana | 122 | 112 | |
367842 | 367842 | 2020-07-25 | Unknown | Maine | 1 | 0 | |
367867 | 367867 | 2020-07-25 | Unknown | Maryland | 0 | 14 | |
367884 | 367884 | 2020-07-25 | Unknown | Massachusetts | 323 | 6 | |
367965 | 367965 | 2020-07-25 | Unknown | Michigan | 15 | 2 | |
368048 | 368048 | 2020-07-25 | Unknown | Minnesota | 206 | 40 | |
368437 | 368437 | 2020-07-25 | Unknown | New Jersey | 680 | 0 | |
368677 | 368677 | 2020-07-25 | Unknown | North Dakota | 4 | 4 | |
369022 | 369022 | 2020-07-25 | Unknown | Puerto Rico | 833 | 201 | |
369034 | 369034 | 2020-07-25 | Unknown | Rhode Island | 1611 | 15 | |
369234 | 369234 | 2020-07-25 | Unknown | Tennessee | 175 | 3 | |
369516 | 369516 | 2020-07-25 | Unknown | Utah | 7 | 0 | |
369532 | 369532 | 2020-07-25 | Unknown | Vermont | 7 | 0 | |
369706 | 369706 | 2020-07-25 | Unknown | Washington | 2 | 2 | |
369829 | 369829 | 2020-07-25 | Unknown | Wisconsin | 3344 | 7 | |
363535 | 363535 | 2020-07-24 | Unknown | Alaska | 11 | 0 | |
363625 | 363625 | 2020-07-24 | Unknown | Arkansas | 1398 | 0 | |
363758 | 363758 | 2020-07-24 | Unknown | Connecticut | 222 | 0 | |
363763 | 363763 | 2020-07-24 | Unknown | Delaware | 184 | 0 | |
363828 | 363828 | 2020-07-24 | Unknown | Florida | 447 | 0 | |
363977 | 363977 | 2020-07-24 | Unknown | Georgia | 2109 | 6 | |
363993 | 363993 | 2020-07-24 | Unknown | Guam | 1306 | 6 | |
364130 | 364130 | 2020-07-24 | Unknown | Illinois | 1209 | 192 | |
364322 | 364322 | 2020-07-24 | Unknown | Iowa | 3 | 0 | |
364613 | 364613 | 2020-07-24 | Unknown | Louisiana | 122 | 112 | |
364635 | 364635 | 2020-07-24 | Unknown | Maine | 2 | 0 | |
364660 | 364660 | 2020-07-24 | Unknown | Maryland | 0 | 13 | |
364677 | 364677 | 2020-07-24 | Unknown | Massachusetts | 328 | 6 | |
364758 | 364758 | 2020-07-24 | Unknown | Michigan | 139 | 2 | |
364840 | 364840 | 2020-07-24 | Unknown | Minnesota | 182 | 40 | |
365176 | 365176 | 2020-07-24 | Unknown | Nebraska | 81 | 0 | |
365228 | 365228 | 2020-07-24 | Unknown | New Jersey | 675 | 0 | |
365468 | 365468 | 2020-07-24 | Unknown | North Dakota | 4 | 4 | |
365813 | 365813 | 2020-07-24 | Unknown | Puerto Rico | 827 | 191 | |
365825 | 365825 | 2020-07-24 | Unknown | Rhode Island | 1611 | 15 | |
366025 | 366025 | 2020-07-24 | Unknown | Tennessee | 293 | 1 |
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);