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 359
- New Jersey 348
- Puerto Rico 347
- Guam 345
- Massachusetts 344
- Louisiana 342
- Arkansas 340
- Georgia 339
- Vermont 337
- Minnesota 334
- Michigan 333
- Connecticut 330
- Utah 330
- Florida 327
- Delaware 317
- Maryland 316
- Iowa 298
- New Hampshire 290
- Maine 277
- North Dakota 272
- Tennessee 266
- Alaska 259
- Illinois 222
- Oklahoma 196
- Washington 170
- Nebraska 161
- Kansas 156
- Northern Mariana Islands 146
- Wisconsin 133
- Virgin Islands 131
- …
fips 1
- - 8,783
county 1
- Unknown · 8,783 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1053686 | 1053686 | 2021-02-22 | Unknown | Arkansas | 2777 | 0 | |
1053821 | 1053821 | 2021-02-22 | Unknown | Connecticut | 947 | 9 | |
1053826 | 1053826 | 2021-02-22 | Unknown | Delaware | 190 | 0 | |
1053891 | 1053891 | 2021-02-22 | Unknown | Florida | 3422 | 0 | |
1054040 | 1054040 | 2021-02-22 | Unknown | Georgia | 3941 | 10 | |
1054056 | 1054056 | 2021-02-22 | Unknown | Guam | 8696 | 131 | |
1054197 | 1054197 | 2021-02-22 | Unknown | Illinois | 0 | 192 | |
1054389 | 1054389 | 2021-02-22 | Unknown | Iowa | 2232 | 0 | |
1054499 | 1054499 | 2021-02-22 | Unknown | Kansas | 0 | 1069 | |
1054683 | 1054683 | 2021-02-22 | Unknown | Louisiana | 418 | 0 | |
1054705 | 1054705 | 2021-02-22 | Unknown | Maine | 3 | 0 | |
1054730 | 1054730 | 2021-02-22 | Unknown | Maryland | 0 | 78 | |
1054747 | 1054747 | 2021-02-22 | Unknown | Massachusetts | 31247 | 8 | |
1054828 | 1054828 | 2021-02-22 | Unknown | Michigan | 0 | 12 | |
1054911 | 1054911 | 2021-02-22 | Unknown | Minnesota | 501 | 68 | |
1055296 | 1055296 | 2021-02-22 | Unknown | New Hampshire | 1065 | 5 | |
1055317 | 1055317 | 2021-02-22 | Unknown | New Jersey | 875 | 0 | |
1055559 | 1055559 | 2021-02-22 | Unknown | North Dakota | 30 | 30 | |
1055726 | 1055726 | 2021-02-22 | Unknown | Oklahoma | 1 | 0 | |
1055906 | 1055906 | 2021-02-22 | Unknown | Puerto Rico | 4418 | 1983 | |
1055918 | 1055918 | 2021-02-22 | Unknown | Rhode Island | 12345 | 152 | |
1056119 | 1056119 | 2021-02-22 | Unknown | Tennessee | 8381 | 110 | |
1056406 | 1056406 | 2021-02-22 | Unknown | Utah | 1214 | 2 | |
1056423 | 1056423 | 2021-02-22 | Unknown | Vermont | 8 | 0 | |
1050349 | 1050349 | 2021-02-21 | Unknown | Alaska | 253 | 0 | |
1050439 | 1050439 | 2021-02-21 | Unknown | Arkansas | 2807 | 0 | |
1050574 | 1050574 | 2021-02-21 | Unknown | Connecticut | 937 | 9 | |
1050579 | 1050579 | 2021-02-21 | Unknown | Delaware | 190 | 0 | |
1050644 | 1050644 | 2021-02-21 | Unknown | Florida | 3418 | 0 | |
1050793 | 1050793 | 2021-02-21 | Unknown | Georgia | 3954 | 10 | |
1050809 | 1050809 | 2021-02-21 | Unknown | Guam | 8689 | 131 | |
1050950 | 1050950 | 2021-02-21 | Unknown | Illinois | 0 | 186 | |
1051142 | 1051142 | 2021-02-21 | Unknown | Iowa | 1785 | 0 | |
1051252 | 1051252 | 2021-02-21 | Unknown | Kansas | 0 | 1072 | |
1051436 | 1051436 | 2021-02-21 | Unknown | Louisiana | 416 | 0 | |
1051458 | 1051458 | 2021-02-21 | Unknown | Maine | 3 | 0 | |
1051483 | 1051483 | 2021-02-21 | Unknown | Maryland | 0 | 69 | |
1051500 | 1051500 | 2021-02-21 | Unknown | Massachusetts | 31135 | 8 | |
1051581 | 1051581 | 2021-02-21 | Unknown | Michigan | 0 | 12 | |
1051664 | 1051664 | 2021-02-21 | Unknown | Minnesota | 497 | 68 | |
1052049 | 1052049 | 2021-02-21 | Unknown | New Hampshire | 1051 | 5 | |
1052070 | 1052070 | 2021-02-21 | Unknown | New Jersey | 866 | 0 | |
1052104 | 1052104 | 2021-02-21 | Unknown | New Mexico | 14 | 0 | |
1052313 | 1052313 | 2021-02-21 | Unknown | North Dakota | 30 | 30 | |
1052480 | 1052480 | 2021-02-21 | Unknown | Oklahoma | 1 | 0 | |
1052660 | 1052660 | 2021-02-21 | Unknown | Puerto Rico | 4411 | 1979 | |
1052672 | 1052672 | 2021-02-21 | Unknown | Rhode Island | 11510 | 62 | |
1052873 | 1052873 | 2021-02-21 | Unknown | Tennessee | 8407 | 114 | |
1053160 | 1053160 | 2021-02-21 | Unknown | Utah | 1417 | 4 | |
1053177 | 1053177 | 2021-02-21 | Unknown | Vermont | 8 | 0 | |
1047102 | 1047102 | 2021-02-20 | Unknown | Alaska | 253 | 0 | |
1047192 | 1047192 | 2021-02-20 | Unknown | Arkansas | 2819 | 0 | |
1047327 | 1047327 | 2021-02-20 | Unknown | Connecticut | 937 | 9 | |
1047332 | 1047332 | 2021-02-20 | Unknown | Delaware | 189 | 0 | |
1047397 | 1047397 | 2021-02-20 | Unknown | Florida | 3415 | 0 | |
1047546 | 1047546 | 2021-02-20 | Unknown | Georgia | 3965 | 10 | |
1047562 | 1047562 | 2021-02-20 | Unknown | Guam | 8685 | 131 | |
1047703 | 1047703 | 2021-02-20 | Unknown | Illinois | 0 | 181 | |
1047895 | 1047895 | 2021-02-20 | Unknown | Iowa | 1370 | 0 | |
1048005 | 1048005 | 2021-02-20 | Unknown | Kansas | 0 | 1072 | |
1048189 | 1048189 | 2021-02-20 | Unknown | Louisiana | 412 | 0 | |
1048211 | 1048211 | 2021-02-20 | Unknown | Maine | 2 | 0 | |
1048236 | 1048236 | 2021-02-20 | Unknown | Maryland | 0 | 56 | |
1048253 | 1048253 | 2021-02-20 | Unknown | Massachusetts | 30920 | 8 | |
1048334 | 1048334 | 2021-02-20 | Unknown | Michigan | 0 | 12 | |
1048417 | 1048417 | 2021-02-20 | Unknown | Minnesota | 500 | 68 | |
1048802 | 1048802 | 2021-02-20 | Unknown | New Hampshire | 1060 | 5 | |
1048823 | 1048823 | 2021-02-20 | Unknown | New Jersey | 851 | 0 | |
1048857 | 1048857 | 2021-02-20 | Unknown | New Mexico | 7 | 0 | |
1049066 | 1049066 | 2021-02-20 | Unknown | North Dakota | 30 | 30 | |
1049233 | 1049233 | 2021-02-20 | Unknown | Oklahoma | 11 | 0 | |
1049413 | 1049413 | 2021-02-20 | Unknown | Puerto Rico | 4400 | 1957 | |
1049425 | 1049425 | 2021-02-20 | Unknown | Rhode Island | 11510 | 62 | |
1049626 | 1049626 | 2021-02-20 | Unknown | Tennessee | 8396 | 116 | |
1049913 | 1049913 | 2021-02-20 | Unknown | Utah | 1300 | 2 | |
1049930 | 1049930 | 2021-02-20 | Unknown | Vermont | 9 | 0 | |
1043857 | 1043857 | 2021-02-19 | Unknown | Alaska | 253 | 0 | |
1043947 | 1043947 | 2021-02-19 | Unknown | Arkansas | 2817 | 0 | |
1044082 | 1044082 | 2021-02-19 | Unknown | Connecticut | 937 | 9 | |
1044087 | 1044087 | 2021-02-19 | Unknown | Delaware | 188 | 0 | |
1044152 | 1044152 | 2021-02-19 | Unknown | Florida | 3406 | 0 | |
1044301 | 1044301 | 2021-02-19 | Unknown | Georgia | 3933 | 11 | |
1044317 | 1044317 | 2021-02-19 | Unknown | Guam | 8684 | 131 | |
1044458 | 1044458 | 2021-02-19 | Unknown | Illinois | 0 | 166 | |
1044650 | 1044650 | 2021-02-19 | Unknown | Iowa | 892 | 0 | |
1044760 | 1044760 | 2021-02-19 | Unknown | Kansas | 0 | 1086 | |
1044944 | 1044944 | 2021-02-19 | Unknown | Louisiana | 412 | 0 | |
1044990 | 1044990 | 2021-02-19 | Unknown | Maryland | 0 | 49 | |
1045007 | 1045007 | 2021-02-19 | Unknown | Massachusetts | 30772 | 8 | |
1045088 | 1045088 | 2021-02-19 | Unknown | Michigan | 0 | 13 | |
1045171 | 1045171 | 2021-02-19 | Unknown | Minnesota | 506 | 68 | |
1045556 | 1045556 | 2021-02-19 | Unknown | New Hampshire | 1045 | 5 | |
1045577 | 1045577 | 2021-02-19 | Unknown | New Jersey | 849 | 0 | |
1045819 | 1045819 | 2021-02-19 | Unknown | North Dakota | 30 | 30 | |
1045986 | 1045986 | 2021-02-19 | Unknown | Oklahoma | 4 | 0 | |
1046166 | 1046166 | 2021-02-19 | Unknown | Puerto Rico | 4398 | 1947 | |
1046178 | 1046178 | 2021-02-19 | Unknown | Rhode Island | 11510 | 62 | |
1046379 | 1046379 | 2021-02-19 | Unknown | Tennessee | 8450 | 113 | |
1046666 | 1046666 | 2021-02-19 | Unknown | Utah | 1071 | 4 | |
1046683 | 1046683 | 2021-02-19 | Unknown | Vermont | 8 | 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);