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

380 rows where county = "Unknown" and state = "Northern Mariana Islands" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Northern Mariana Islands · 380 ✖

fips 1

  • - 380

county 1

  • Unknown · 380 ✖
Link rowid date ▲ county state fips cases deaths
2501643 2501643 2022-05-13 Unknown Northern Mariana Islands   152 1
2498385 2498385 2022-05-12 Unknown Northern Mariana Islands   152 1
2495127 2495127 2022-05-11 Unknown Northern Mariana Islands   152 1
2491869 2491869 2022-05-10 Unknown Northern Mariana Islands   152 1
2488611 2488611 2022-05-09 Unknown Northern Mariana Islands   152 1
2485354 2485354 2022-05-08 Unknown Northern Mariana Islands   128 1
2482096 2482096 2022-05-07 Unknown Northern Mariana Islands   128 1
2478838 2478838 2022-05-06 Unknown Northern Mariana Islands   128 1
2475580 2475580 2022-05-05 Unknown Northern Mariana Islands   128 1
2472323 2472323 2022-05-04 Unknown Northern Mariana Islands   110 1
2469067 2469067 2022-05-03 Unknown Northern Mariana Islands   110 1
2465811 2465811 2022-05-02 Unknown Northern Mariana Islands   110 1
2462556 2462556 2022-05-01 Unknown Northern Mariana Islands   110 1
2459300 2459300 2022-04-30 Unknown Northern Mariana Islands   110 1
2456044 2456044 2022-04-29 Unknown Northern Mariana Islands   110 1
2452788 2452788 2022-04-28 Unknown Northern Mariana Islands   110 1
2449532 2449532 2022-04-27 Unknown Northern Mariana Islands   110 1
2446275 2446275 2022-04-26 Unknown Northern Mariana Islands   110 1
2443020 2443020 2022-04-25 Unknown Northern Mariana Islands   68 1
2439764 2439764 2022-04-24 Unknown Northern Mariana Islands   68 1
2436508 2436508 2022-04-23 Unknown Northern Mariana Islands   68 1
2433252 2433252 2022-04-22 Unknown Northern Mariana Islands   68 1
2429996 2429996 2022-04-21 Unknown Northern Mariana Islands   68 1
2426740 2426740 2022-04-20 Unknown Northern Mariana Islands   68 1
2423484 2423484 2022-04-19 Unknown Northern Mariana Islands   68 1
2420227 2420227 2022-04-18 Unknown Northern Mariana Islands   68 1
2416972 2416972 2022-04-17 Unknown Northern Mariana Islands   50 1
2413716 2413716 2022-04-16 Unknown Northern Mariana Islands   50 1
2410460 2410460 2022-04-15 Unknown Northern Mariana Islands   50 1
2407204 2407204 2022-04-14 Unknown Northern Mariana Islands   50 1
2403948 2403948 2022-04-13 Unknown Northern Mariana Islands   50 1
2400693 2400693 2022-04-12 Unknown Northern Mariana Islands   50 1
2397438 2397438 2022-04-11 Unknown Northern Mariana Islands   50 1
2394183 2394183 2022-04-10 Unknown Northern Mariana Islands   5 0
2390927 2390927 2022-04-09 Unknown Northern Mariana Islands   5 0
2387671 2387671 2022-04-08 Unknown Northern Mariana Islands   5 0
2384416 2384416 2022-04-07 Unknown Northern Mariana Islands   5 0
2381161 2381161 2022-04-06 Unknown Northern Mariana Islands   5 0
2377906 2377906 2022-04-05 Unknown Northern Mariana Islands   5 0
2361641 2361641 2022-03-31 Unknown Northern Mariana Islands   1341 3
2358387 2358387 2022-03-30 Unknown Northern Mariana Islands   1341 3
2355133 2355133 2022-03-29 Unknown Northern Mariana Islands   1341 3
2351880 2351880 2022-03-28 Unknown Northern Mariana Islands   1298 3
2348628 2348628 2022-03-27 Unknown Northern Mariana Islands   1298 3
2345375 2345375 2022-03-26 Unknown Northern Mariana Islands   1298 3
2342122 2342122 2022-03-25 Unknown Northern Mariana Islands   1298 3
2338869 2338869 2022-03-24 Unknown Northern Mariana Islands   1273 2
2335615 2335615 2022-03-23 Unknown Northern Mariana Islands   1261 1
2332361 2332361 2022-03-22 Unknown Northern Mariana Islands   1053 1
2329108 2329108 2022-03-21 Unknown Northern Mariana Islands   1010 1
2325856 2325856 2022-03-20 Unknown Northern Mariana Islands   965 1
2322603 2322603 2022-03-19 Unknown Northern Mariana Islands   965 1
2319349 2319349 2022-03-18 Unknown Northern Mariana Islands   965 1
2316095 2316095 2022-03-17 Unknown Northern Mariana Islands   910 1
2312842 2312842 2022-03-16 Unknown Northern Mariana Islands   851 1
2309589 2309589 2022-03-15 Unknown Northern Mariana Islands   811 1
2306336 2306336 2022-03-14 Unknown Northern Mariana Islands   748 1
2303085 2303085 2022-03-13 Unknown Northern Mariana Islands   655 0
2299833 2299833 2022-03-12 Unknown Northern Mariana Islands   655 0
2296581 2296581 2022-03-11 Unknown Northern Mariana Islands   655 0
2293329 2293329 2022-03-10 Unknown Northern Mariana Islands   602 0
2290077 2290077 2022-03-09 Unknown Northern Mariana Islands   560 0
2286825 2286825 2022-03-08 Unknown Northern Mariana Islands   505 0
2283573 2283573 2022-03-07 Unknown Northern Mariana Islands   350 0
2280321 2280321 2022-03-06 Unknown Northern Mariana Islands   350 0
2277068 2277068 2022-03-05 Unknown Northern Mariana Islands   350 0
2273815 2273815 2022-03-04 Unknown Northern Mariana Islands   275 0
2270562 2270562 2022-03-03 Unknown Northern Mariana Islands   198 0
2267310 2267310 2022-03-02 Unknown Northern Mariana Islands   132 0
2260807 2260807 2022-02-28 Unknown Northern Mariana Islands   63 0
2257556 2257556 2022-02-27 Unknown Northern Mariana Islands   4315 7
2254305 2254305 2022-02-26 Unknown Northern Mariana Islands   4254 6
2251054 2251054 2022-02-25 Unknown Northern Mariana Islands   4124 6
2247803 2247803 2022-02-24 Unknown Northern Mariana Islands   3985 4
2244552 2244552 2022-02-23 Unknown Northern Mariana Islands   3828 4
2241301 2241301 2022-02-22 Unknown Northern Mariana Islands   3602 4
2238050 2238050 2022-02-21 Unknown Northern Mariana Islands   3431 3
2234799 2234799 2022-02-20 Unknown Northern Mariana Islands   3364 3
2231548 2231548 2022-02-19 Unknown Northern Mariana Islands   3142 2
2228297 2228297 2022-02-18 Unknown Northern Mariana Islands   3031 2
2225046 2225046 2022-02-17 Unknown Northern Mariana Islands   2873 2
2221795 2221795 2022-02-16 Unknown Northern Mariana Islands   2647 2
2218544 2218544 2022-02-15 Unknown Northern Mariana Islands   2466 2
2215293 2215293 2022-02-14 Unknown Northern Mariana Islands   2073 0
2212042 2212042 2022-02-13 Unknown Northern Mariana Islands   2073 0
2208789 2208789 2022-02-12 Unknown Northern Mariana Islands   2073 0
2205536 2205536 2022-02-11 Unknown Northern Mariana Islands   1919 0
2202283 2202283 2022-02-10 Unknown Northern Mariana Islands   1730 0
2199029 2199029 2022-02-09 Unknown Northern Mariana Islands   1504 0
2195775 2195775 2022-02-08 Unknown Northern Mariana Islands   1283 0
2192521 2192521 2022-02-07 Unknown Northern Mariana Islands   1052 0
2189267 2189267 2022-02-06 Unknown Northern Mariana Islands   822 0
2186014 2186014 2022-02-05 Unknown Northern Mariana Islands   611 0
2182762 2182762 2022-02-04 Unknown Northern Mariana Islands   407 0
2179510 2179510 2022-02-03 Unknown Northern Mariana Islands   295 0
2176259 2176259 2022-02-02 Unknown Northern Mariana Islands   34 0
2169753 2169753 2022-01-31 Unknown Northern Mariana Islands   676 2
2166498 2166498 2022-01-30 Unknown Northern Mariana Islands   676 2
2163243 2163243 2022-01-29 Unknown Northern Mariana Islands   653 2
2159988 2159988 2022-01-28 Unknown Northern Mariana Islands   573 2

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