ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

779 rows where county = "Unknown" and state = "Minnesota" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

state 1

  • Minnesota · 779 ✖

fips 1

  • - 779

county 1

  • Unknown · 779 ✖
Link rowid date ▲ county state fips cases deaths
2500983 2500983 2022-05-13 Unknown Minnesota   1129 290
2497725 2497725 2022-05-12 Unknown Minnesota   1129 290
2494467 2494467 2022-05-11 Unknown Minnesota   1128 290
2491209 2491209 2022-05-10 Unknown Minnesota   1187 280
2487952 2487952 2022-05-09 Unknown Minnesota   1098 280
2484694 2484694 2022-05-08 Unknown Minnesota   1092 280
2481436 2481436 2022-05-07 Unknown Minnesota   1092 280
2478178 2478178 2022-05-06 Unknown Minnesota   1092 280
2474920 2474920 2022-05-05 Unknown Minnesota   1089 280
2471663 2471663 2022-05-04 Unknown Minnesota   1083 280
2468407 2468407 2022-05-03 Unknown Minnesota   1083 270
2465152 2465152 2022-05-02 Unknown Minnesota   1077 270
2461896 2461896 2022-05-01 Unknown Minnesota   1074 270
2458640 2458640 2022-04-30 Unknown Minnesota   1074 270
2455384 2455384 2022-04-29 Unknown Minnesota   1074 270
2452128 2452128 2022-04-28 Unknown Minnesota   1076 270
2448872 2448872 2022-04-27 Unknown Minnesota   1071 270
2445616 2445616 2022-04-26 Unknown Minnesota   1054 260
2442360 2442360 2022-04-25 Unknown Minnesota   1053 260
2439104 2439104 2022-04-24 Unknown Minnesota   1051 260
2435848 2435848 2022-04-23 Unknown Minnesota   1051 260
2432592 2432592 2022-04-22 Unknown Minnesota   1051 260
2429336 2429336 2022-04-21 Unknown Minnesota   1049 260
2426080 2426080 2022-04-20 Unknown Minnesota   1048 260
2422824 2422824 2022-04-19 Unknown Minnesota   1045 250
2419568 2419568 2022-04-18 Unknown Minnesota   1034 250
2416312 2416312 2022-04-17 Unknown Minnesota   1038 250
2413056 2413056 2022-04-16 Unknown Minnesota   1038 250
2409800 2409800 2022-04-15 Unknown Minnesota   1038 250
2406544 2406544 2022-04-14 Unknown Minnesota   1032 250
2403288 2403288 2022-04-13 Unknown Minnesota   1021 240
2400034 2400034 2022-04-12 Unknown Minnesota   1026 240
2396778 2396778 2022-04-11 Unknown Minnesota   1022 240
2393523 2393523 2022-04-10 Unknown Minnesota   1023 240
2390267 2390267 2022-04-09 Unknown Minnesota   1023 240
2387011 2387011 2022-04-08 Unknown Minnesota   1023 240
2383756 2383756 2022-04-07 Unknown Minnesota   1024 240
2380501 2380501 2022-04-06 Unknown Minnesota   1025 240
2377246 2377246 2022-04-05 Unknown Minnesota   1017 230
2373994 2373994 2022-04-04 Unknown Minnesota   1011 230
2370741 2370741 2022-04-03 Unknown Minnesota   1009 230
2367488 2367488 2022-04-02 Unknown Minnesota   1009 230
2364235 2364235 2022-04-01 Unknown Minnesota   1009 230
2360981 2360981 2022-03-31 Unknown Minnesota   1009 230
2357727 2357727 2022-03-30 Unknown Minnesota   1008 220
2354474 2354474 2022-03-29 Unknown Minnesota   1013 220
2351222 2351222 2022-03-28 Unknown Minnesota   1000 220
2347969 2347969 2022-03-27 Unknown Minnesota   1000 220
2344716 2344716 2022-03-26 Unknown Minnesota   1000 220
2341463 2341463 2022-03-25 Unknown Minnesota   1000 220
2338210 2338210 2022-03-24 Unknown Minnesota   997 220
2334956 2334956 2022-03-23 Unknown Minnesota   996 220
2331702 2331702 2022-03-22 Unknown Minnesota   1060 210
2328450 2328450 2022-03-21 Unknown Minnesota   1064 210
2325197 2325197 2022-03-20 Unknown Minnesota   1062 210
2321943 2321943 2022-03-19 Unknown Minnesota   1062 210
2318689 2318689 2022-03-18 Unknown Minnesota   1062 210
2315436 2315436 2022-03-17 Unknown Minnesota   1063 210
2312183 2312183 2022-03-16 Unknown Minnesota   1057 210
2308930 2308930 2022-03-15 Unknown Minnesota   1094 200
2305679 2305679 2022-03-14 Unknown Minnesota   1291 200
2302427 2302427 2022-03-13 Unknown Minnesota   1397 200
2299175 2299175 2022-03-12 Unknown Minnesota   1397 200
2295923 2295923 2022-03-11 Unknown Minnesota   1397 200
2292671 2292671 2022-03-10 Unknown Minnesota   5839 200
2289419 2289419 2022-03-09 Unknown Minnesota   5962 190
2286168 2286168 2022-03-08 Unknown Minnesota   5957 190
2282916 2282916 2022-03-07 Unknown Minnesota   6019 190
2279663 2279663 2022-03-06 Unknown Minnesota   6209 190
2276410 2276410 2022-03-05 Unknown Minnesota   6209 190
2273157 2273157 2022-03-04 Unknown Minnesota   6209 190
2269905 2269905 2022-03-03 Unknown Minnesota   6406 190
2266652 2266652 2022-03-02 Unknown Minnesota   6394 180
2263401 2263401 2022-03-01 Unknown Minnesota   6400 180
2260150 2260150 2022-02-28 Unknown Minnesota   6396 180
2256899 2256899 2022-02-27 Unknown Minnesota   6445 180
2253648 2253648 2022-02-26 Unknown Minnesota   6445 180
2250397 2250397 2022-02-25 Unknown Minnesota   6445 180
2247146 2247146 2022-02-24 Unknown Minnesota   6558 180
2243895 2243895 2022-02-23 Unknown Minnesota   6625 170
2240644 2240644 2022-02-22 Unknown Minnesota   6779 170
2237393 2237393 2022-02-21 Unknown Minnesota   6791 170
2234142 2234142 2022-02-20 Unknown Minnesota   6791 170
2230891 2230891 2022-02-19 Unknown Minnesota   6791 170
2227640 2227640 2022-02-18 Unknown Minnesota   6791 170
2224389 2224389 2022-02-17 Unknown Minnesota   9904 170
2221138 2221138 2022-02-16 Unknown Minnesota   9389 160
2217887 2217887 2022-02-15 Unknown Minnesota   9236 160
2214636 2214636 2022-02-14 Unknown Minnesota   8034 160
2211384 2211384 2022-02-13 Unknown Minnesota   9368 160
2208131 2208131 2022-02-12 Unknown Minnesota   9368 160
2204878 2204878 2022-02-11 Unknown Minnesota   9368 160
2201625 2201625 2022-02-10 Unknown Minnesota   7842 160
2198371 2198371 2022-02-09 Unknown Minnesota   7645 150
2195117 2195117 2022-02-08 Unknown Minnesota   9574 150
2191863 2191863 2022-02-07 Unknown Minnesota   8287 150
2188610 2188610 2022-02-06 Unknown Minnesota   8668 150
2185357 2185357 2022-02-05 Unknown Minnesota   8668 150
2182105 2182105 2022-02-04 Unknown Minnesota   8668 150
2178853 2178853 2022-02-03 Unknown Minnesota   7666 150

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);