ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,204 rows where county = "Unknown" and deaths = 1 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- New Hampshire 219
- Alaska 207
- Connecticut 199
- Utah 115
- Northern Mariana Islands 62
- Oklahoma 49
- Ohio 40
- Virgin Islands 33
- Tennessee 32
- Vermont 29
- Iowa 27
- Colorado 24
- Georgia 24
- Hawaii 18
- Delaware 15
- Louisiana 13
- Michigan 11
- Guam 9
- Maine 9
- Arizona 7
- Kansas 7
- Minnesota 7
- Arkansas 6
- New Jersey 6
- Virginia 6
- Kentucky 4
- Nebraska 4
- Illinois 3
- New Mexico 3
- California 2
- …
fips 1
- - 1,204
county 1
- Unknown · 1,204 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499665 | 2499665 | 2022-05-13 | Unknown | Alaska | 958 | 1 | |
2499891 | 2499891 | 2022-05-13 | Unknown | Connecticut | 2397 | 1 | |
2500461 | 2500461 | 2022-05-13 | Unknown | Iowa | 515 | 1 | |
2501643 | 2501643 | 2022-05-13 | Unknown | Northern Mariana Islands | 152 | 1 | |
2496407 | 2496407 | 2022-05-12 | Unknown | Alaska | 958 | 1 | |
2496633 | 2496633 | 2022-05-12 | Unknown | Connecticut | 2375 | 1 | |
2497203 | 2497203 | 2022-05-12 | Unknown | Iowa | 515 | 1 | |
2498385 | 2498385 | 2022-05-12 | Unknown | Northern Mariana Islands | 152 | 1 | |
2493149 | 2493149 | 2022-05-11 | Unknown | Alaska | 958 | 1 | |
2493375 | 2493375 | 2022-05-11 | Unknown | Connecticut | 2368 | 1 | |
2493945 | 2493945 | 2022-05-11 | Unknown | Iowa | 4 | 1 | |
2495127 | 2495127 | 2022-05-11 | Unknown | Northern Mariana Islands | 152 | 1 | |
2489891 | 2489891 | 2022-05-10 | Unknown | Alaska | 914 | 1 | |
2490117 | 2490117 | 2022-05-10 | Unknown | Connecticut | 2347 | 1 | |
2491869 | 2491869 | 2022-05-10 | Unknown | Northern Mariana Islands | 152 | 1 | |
2486634 | 2486634 | 2022-05-09 | Unknown | Alaska | 914 | 1 | |
2486860 | 2486860 | 2022-05-09 | Unknown | Connecticut | 2338 | 1 | |
2488611 | 2488611 | 2022-05-09 | Unknown | Northern Mariana Islands | 152 | 1 | |
2483376 | 2483376 | 2022-05-08 | Unknown | Alaska | 914 | 1 | |
2483602 | 2483602 | 2022-05-08 | Unknown | Connecticut | 2320 | 1 | |
2485354 | 2485354 | 2022-05-08 | Unknown | Northern Mariana Islands | 128 | 1 | |
2480118 | 2480118 | 2022-05-07 | Unknown | Alaska | 914 | 1 | |
2480344 | 2480344 | 2022-05-07 | Unknown | Connecticut | 2320 | 1 | |
2482096 | 2482096 | 2022-05-07 | Unknown | Northern Mariana Islands | 128 | 1 | |
2476860 | 2476860 | 2022-05-06 | Unknown | Alaska | 914 | 1 | |
2477086 | 2477086 | 2022-05-06 | Unknown | Connecticut | 2320 | 1 | |
2478838 | 2478838 | 2022-05-06 | Unknown | Northern Mariana Islands | 128 | 1 | |
2473602 | 2473602 | 2022-05-05 | Unknown | Alaska | 914 | 1 | |
2473828 | 2473828 | 2022-05-05 | Unknown | Connecticut | 2310 | 1 | |
2475580 | 2475580 | 2022-05-05 | Unknown | Northern Mariana Islands | 128 | 1 | |
2470345 | 2470345 | 2022-05-04 | Unknown | Alaska | 914 | 1 | |
2470571 | 2470571 | 2022-05-04 | Unknown | Connecticut | 2301 | 1 | |
2472323 | 2472323 | 2022-05-04 | Unknown | Northern Mariana Islands | 110 | 1 | |
2473182 | 2473182 | 2022-05-04 | Unknown | Vermont | 1335 | 1 | |
2467089 | 2467089 | 2022-05-03 | Unknown | Alaska | 917 | 1 | |
2467315 | 2467315 | 2022-05-03 | Unknown | Connecticut | 2295 | 1 | |
2469067 | 2469067 | 2022-05-03 | Unknown | Northern Mariana Islands | 110 | 1 | |
2469926 | 2469926 | 2022-05-03 | Unknown | Vermont | 1306 | 1 | |
2463834 | 2463834 | 2022-05-02 | Unknown | Alaska | 917 | 1 | |
2465811 | 2465811 | 2022-05-02 | Unknown | Northern Mariana Islands | 110 | 1 | |
2466670 | 2466670 | 2022-05-02 | Unknown | Vermont | 1290 | 1 | |
2460578 | 2460578 | 2022-05-01 | Unknown | Alaska | 917 | 1 | |
2462556 | 2462556 | 2022-05-01 | Unknown | Northern Mariana Islands | 110 | 1 | |
2463415 | 2463415 | 2022-05-01 | Unknown | Vermont | 1252 | 1 | |
2457322 | 2457322 | 2022-04-30 | Unknown | Alaska | 917 | 1 | |
2459300 | 2459300 | 2022-04-30 | Unknown | Northern Mariana Islands | 110 | 1 | |
2460159 | 2460159 | 2022-04-30 | Unknown | Vermont | 1252 | 1 | |
2454066 | 2454066 | 2022-04-29 | Unknown | Alaska | 917 | 1 | |
2456044 | 2456044 | 2022-04-29 | Unknown | Northern Mariana Islands | 110 | 1 | |
2456903 | 2456903 | 2022-04-29 | Unknown | Vermont | 1252 | 1 | |
2450810 | 2450810 | 2022-04-28 | Unknown | Alaska | 917 | 1 | |
2451036 | 2451036 | 2022-04-28 | Unknown | Connecticut | 2275 | 1 | |
2452788 | 2452788 | 2022-04-28 | Unknown | Northern Mariana Islands | 110 | 1 | |
2453647 | 2453647 | 2022-04-28 | Unknown | Vermont | 1219 | 1 | |
2447554 | 2447554 | 2022-04-27 | Unknown | Alaska | 917 | 1 | |
2447780 | 2447780 | 2022-04-27 | Unknown | Connecticut | 2270 | 1 | |
2449532 | 2449532 | 2022-04-27 | Unknown | Northern Mariana Islands | 110 | 1 | |
2444298 | 2444298 | 2022-04-26 | Unknown | Alaska | 913 | 1 | |
2444524 | 2444524 | 2022-04-26 | Unknown | Connecticut | 2266 | 1 | |
2446275 | 2446275 | 2022-04-26 | Unknown | Northern Mariana Islands | 110 | 1 | |
2447134 | 2447134 | 2022-04-26 | Unknown | Vermont | 1206 | 1 | |
2441042 | 2441042 | 2022-04-25 | Unknown | Alaska | 913 | 1 | |
2441268 | 2441268 | 2022-04-25 | Unknown | Connecticut | 2260 | 1 | |
2443020 | 2443020 | 2022-04-25 | Unknown | Northern Mariana Islands | 68 | 1 | |
2443879 | 2443879 | 2022-04-25 | Unknown | Vermont | 1206 | 1 | |
2437786 | 2437786 | 2022-04-24 | Unknown | Alaska | 913 | 1 | |
2438012 | 2438012 | 2022-04-24 | Unknown | Connecticut | 2246 | 1 | |
2439764 | 2439764 | 2022-04-24 | Unknown | Northern Mariana Islands | 68 | 1 | |
2440623 | 2440623 | 2022-04-24 | Unknown | Vermont | 1162 | 1 | |
2434530 | 2434530 | 2022-04-23 | Unknown | Alaska | 913 | 1 | |
2434756 | 2434756 | 2022-04-23 | Unknown | Connecticut | 2246 | 1 | |
2436508 | 2436508 | 2022-04-23 | Unknown | Northern Mariana Islands | 68 | 1 | |
2437367 | 2437367 | 2022-04-23 | Unknown | Vermont | 1162 | 1 | |
2431274 | 2431274 | 2022-04-22 | Unknown | Alaska | 913 | 1 | |
2431500 | 2431500 | 2022-04-22 | Unknown | Connecticut | 2246 | 1 | |
2433252 | 2433252 | 2022-04-22 | Unknown | Northern Mariana Islands | 68 | 1 | |
2434111 | 2434111 | 2022-04-22 | Unknown | Vermont | 1162 | 1 | |
2428018 | 2428018 | 2022-04-21 | Unknown | Alaska | 913 | 1 | |
2428244 | 2428244 | 2022-04-21 | Unknown | Connecticut | 2237 | 1 | |
2429996 | 2429996 | 2022-04-21 | Unknown | Northern Mariana Islands | 68 | 1 | |
2430855 | 2430855 | 2022-04-21 | Unknown | Vermont | 1144 | 1 | |
2424762 | 2424762 | 2022-04-20 | Unknown | Alaska | 913 | 1 | |
2424988 | 2424988 | 2022-04-20 | Unknown | Connecticut | 2231 | 1 | |
2426468 | 2426468 | 2022-04-20 | Unknown | New Hampshire | 5855 | 1 | |
2426740 | 2426740 | 2022-04-20 | Unknown | Northern Mariana Islands | 68 | 1 | |
2427599 | 2427599 | 2022-04-20 | Unknown | Vermont | 1129 | 1 | |
2421506 | 2421506 | 2022-04-19 | Unknown | Alaska | 923 | 1 | |
2421732 | 2421732 | 2022-04-19 | Unknown | Connecticut | 2223 | 1 | |
2423484 | 2423484 | 2022-04-19 | Unknown | Northern Mariana Islands | 68 | 1 | |
2424343 | 2424343 | 2022-04-19 | Unknown | Vermont | 1118 | 1 | |
2418250 | 2418250 | 2022-04-18 | Unknown | Alaska | 923 | 1 | |
2418476 | 2418476 | 2022-04-18 | Unknown | Connecticut | 2218 | 1 | |
2420227 | 2420227 | 2022-04-18 | Unknown | Northern Mariana Islands | 68 | 1 | |
2421087 | 2421087 | 2022-04-18 | Unknown | Vermont | 1114 | 1 | |
2414994 | 2414994 | 2022-04-17 | Unknown | Alaska | 923 | 1 | |
2415220 | 2415220 | 2022-04-17 | Unknown | Connecticut | 2210 | 1 | |
2416972 | 2416972 | 2022-04-17 | Unknown | Northern Mariana Islands | 50 | 1 | |
2417831 | 2417831 | 2022-04-17 | Unknown | Vermont | 1092 | 1 | |
2411738 | 2411738 | 2022-04-16 | Unknown | Alaska | 923 | 1 | |
2411964 | 2411964 | 2022-04-16 | Unknown | Connecticut | 2210 | 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);