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

1,832 rows where 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)

fips 4

county 4

state 1

  • Northern Mariana Islands · 1,832 ✖
Link rowid date ▲ county state fips cases deaths
2501640 2501640 2022-05-13 Rota Northern Mariana Islands 69100 415 0
2501641 2501641 2022-05-13 Saipan Northern Mariana Islands 69110 10397 33
2501642 2501642 2022-05-13 Tinian Northern Mariana Islands 69120 341 0
2501643 2501643 2022-05-13 Unknown Northern Mariana Islands   152 1
2498382 2498382 2022-05-12 Rota Northern Mariana Islands 69100 415 0
2498383 2498383 2022-05-12 Saipan Northern Mariana Islands 69110 10397 33
2498384 2498384 2022-05-12 Tinian Northern Mariana Islands 69120 341 0
2498385 2498385 2022-05-12 Unknown Northern Mariana Islands   152 1
2495124 2495124 2022-05-11 Rota Northern Mariana Islands 69100 415 0
2495125 2495125 2022-05-11 Saipan Northern Mariana Islands 69110 10397 33
2495126 2495126 2022-05-11 Tinian Northern Mariana Islands 69120 341 0
2495127 2495127 2022-05-11 Unknown Northern Mariana Islands   152 1
2491866 2491866 2022-05-10 Rota Northern Mariana Islands 69100 415 0
2491867 2491867 2022-05-10 Saipan Northern Mariana Islands 69110 10397 33
2491868 2491868 2022-05-10 Tinian Northern Mariana Islands 69120 341 0
2491869 2491869 2022-05-10 Unknown Northern Mariana Islands   152 1
2488608 2488608 2022-05-09 Rota Northern Mariana Islands 69100 415 0
2488609 2488609 2022-05-09 Saipan Northern Mariana Islands 69110 10397 33
2488610 2488610 2022-05-09 Tinian Northern Mariana Islands 69120 341 0
2488611 2488611 2022-05-09 Unknown Northern Mariana Islands   152 1
2485351 2485351 2022-05-08 Rota Northern Mariana Islands 69100 415 0
2485352 2485352 2022-05-08 Saipan Northern Mariana Islands 69110 10397 33
2485353 2485353 2022-05-08 Tinian Northern Mariana Islands 69120 341 0
2485354 2485354 2022-05-08 Unknown Northern Mariana Islands   128 1
2482093 2482093 2022-05-07 Rota Northern Mariana Islands 69100 415 0
2482094 2482094 2022-05-07 Saipan Northern Mariana Islands 69110 10397 33
2482095 2482095 2022-05-07 Tinian Northern Mariana Islands 69120 341 0
2482096 2482096 2022-05-07 Unknown Northern Mariana Islands   128 1
2478835 2478835 2022-05-06 Rota Northern Mariana Islands 69100 415 0
2478836 2478836 2022-05-06 Saipan Northern Mariana Islands 69110 10397 33
2478837 2478837 2022-05-06 Tinian Northern Mariana Islands 69120 341 0
2478838 2478838 2022-05-06 Unknown Northern Mariana Islands   128 1
2475577 2475577 2022-05-05 Rota Northern Mariana Islands 69100 415 0
2475578 2475578 2022-05-05 Saipan Northern Mariana Islands 69110 10397 33
2475579 2475579 2022-05-05 Tinian Northern Mariana Islands 69120 341 0
2475580 2475580 2022-05-05 Unknown Northern Mariana Islands   128 1
2472320 2472320 2022-05-04 Rota Northern Mariana Islands 69100 415 0
2472321 2472321 2022-05-04 Saipan Northern Mariana Islands 69110 10397 33
2472322 2472322 2022-05-04 Tinian Northern Mariana Islands 69120 341 0
2472323 2472323 2022-05-04 Unknown Northern Mariana Islands   110 1
2469064 2469064 2022-05-03 Rota Northern Mariana Islands 69100 415 0
2469065 2469065 2022-05-03 Saipan Northern Mariana Islands 69110 10397 33
2469066 2469066 2022-05-03 Tinian Northern Mariana Islands 69120 341 0
2469067 2469067 2022-05-03 Unknown Northern Mariana Islands   110 1
2465808 2465808 2022-05-02 Rota Northern Mariana Islands 69100 415 0
2465809 2465809 2022-05-02 Saipan Northern Mariana Islands 69110 10397 33
2465810 2465810 2022-05-02 Tinian Northern Mariana Islands 69120 341 0
2465811 2465811 2022-05-02 Unknown Northern Mariana Islands   110 1
2462553 2462553 2022-05-01 Rota Northern Mariana Islands 69100 415 0
2462554 2462554 2022-05-01 Saipan Northern Mariana Islands 69110 10397 33
2462555 2462555 2022-05-01 Tinian Northern Mariana Islands 69120 341 0
2462556 2462556 2022-05-01 Unknown Northern Mariana Islands   110 1
2459297 2459297 2022-04-30 Rota Northern Mariana Islands 69100 415 0
2459298 2459298 2022-04-30 Saipan Northern Mariana Islands 69110 10397 33
2459299 2459299 2022-04-30 Tinian Northern Mariana Islands 69120 341 0
2459300 2459300 2022-04-30 Unknown Northern Mariana Islands   110 1
2456041 2456041 2022-04-29 Rota Northern Mariana Islands 69100 415 0
2456042 2456042 2022-04-29 Saipan Northern Mariana Islands 69110 10397 33
2456043 2456043 2022-04-29 Tinian Northern Mariana Islands 69120 341 0
2456044 2456044 2022-04-29 Unknown Northern Mariana Islands   110 1
2452785 2452785 2022-04-28 Rota Northern Mariana Islands 69100 415 0
2452786 2452786 2022-04-28 Saipan Northern Mariana Islands 69110 10397 33
2452787 2452787 2022-04-28 Tinian Northern Mariana Islands 69120 341 0
2452788 2452788 2022-04-28 Unknown Northern Mariana Islands   110 1
2449529 2449529 2022-04-27 Rota Northern Mariana Islands 69100 415 0
2449530 2449530 2022-04-27 Saipan Northern Mariana Islands 69110 10397 33
2449531 2449531 2022-04-27 Tinian Northern Mariana Islands 69120 341 0
2449532 2449532 2022-04-27 Unknown Northern Mariana Islands   110 1
2446272 2446272 2022-04-26 Rota Northern Mariana Islands 69100 415 0
2446273 2446273 2022-04-26 Saipan Northern Mariana Islands 69110 10397 33
2446274 2446274 2022-04-26 Tinian Northern Mariana Islands 69120 341 0
2446275 2446275 2022-04-26 Unknown Northern Mariana Islands   110 1
2443017 2443017 2022-04-25 Rota Northern Mariana Islands 69100 415 0
2443018 2443018 2022-04-25 Saipan Northern Mariana Islands 69110 10397 33
2443019 2443019 2022-04-25 Tinian Northern Mariana Islands 69120 341 0
2443020 2443020 2022-04-25 Unknown Northern Mariana Islands   68 1
2439761 2439761 2022-04-24 Rota Northern Mariana Islands 69100 415 0
2439762 2439762 2022-04-24 Saipan Northern Mariana Islands 69110 10397 33
2439763 2439763 2022-04-24 Tinian Northern Mariana Islands 69120 341 0
2439764 2439764 2022-04-24 Unknown Northern Mariana Islands   68 1
2436505 2436505 2022-04-23 Rota Northern Mariana Islands 69100 415 0
2436506 2436506 2022-04-23 Saipan Northern Mariana Islands 69110 10397 33
2436507 2436507 2022-04-23 Tinian Northern Mariana Islands 69120 341 0
2436508 2436508 2022-04-23 Unknown Northern Mariana Islands   68 1
2433249 2433249 2022-04-22 Rota Northern Mariana Islands 69100 415 0
2433250 2433250 2022-04-22 Saipan Northern Mariana Islands 69110 10397 33
2433251 2433251 2022-04-22 Tinian Northern Mariana Islands 69120 341 0
2433252 2433252 2022-04-22 Unknown Northern Mariana Islands   68 1
2429993 2429993 2022-04-21 Rota Northern Mariana Islands 69100 415 0
2429994 2429994 2022-04-21 Saipan Northern Mariana Islands 69110 10397 33
2429995 2429995 2022-04-21 Tinian Northern Mariana Islands 69120 341 0
2429996 2429996 2022-04-21 Unknown Northern Mariana Islands   68 1
2426737 2426737 2022-04-20 Rota Northern Mariana Islands 69100 415 0
2426738 2426738 2022-04-20 Saipan Northern Mariana Islands 69110 10397 33
2426739 2426739 2022-04-20 Tinian Northern Mariana Islands 69120 341 0
2426740 2426740 2022-04-20 Unknown Northern Mariana Islands   68 1
2423481 2423481 2022-04-19 Rota Northern Mariana Islands 69100 415 0
2423482 2423482 2022-04-19 Saipan Northern Mariana Islands 69110 10397 33
2423483 2423483 2022-04-19 Tinian Northern Mariana Islands 69120 341 0
2423484 2423484 2022-04-19 Unknown Northern Mariana Islands   68 1

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