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 = "Tinian" and state = "Northern Mariana Islands" sorted by date descending

✎ View and edit SQL

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

Suggested facets: cases, date (date)

state 1

  • Northern Mariana Islands · 669 ✖

fips 1

county 1

  • Tinian · 669 ✖
Link rowid date ▲ county state fips cases deaths
2501642 2501642 2022-05-13 Tinian Northern Mariana Islands 69120 341 0
2498384 2498384 2022-05-12 Tinian Northern Mariana Islands 69120 341 0
2495126 2495126 2022-05-11 Tinian Northern Mariana Islands 69120 341 0
2491868 2491868 2022-05-10 Tinian Northern Mariana Islands 69120 341 0
2488610 2488610 2022-05-09 Tinian Northern Mariana Islands 69120 341 0
2485353 2485353 2022-05-08 Tinian Northern Mariana Islands 69120 341 0
2482095 2482095 2022-05-07 Tinian Northern Mariana Islands 69120 341 0
2478837 2478837 2022-05-06 Tinian Northern Mariana Islands 69120 341 0
2475579 2475579 2022-05-05 Tinian Northern Mariana Islands 69120 341 0
2472322 2472322 2022-05-04 Tinian Northern Mariana Islands 69120 341 0
2469066 2469066 2022-05-03 Tinian Northern Mariana Islands 69120 341 0
2465810 2465810 2022-05-02 Tinian Northern Mariana Islands 69120 341 0
2462555 2462555 2022-05-01 Tinian Northern Mariana Islands 69120 341 0
2459299 2459299 2022-04-30 Tinian Northern Mariana Islands 69120 341 0
2456043 2456043 2022-04-29 Tinian Northern Mariana Islands 69120 341 0
2452787 2452787 2022-04-28 Tinian Northern Mariana Islands 69120 341 0
2449531 2449531 2022-04-27 Tinian Northern Mariana Islands 69120 341 0
2446274 2446274 2022-04-26 Tinian Northern Mariana Islands 69120 341 0
2443019 2443019 2022-04-25 Tinian Northern Mariana Islands 69120 341 0
2439763 2439763 2022-04-24 Tinian Northern Mariana Islands 69120 341 0
2436507 2436507 2022-04-23 Tinian Northern Mariana Islands 69120 341 0
2433251 2433251 2022-04-22 Tinian Northern Mariana Islands 69120 341 0
2429995 2429995 2022-04-21 Tinian Northern Mariana Islands 69120 341 0
2426739 2426739 2022-04-20 Tinian Northern Mariana Islands 69120 341 0
2423483 2423483 2022-04-19 Tinian Northern Mariana Islands 69120 341 0
2420226 2420226 2022-04-18 Tinian Northern Mariana Islands 69120 341 0
2416971 2416971 2022-04-17 Tinian Northern Mariana Islands 69120 341 0
2413715 2413715 2022-04-16 Tinian Northern Mariana Islands 69120 341 0
2410459 2410459 2022-04-15 Tinian Northern Mariana Islands 69120 341 0
2407203 2407203 2022-04-14 Tinian Northern Mariana Islands 69120 341 0
2403947 2403947 2022-04-13 Tinian Northern Mariana Islands 69120 341 0
2400692 2400692 2022-04-12 Tinian Northern Mariana Islands 69120 341 0
2397437 2397437 2022-04-11 Tinian Northern Mariana Islands 69120 341 0
2394182 2394182 2022-04-10 Tinian Northern Mariana Islands 69120 341 0
2390926 2390926 2022-04-09 Tinian Northern Mariana Islands 69120 341 0
2387670 2387670 2022-04-08 Tinian Northern Mariana Islands 69120 341 0
2384415 2384415 2022-04-07 Tinian Northern Mariana Islands 69120 341 0
2381160 2381160 2022-04-06 Tinian Northern Mariana Islands 69120 341 0
2377905 2377905 2022-04-05 Tinian Northern Mariana Islands 69120 341 0
2374652 2374652 2022-04-04 Tinian Northern Mariana Islands 69120 341 0
2371400 2371400 2022-04-03 Tinian Northern Mariana Islands 69120 341 0
2368147 2368147 2022-04-02 Tinian Northern Mariana Islands 69120 341 0
2364894 2364894 2022-04-01 Tinian Northern Mariana Islands 69120 341 0
2361640 2361640 2022-03-31 Tinian Northern Mariana Islands 69120 233 0
2358386 2358386 2022-03-30 Tinian Northern Mariana Islands 69120 233 0
2355132 2355132 2022-03-29 Tinian Northern Mariana Islands 69120 233 0
2351879 2351879 2022-03-28 Tinian Northern Mariana Islands 69120 233 0
2348627 2348627 2022-03-27 Tinian Northern Mariana Islands 69120 233 0
2345374 2345374 2022-03-26 Tinian Northern Mariana Islands 69120 233 0
2342121 2342121 2022-03-25 Tinian Northern Mariana Islands 69120 233 0
2338868 2338868 2022-03-24 Tinian Northern Mariana Islands 69120 233 0
2335614 2335614 2022-03-23 Tinian Northern Mariana Islands 69120 233 0
2332360 2332360 2022-03-22 Tinian Northern Mariana Islands 69120 233 0
2329107 2329107 2022-03-21 Tinian Northern Mariana Islands 69120 233 0
2325855 2325855 2022-03-20 Tinian Northern Mariana Islands 69120 233 0
2322602 2322602 2022-03-19 Tinian Northern Mariana Islands 69120 233 0
2319348 2319348 2022-03-18 Tinian Northern Mariana Islands 69120 233 0
2316094 2316094 2022-03-17 Tinian Northern Mariana Islands 69120 233 0
2312841 2312841 2022-03-16 Tinian Northern Mariana Islands 69120 233 0
2309588 2309588 2022-03-15 Tinian Northern Mariana Islands 69120 233 0
2306335 2306335 2022-03-14 Tinian Northern Mariana Islands 69120 233 0
2303084 2303084 2022-03-13 Tinian Northern Mariana Islands 69120 233 0
2299832 2299832 2022-03-12 Tinian Northern Mariana Islands 69120 233 0
2296580 2296580 2022-03-11 Tinian Northern Mariana Islands 69120 233 0
2293328 2293328 2022-03-10 Tinian Northern Mariana Islands 69120 233 0
2290076 2290076 2022-03-09 Tinian Northern Mariana Islands 69120 233 0
2286824 2286824 2022-03-08 Tinian Northern Mariana Islands 69120 233 0
2283572 2283572 2022-03-07 Tinian Northern Mariana Islands 69120 233 0
2280320 2280320 2022-03-06 Tinian Northern Mariana Islands 69120 233 0
2277067 2277067 2022-03-05 Tinian Northern Mariana Islands 69120 233 0
2273814 2273814 2022-03-04 Tinian Northern Mariana Islands 69120 233 0
2270561 2270561 2022-03-03 Tinian Northern Mariana Islands 69120 233 0
2267309 2267309 2022-03-02 Tinian Northern Mariana Islands 69120 233 0
2264057 2264057 2022-03-01 Tinian Northern Mariana Islands 69120 233 0
2260806 2260806 2022-02-28 Tinian Northern Mariana Islands 69120 233 0
2257555 2257555 2022-02-27 Tinian Northern Mariana Islands 69120 24 0
2254304 2254304 2022-02-26 Tinian Northern Mariana Islands 69120 24 0
2251053 2251053 2022-02-25 Tinian Northern Mariana Islands 69120 24 0
2247802 2247802 2022-02-24 Tinian Northern Mariana Islands 69120 24 0
2244551 2244551 2022-02-23 Tinian Northern Mariana Islands 69120 24 0
2241300 2241300 2022-02-22 Tinian Northern Mariana Islands 69120 24 0
2238049 2238049 2022-02-21 Tinian Northern Mariana Islands 69120 24 0
2234798 2234798 2022-02-20 Tinian Northern Mariana Islands 69120 24 0
2231547 2231547 2022-02-19 Tinian Northern Mariana Islands 69120 24 0
2228296 2228296 2022-02-18 Tinian Northern Mariana Islands 69120 24 0
2225045 2225045 2022-02-17 Tinian Northern Mariana Islands 69120 24 0
2221794 2221794 2022-02-16 Tinian Northern Mariana Islands 69120 24 0
2218543 2218543 2022-02-15 Tinian Northern Mariana Islands 69120 24 0
2215292 2215292 2022-02-14 Tinian Northern Mariana Islands 69120 24 0
2212041 2212041 2022-02-13 Tinian Northern Mariana Islands 69120 24 0
2208788 2208788 2022-02-12 Tinian Northern Mariana Islands 69120 24 0
2205535 2205535 2022-02-11 Tinian Northern Mariana Islands 69120 24 0
2202282 2202282 2022-02-10 Tinian Northern Mariana Islands 69120 24 0
2199028 2199028 2022-02-09 Tinian Northern Mariana Islands 69120 24 0
2195774 2195774 2022-02-08 Tinian Northern Mariana Islands 69120 24 0
2192520 2192520 2022-02-07 Tinian Northern Mariana Islands 69120 24 0
2189266 2189266 2022-02-06 Tinian Northern Mariana Islands 69120 24 0
2186013 2186013 2022-02-05 Tinian Northern Mariana Islands 69120 24 0
2182761 2182761 2022-02-04 Tinian Northern Mariana Islands 69120 24 0
2179509 2179509 2022-02-03 Tinian Northern Mariana Islands 69120 24 0

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