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

669 rows where county = "Saipan" and state = "Northern Mariana Islands" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

state 1

  • Northern Mariana Islands · 669 ✖

fips 1

county 1

  • Saipan · 669 ✖
Link rowid date ▲ county state fips cases deaths
2501641 2501641 2022-05-13 Saipan Northern Mariana Islands 69110 10397 33
2498383 2498383 2022-05-12 Saipan Northern Mariana Islands 69110 10397 33
2495125 2495125 2022-05-11 Saipan Northern Mariana Islands 69110 10397 33
2491867 2491867 2022-05-10 Saipan Northern Mariana Islands 69110 10397 33
2488609 2488609 2022-05-09 Saipan Northern Mariana Islands 69110 10397 33
2485352 2485352 2022-05-08 Saipan Northern Mariana Islands 69110 10397 33
2482094 2482094 2022-05-07 Saipan Northern Mariana Islands 69110 10397 33
2478836 2478836 2022-05-06 Saipan Northern Mariana Islands 69110 10397 33
2475578 2475578 2022-05-05 Saipan Northern Mariana Islands 69110 10397 33
2472321 2472321 2022-05-04 Saipan Northern Mariana Islands 69110 10397 33
2469065 2469065 2022-05-03 Saipan Northern Mariana Islands 69110 10397 33
2465809 2465809 2022-05-02 Saipan Northern Mariana Islands 69110 10397 33
2462554 2462554 2022-05-01 Saipan Northern Mariana Islands 69110 10397 33
2459298 2459298 2022-04-30 Saipan Northern Mariana Islands 69110 10397 33
2456042 2456042 2022-04-29 Saipan Northern Mariana Islands 69110 10397 33
2452786 2452786 2022-04-28 Saipan Northern Mariana Islands 69110 10397 33
2449530 2449530 2022-04-27 Saipan Northern Mariana Islands 69110 10397 33
2446273 2446273 2022-04-26 Saipan Northern Mariana Islands 69110 10397 33
2443018 2443018 2022-04-25 Saipan Northern Mariana Islands 69110 10397 33
2439762 2439762 2022-04-24 Saipan Northern Mariana Islands 69110 10397 33
2436506 2436506 2022-04-23 Saipan Northern Mariana Islands 69110 10397 33
2433250 2433250 2022-04-22 Saipan Northern Mariana Islands 69110 10397 33
2429994 2429994 2022-04-21 Saipan Northern Mariana Islands 69110 10397 33
2426738 2426738 2022-04-20 Saipan Northern Mariana Islands 69110 10397 33
2423482 2423482 2022-04-19 Saipan Northern Mariana Islands 69110 10397 33
2420225 2420225 2022-04-18 Saipan Northern Mariana Islands 69110 10397 33
2416970 2416970 2022-04-17 Saipan Northern Mariana Islands 69110 10397 33
2413714 2413714 2022-04-16 Saipan Northern Mariana Islands 69110 10397 33
2410458 2410458 2022-04-15 Saipan Northern Mariana Islands 69110 10397 33
2407202 2407202 2022-04-14 Saipan Northern Mariana Islands 69110 10397 33
2403946 2403946 2022-04-13 Saipan Northern Mariana Islands 69110 10397 33
2400691 2400691 2022-04-12 Saipan Northern Mariana Islands 69110 10397 33
2397436 2397436 2022-04-11 Saipan Northern Mariana Islands 69110 10397 33
2394181 2394181 2022-04-10 Saipan Northern Mariana Islands 69110 10397 33
2390925 2390925 2022-04-09 Saipan Northern Mariana Islands 69110 10397 33
2387669 2387669 2022-04-08 Saipan Northern Mariana Islands 69110 10397 33
2384414 2384414 2022-04-07 Saipan Northern Mariana Islands 69110 10397 33
2381159 2381159 2022-04-06 Saipan Northern Mariana Islands 69110 10397 33
2377904 2377904 2022-04-05 Saipan Northern Mariana Islands 69110 10397 33
2374651 2374651 2022-04-04 Saipan Northern Mariana Islands 69110 10397 33
2371399 2371399 2022-04-03 Saipan Northern Mariana Islands 69110 10397 33
2368146 2368146 2022-04-02 Saipan Northern Mariana Islands 69110 10397 33
2364893 2364893 2022-04-01 Saipan Northern Mariana Islands 69110 10397 33
2361639 2361639 2022-03-31 Saipan Northern Mariana Islands 69110 9308 30
2358385 2358385 2022-03-30 Saipan Northern Mariana Islands 69110 9308 30
2355131 2355131 2022-03-29 Saipan Northern Mariana Islands 69110 9308 30
2351878 2351878 2022-03-28 Saipan Northern Mariana Islands 69110 9308 30
2348626 2348626 2022-03-27 Saipan Northern Mariana Islands 69110 9308 30
2345373 2345373 2022-03-26 Saipan Northern Mariana Islands 69110 9308 30
2342120 2342120 2022-03-25 Saipan Northern Mariana Islands 69110 9308 30
2338867 2338867 2022-03-24 Saipan Northern Mariana Islands 69110 9308 30
2335613 2335613 2022-03-23 Saipan Northern Mariana Islands 69110 9308 30
2332359 2332359 2022-03-22 Saipan Northern Mariana Islands 69110 9308 30
2329106 2329106 2022-03-21 Saipan Northern Mariana Islands 69110 9308 30
2325854 2325854 2022-03-20 Saipan Northern Mariana Islands 69110 9308 30
2322601 2322601 2022-03-19 Saipan Northern Mariana Islands 69110 9308 30
2319347 2319347 2022-03-18 Saipan Northern Mariana Islands 69110 9308 30
2316093 2316093 2022-03-17 Saipan Northern Mariana Islands 69110 9308 30
2312840 2312840 2022-03-16 Saipan Northern Mariana Islands 69110 9308 30
2309587 2309587 2022-03-15 Saipan Northern Mariana Islands 69110 9308 30
2306334 2306334 2022-03-14 Saipan Northern Mariana Islands 69110 9308 30
2303083 2303083 2022-03-13 Saipan Northern Mariana Islands 69110 9308 30
2299831 2299831 2022-03-12 Saipan Northern Mariana Islands 69110 9308 30
2296579 2296579 2022-03-11 Saipan Northern Mariana Islands 69110 9308 30
2293327 2293327 2022-03-10 Saipan Northern Mariana Islands 69110 9308 30
2290075 2290075 2022-03-09 Saipan Northern Mariana Islands 69110 9308 30
2286823 2286823 2022-03-08 Saipan Northern Mariana Islands 69110 9308 30
2283571 2283571 2022-03-07 Saipan Northern Mariana Islands 69110 9308 30
2280319 2280319 2022-03-06 Saipan Northern Mariana Islands 69110 9308 30
2277066 2277066 2022-03-05 Saipan Northern Mariana Islands 69110 9308 30
2273813 2273813 2022-03-04 Saipan Northern Mariana Islands 69110 9308 30
2270560 2270560 2022-03-03 Saipan Northern Mariana Islands 69110 9308 30
2267308 2267308 2022-03-02 Saipan Northern Mariana Islands 69110 9308 30
2264056 2264056 2022-03-01 Saipan Northern Mariana Islands 69110 9308 30
2260805 2260805 2022-02-28 Saipan Northern Mariana Islands 69110 9308 30
2257554 2257554 2022-02-27 Saipan Northern Mariana Islands 69110 5190 23
2254303 2254303 2022-02-26 Saipan Northern Mariana Islands 69110 5190 23
2251052 2251052 2022-02-25 Saipan Northern Mariana Islands 69110 5190 23
2247801 2247801 2022-02-24 Saipan Northern Mariana Islands 69110 5190 23
2244550 2244550 2022-02-23 Saipan Northern Mariana Islands 69110 5190 23
2241299 2241299 2022-02-22 Saipan Northern Mariana Islands 69110 5190 23
2238048 2238048 2022-02-21 Saipan Northern Mariana Islands 69110 5190 23
2234797 2234797 2022-02-20 Saipan Northern Mariana Islands 69110 5190 23
2231546 2231546 2022-02-19 Saipan Northern Mariana Islands 69110 5190 23
2228295 2228295 2022-02-18 Saipan Northern Mariana Islands 69110 5190 23
2225044 2225044 2022-02-17 Saipan Northern Mariana Islands 69110 5190 23
2221793 2221793 2022-02-16 Saipan Northern Mariana Islands 69110 5190 23
2218542 2218542 2022-02-15 Saipan Northern Mariana Islands 69110 5190 23
2215291 2215291 2022-02-14 Saipan Northern Mariana Islands 69110 5190 23
2212040 2212040 2022-02-13 Saipan Northern Mariana Islands 69110 5190 23
2208787 2208787 2022-02-12 Saipan Northern Mariana Islands 69110 5190 23
2205534 2205534 2022-02-11 Saipan Northern Mariana Islands 69110 5190 23
2202281 2202281 2022-02-10 Saipan Northern Mariana Islands 69110 5190 23
2199027 2199027 2022-02-09 Saipan Northern Mariana Islands 69110 5190 23
2195773 2195773 2022-02-08 Saipan Northern Mariana Islands 69110 5190 23
2192519 2192519 2022-02-07 Saipan Northern Mariana Islands 69110 5190 23
2189265 2189265 2022-02-06 Saipan Northern Mariana Islands 69110 5190 23
2186012 2186012 2022-02-05 Saipan Northern Mariana Islands 69110 5190 23
2182760 2182760 2022-02-04 Saipan Northern Mariana Islands 69110 5190 23
2179508 2179508 2022-02-03 Saipan Northern Mariana Islands 69110 5190 23

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