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

114 rows where county = "Rota" 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 · 114 ✖

fips 1

county 1

  • Rota · 114 ✖
Link rowid date ▲ county state fips cases deaths
2501640 2501640 2022-05-13 Rota Northern Mariana Islands 69100 415 0
2498382 2498382 2022-05-12 Rota Northern Mariana Islands 69100 415 0
2495124 2495124 2022-05-11 Rota Northern Mariana Islands 69100 415 0
2491866 2491866 2022-05-10 Rota Northern Mariana Islands 69100 415 0
2488608 2488608 2022-05-09 Rota Northern Mariana Islands 69100 415 0
2485351 2485351 2022-05-08 Rota Northern Mariana Islands 69100 415 0
2482093 2482093 2022-05-07 Rota Northern Mariana Islands 69100 415 0
2478835 2478835 2022-05-06 Rota Northern Mariana Islands 69100 415 0
2475577 2475577 2022-05-05 Rota Northern Mariana Islands 69100 415 0
2472320 2472320 2022-05-04 Rota Northern Mariana Islands 69100 415 0
2469064 2469064 2022-05-03 Rota Northern Mariana Islands 69100 415 0
2465808 2465808 2022-05-02 Rota Northern Mariana Islands 69100 415 0
2462553 2462553 2022-05-01 Rota Northern Mariana Islands 69100 415 0
2459297 2459297 2022-04-30 Rota Northern Mariana Islands 69100 415 0
2456041 2456041 2022-04-29 Rota Northern Mariana Islands 69100 415 0
2452785 2452785 2022-04-28 Rota Northern Mariana Islands 69100 415 0
2449529 2449529 2022-04-27 Rota Northern Mariana Islands 69100 415 0
2446272 2446272 2022-04-26 Rota Northern Mariana Islands 69100 415 0
2443017 2443017 2022-04-25 Rota Northern Mariana Islands 69100 415 0
2439761 2439761 2022-04-24 Rota Northern Mariana Islands 69100 415 0
2436505 2436505 2022-04-23 Rota Northern Mariana Islands 69100 415 0
2433249 2433249 2022-04-22 Rota Northern Mariana Islands 69100 415 0
2429993 2429993 2022-04-21 Rota Northern Mariana Islands 69100 415 0
2426737 2426737 2022-04-20 Rota Northern Mariana Islands 69100 415 0
2423481 2423481 2022-04-19 Rota Northern Mariana Islands 69100 415 0
2420224 2420224 2022-04-18 Rota Northern Mariana Islands 69100 415 0
2416969 2416969 2022-04-17 Rota Northern Mariana Islands 69100 415 0
2413713 2413713 2022-04-16 Rota Northern Mariana Islands 69100 415 0
2410457 2410457 2022-04-15 Rota Northern Mariana Islands 69100 415 0
2407201 2407201 2022-04-14 Rota Northern Mariana Islands 69100 415 0
2403945 2403945 2022-04-13 Rota Northern Mariana Islands 69100 415 0
2400690 2400690 2022-04-12 Rota Northern Mariana Islands 69100 415 0
2397435 2397435 2022-04-11 Rota Northern Mariana Islands 69100 415 0
2394180 2394180 2022-04-10 Rota Northern Mariana Islands 69100 415 0
2390924 2390924 2022-04-09 Rota Northern Mariana Islands 69100 415 0
2387668 2387668 2022-04-08 Rota Northern Mariana Islands 69100 415 0
2384413 2384413 2022-04-07 Rota Northern Mariana Islands 69100 415 0
2381158 2381158 2022-04-06 Rota Northern Mariana Islands 69100 415 0
2377903 2377903 2022-04-05 Rota Northern Mariana Islands 69100 415 0
2374650 2374650 2022-04-04 Rota Northern Mariana Islands 69100 415 0
2371398 2371398 2022-04-03 Rota Northern Mariana Islands 69100 415 0
2368145 2368145 2022-04-02 Rota Northern Mariana Islands 69100 415 0
2364892 2364892 2022-04-01 Rota Northern Mariana Islands 69100 415 0
2361638 2361638 2022-03-31 Rota Northern Mariana Islands 69100 183 0
2358384 2358384 2022-03-30 Rota Northern Mariana Islands 69100 183 0
2355130 2355130 2022-03-29 Rota Northern Mariana Islands 69100 183 0
2351877 2351877 2022-03-28 Rota Northern Mariana Islands 69100 183 0
2348625 2348625 2022-03-27 Rota Northern Mariana Islands 69100 183 0
2345372 2345372 2022-03-26 Rota Northern Mariana Islands 69100 183 0
2342119 2342119 2022-03-25 Rota Northern Mariana Islands 69100 183 0
2338866 2338866 2022-03-24 Rota Northern Mariana Islands 69100 183 0
2335612 2335612 2022-03-23 Rota Northern Mariana Islands 69100 183 0
2332358 2332358 2022-03-22 Rota Northern Mariana Islands 69100 183 0
2329105 2329105 2022-03-21 Rota Northern Mariana Islands 69100 183 0
2325853 2325853 2022-03-20 Rota Northern Mariana Islands 69100 183 0
2322600 2322600 2022-03-19 Rota Northern Mariana Islands 69100 183 0
2319346 2319346 2022-03-18 Rota Northern Mariana Islands 69100 183 0
2316092 2316092 2022-03-17 Rota Northern Mariana Islands 69100 183 0
2312839 2312839 2022-03-16 Rota Northern Mariana Islands 69100 183 0
2309586 2309586 2022-03-15 Rota Northern Mariana Islands 69100 183 0
2306333 2306333 2022-03-14 Rota Northern Mariana Islands 69100 183 0
2303082 2303082 2022-03-13 Rota Northern Mariana Islands 69100 183 0
2299830 2299830 2022-03-12 Rota Northern Mariana Islands 69100 183 0
2296578 2296578 2022-03-11 Rota Northern Mariana Islands 69100 183 0
2293326 2293326 2022-03-10 Rota Northern Mariana Islands 69100 183 0
2290074 2290074 2022-03-09 Rota Northern Mariana Islands 69100 183 0
2286822 2286822 2022-03-08 Rota Northern Mariana Islands 69100 183 0
2283570 2283570 2022-03-07 Rota Northern Mariana Islands 69100 183 0
2280318 2280318 2022-03-06 Rota Northern Mariana Islands 69100 183 0
2277065 2277065 2022-03-05 Rota Northern Mariana Islands 69100 183 0
2273812 2273812 2022-03-04 Rota Northern Mariana Islands 69100 183 0
2270559 2270559 2022-03-03 Rota Northern Mariana Islands 69100 183 0
2267307 2267307 2022-03-02 Rota Northern Mariana Islands 69100 183 0
2264055 2264055 2022-03-01 Rota Northern Mariana Islands 69100 183 0
2260804 2260804 2022-02-28 Rota Northern Mariana Islands 69100 183 0
2257553 2257553 2022-02-27 Rota Northern Mariana Islands 69100 66 0
2254302 2254302 2022-02-26 Rota Northern Mariana Islands 69100 66 0
2251051 2251051 2022-02-25 Rota Northern Mariana Islands 69100 66 0
2247800 2247800 2022-02-24 Rota Northern Mariana Islands 69100 66 0
2244549 2244549 2022-02-23 Rota Northern Mariana Islands 69100 66 0
2241298 2241298 2022-02-22 Rota Northern Mariana Islands 69100 66 0
2238047 2238047 2022-02-21 Rota Northern Mariana Islands 69100 66 0
2234796 2234796 2022-02-20 Rota Northern Mariana Islands 69100 66 0
2231545 2231545 2022-02-19 Rota Northern Mariana Islands 69100 66 0
2228294 2228294 2022-02-18 Rota Northern Mariana Islands 69100 66 0
2225043 2225043 2022-02-17 Rota Northern Mariana Islands 69100 66 0
2221792 2221792 2022-02-16 Rota Northern Mariana Islands 69100 66 0
2218541 2218541 2022-02-15 Rota Northern Mariana Islands 69100 66 0
2215290 2215290 2022-02-14 Rota Northern Mariana Islands 69100 66 0
2212039 2212039 2022-02-13 Rota Northern Mariana Islands 69100 66 0
2208786 2208786 2022-02-12 Rota Northern Mariana Islands 69100 66 0
2205533 2205533 2022-02-11 Rota Northern Mariana Islands 69100 66 0
2202280 2202280 2022-02-10 Rota Northern Mariana Islands 69100 66 0
2199026 2199026 2022-02-09 Rota Northern Mariana Islands 69100 66 0
2195772 2195772 2022-02-08 Rota Northern Mariana Islands 69100 66 0
2192518 2192518 2022-02-07 Rota Northern Mariana Islands 69100 66 0
2189264 2189264 2022-02-06 Rota Northern Mariana Islands 69100 66 0
2186011 2186011 2022-02-05 Rota Northern Mariana Islands 69100 66 0
2182759 2182759 2022-02-04 Rota Northern Mariana Islands 69100 66 0
2179507 2179507 2022-02-03 Rota Northern Mariana Islands 69100 66 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);