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 367
- New Jersey 356
- Puerto Rico 355
- Guam 353
- Massachusetts 352
- Louisiana 350
- Arkansas 348
- Georgia 347
- Vermont 345
- Minnesota 342
- Michigan 341
- Connecticut 338
- Utah 338
- Florida 335
- Delaware 325
- Maryland 324
- Iowa 306
- New Hampshire 298
- Maine 280
- North Dakota 280
- Tennessee 274
- Alaska 267
- Illinois 230
- Oklahoma 203
- Washington 170
- Kansas 164
- Nebraska 161
- Northern Mariana Islands 146
- Wisconsin 133
- Virgin Islands 131
- …
fips 1
- - 8,979
county 1
- Unknown · 8,979 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1079650 | 1079650 | 2021-03-02 | Unknown | Arkansas | 3296 | 0 | |
1079785 | 1079785 | 2021-03-02 | Unknown | Connecticut | 974 | 10 | |
1079790 | 1079790 | 2021-03-02 | Unknown | Delaware | 195 | 0 | |
1079855 | 1079855 | 2021-03-02 | Unknown | Florida | 3481 | 0 | |
1080004 | 1080004 | 2021-03-02 | Unknown | Georgia | 3572 | 12 | |
1080020 | 1080020 | 2021-03-02 | Unknown | Guam | 8711 | 132 | |
1080161 | 1080161 | 2021-03-02 | Unknown | Illinois | 0 | 202 | |
1080353 | 1080353 | 2021-03-02 | Unknown | Iowa | 1496 | 0 | |
1080463 | 1080463 | 2021-03-02 | Unknown | Kansas | 0 | 1050 | |
1080647 | 1080647 | 2021-03-02 | Unknown | Louisiana | 423 | 0 | |
1080669 | 1080669 | 2021-03-02 | Unknown | Maine | 1 | 0 | |
1080694 | 1080694 | 2021-03-02 | Unknown | Maryland | 0 | 65 | |
1080711 | 1080711 | 2021-03-02 | Unknown | Massachusetts | 32661 | 8 | |
1080792 | 1080792 | 2021-03-02 | Unknown | Michigan | 0 | 12 | |
1080875 | 1080875 | 2021-03-02 | Unknown | Minnesota | 535 | 68 | |
1081260 | 1081260 | 2021-03-02 | Unknown | New Hampshire | 1075 | 5 | |
1081281 | 1081281 | 2021-03-02 | Unknown | New Jersey | 1037 | 0 | |
1081523 | 1081523 | 2021-03-02 | Unknown | North Dakota | 30 | 30 | |
1081690 | 1081690 | 2021-03-02 | Unknown | Oklahoma | 2 | 0 | |
1081870 | 1081870 | 2021-03-02 | Unknown | Puerto Rico | 4417 | 2040 | |
1081882 | 1081882 | 2021-03-02 | Unknown | Rhode Island | 13155 | 76 | |
1082083 | 1082083 | 2021-03-02 | Unknown | Tennessee | 8405 | 114 | |
1082370 | 1082370 | 2021-03-02 | Unknown | Utah | 1256 | 2 | |
1082387 | 1082387 | 2021-03-02 | Unknown | Vermont | 8 | 0 | |
1076315 | 1076315 | 2021-03-01 | Unknown | Alaska | 256 | 0 | |
1076405 | 1076405 | 2021-03-01 | Unknown | Arkansas | 3290 | 0 | |
1076540 | 1076540 | 2021-03-01 | Unknown | Connecticut | 973 | 10 | |
1076545 | 1076545 | 2021-03-01 | Unknown | Delaware | 194 | 0 | |
1076610 | 1076610 | 2021-03-01 | Unknown | Florida | 3469 | 0 | |
1076759 | 1076759 | 2021-03-01 | Unknown | Georgia | 3598 | 12 | |
1076775 | 1076775 | 2021-03-01 | Unknown | Guam | 8706 | 132 | |
1076916 | 1076916 | 2021-03-01 | Unknown | Illinois | 0 | 206 | |
1077108 | 1077108 | 2021-03-01 | Unknown | Iowa | 1538 | 0 | |
1077218 | 1077218 | 2021-03-01 | Unknown | Kansas | 0 | 1063 | |
1077402 | 1077402 | 2021-03-01 | Unknown | Louisiana | 427 | 0 | |
1077448 | 1077448 | 2021-03-01 | Unknown | Maryland | 0 | 62 | |
1077465 | 1077465 | 2021-03-01 | Unknown | Massachusetts | 32486 | 8 | |
1077546 | 1077546 | 2021-03-01 | Unknown | Michigan | 0 | 12 | |
1077629 | 1077629 | 2021-03-01 | Unknown | Minnesota | 547 | 68 | |
1078014 | 1078014 | 2021-03-01 | Unknown | New Hampshire | 1057 | 5 | |
1078035 | 1078035 | 2021-03-01 | Unknown | New Jersey | 1026 | 0 | |
1078277 | 1078277 | 2021-03-01 | Unknown | North Dakota | 30 | 30 | |
1078444 | 1078444 | 2021-03-01 | Unknown | Oklahoma | 2 | 0 | |
1078624 | 1078624 | 2021-03-01 | Unknown | Puerto Rico | 4421 | 2037 | |
1078636 | 1078636 | 2021-03-01 | Unknown | Rhode Island | 12894 | 68 | |
1078837 | 1078837 | 2021-03-01 | Unknown | Tennessee | 8425 | 115 | |
1079124 | 1079124 | 2021-03-01 | Unknown | Utah | 1210 | 2 | |
1079141 | 1079141 | 2021-03-01 | Unknown | Vermont | 9 | 0 | |
1073069 | 1073069 | 2021-02-28 | Unknown | Alaska | 259 | 0 | |
1073159 | 1073159 | 2021-02-28 | Unknown | Arkansas | 3416 | 0 | |
1073294 | 1073294 | 2021-02-28 | Unknown | Connecticut | 973 | 10 | |
1073299 | 1073299 | 2021-02-28 | Unknown | Delaware | 194 | 0 | |
1073364 | 1073364 | 2021-02-28 | Unknown | Florida | 3469 | 0 | |
1073513 | 1073513 | 2021-02-28 | Unknown | Georgia | 3614 | 12 | |
1073529 | 1073529 | 2021-02-28 | Unknown | Guam | 8705 | 132 | |
1073670 | 1073670 | 2021-02-28 | Unknown | Illinois | 0 | 208 | |
1073862 | 1073862 | 2021-02-28 | Unknown | Iowa | 1991 | 0 | |
1073972 | 1073972 | 2021-02-28 | Unknown | Kansas | 0 | 1062 | |
1074156 | 1074156 | 2021-02-28 | Unknown | Louisiana | 429 | 0 | |
1074202 | 1074202 | 2021-02-28 | Unknown | Maryland | 0 | 53 | |
1074219 | 1074219 | 2021-02-28 | Unknown | Massachusetts | 32332 | 8 | |
1074300 | 1074300 | 2021-02-28 | Unknown | Michigan | 0 | 12 | |
1074383 | 1074383 | 2021-02-28 | Unknown | Minnesota | 552 | 68 | |
1074768 | 1074768 | 2021-02-28 | Unknown | New Hampshire | 1050 | 5 | |
1074789 | 1074789 | 2021-02-28 | Unknown | New Jersey | 1132 | 0 | |
1074823 | 1074823 | 2021-02-28 | Unknown | New Mexico | 6 | 14 | |
1075032 | 1075032 | 2021-02-28 | Unknown | North Dakota | 30 | 30 | |
1075199 | 1075199 | 2021-02-28 | Unknown | Oklahoma | 1 | 0 | |
1075379 | 1075379 | 2021-02-28 | Unknown | Puerto Rico | 4424 | 2036 | |
1075391 | 1075391 | 2021-02-28 | Unknown | Rhode Island | 11928 | 53 | |
1075592 | 1075592 | 2021-02-28 | Unknown | Tennessee | 8410 | 115 | |
1075879 | 1075879 | 2021-02-28 | Unknown | Utah | 1359 | 11 | |
1075896 | 1075896 | 2021-02-28 | Unknown | Vermont | 8 | 0 | |
1069823 | 1069823 | 2021-02-27 | Unknown | Alaska | 259 | 0 | |
1069913 | 1069913 | 2021-02-27 | Unknown | Arkansas | 2761 | 0 | |
1070048 | 1070048 | 2021-02-27 | Unknown | Connecticut | 973 | 10 | |
1070053 | 1070053 | 2021-02-27 | Unknown | Delaware | 194 | 0 | |
1070118 | 1070118 | 2021-02-27 | Unknown | Florida | 3464 | 0 | |
1070267 | 1070267 | 2021-02-27 | Unknown | Georgia | 3611 | 12 | |
1070283 | 1070283 | 2021-02-27 | Unknown | Guam | 8704 | 131 | |
1070424 | 1070424 | 2021-02-27 | Unknown | Illinois | 0 | 205 | |
1070616 | 1070616 | 2021-02-27 | Unknown | Iowa | 1806 | 0 | |
1070726 | 1070726 | 2021-02-27 | Unknown | Kansas | 0 | 1062 | |
1070910 | 1070910 | 2021-02-27 | Unknown | Louisiana | 427 | 0 | |
1070956 | 1070956 | 2021-02-27 | Unknown | Maryland | 0 | 50 | |
1070973 | 1070973 | 2021-02-27 | Unknown | Massachusetts | 32294 | 8 | |
1071054 | 1071054 | 2021-02-27 | Unknown | Michigan | 0 | 12 | |
1071137 | 1071137 | 2021-02-27 | Unknown | Minnesota | 513 | 68 | |
1071522 | 1071522 | 2021-02-27 | Unknown | New Hampshire | 1047 | 5 | |
1071543 | 1071543 | 2021-02-27 | Unknown | New Jersey | 1104 | 0 | |
1071577 | 1071577 | 2021-02-27 | Unknown | New Mexico | 5 | 0 | |
1071786 | 1071786 | 2021-02-27 | Unknown | North Dakota | 30 | 30 | |
1071953 | 1071953 | 2021-02-27 | Unknown | Oklahoma | 2 | 0 | |
1072133 | 1072133 | 2021-02-27 | Unknown | Puerto Rico | 4422 | 2032 | |
1072145 | 1072145 | 2021-02-27 | Unknown | Rhode Island | 11928 | 53 | |
1072346 | 1072346 | 2021-02-27 | Unknown | Tennessee | 8430 | 115 | |
1072633 | 1072633 | 2021-02-27 | Unknown | Utah | 1279 | 10 | |
1072650 | 1072650 | 2021-02-27 | Unknown | Vermont | 8 | 0 | |
1066578 | 1066578 | 2021-02-26 | Unknown | Alaska | 259 | 0 | |
1066668 | 1066668 | 2021-02-26 | Unknown | Arkansas | 2740 | 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);