ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
947 rows where deaths = 0 and state = "Northern Mariana Islands" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state 1
- Northern Mariana Islands · 947 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501640 | 2501640 | 2022-05-13 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2501642 | 2501642 | 2022-05-13 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2498382 | 2498382 | 2022-05-12 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2498384 | 2498384 | 2022-05-12 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2495124 | 2495124 | 2022-05-11 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2495126 | 2495126 | 2022-05-11 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2491866 | 2491866 | 2022-05-10 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2491868 | 2491868 | 2022-05-10 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2488608 | 2488608 | 2022-05-09 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2488610 | 2488610 | 2022-05-09 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2485351 | 2485351 | 2022-05-08 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2485353 | 2485353 | 2022-05-08 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2482093 | 2482093 | 2022-05-07 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2482095 | 2482095 | 2022-05-07 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2478835 | 2478835 | 2022-05-06 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2478837 | 2478837 | 2022-05-06 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2475577 | 2475577 | 2022-05-05 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2475579 | 2475579 | 2022-05-05 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2472320 | 2472320 | 2022-05-04 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2472322 | 2472322 | 2022-05-04 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2469064 | 2469064 | 2022-05-03 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2469066 | 2469066 | 2022-05-03 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2465808 | 2465808 | 2022-05-02 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2465810 | 2465810 | 2022-05-02 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2462553 | 2462553 | 2022-05-01 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2462555 | 2462555 | 2022-05-01 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2459297 | 2459297 | 2022-04-30 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2459299 | 2459299 | 2022-04-30 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2456041 | 2456041 | 2022-04-29 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2456043 | 2456043 | 2022-04-29 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2452785 | 2452785 | 2022-04-28 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2452787 | 2452787 | 2022-04-28 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2449529 | 2449529 | 2022-04-27 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2449531 | 2449531 | 2022-04-27 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2446272 | 2446272 | 2022-04-26 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2446274 | 2446274 | 2022-04-26 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2443017 | 2443017 | 2022-04-25 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2443019 | 2443019 | 2022-04-25 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2439761 | 2439761 | 2022-04-24 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2439763 | 2439763 | 2022-04-24 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2436505 | 2436505 | 2022-04-23 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2436507 | 2436507 | 2022-04-23 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2433249 | 2433249 | 2022-04-22 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2433251 | 2433251 | 2022-04-22 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2429993 | 2429993 | 2022-04-21 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2429995 | 2429995 | 2022-04-21 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2426737 | 2426737 | 2022-04-20 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2426739 | 2426739 | 2022-04-20 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2423481 | 2423481 | 2022-04-19 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2423483 | 2423483 | 2022-04-19 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2420224 | 2420224 | 2022-04-18 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2420226 | 2420226 | 2022-04-18 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2416969 | 2416969 | 2022-04-17 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2416971 | 2416971 | 2022-04-17 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2413713 | 2413713 | 2022-04-16 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2413715 | 2413715 | 2022-04-16 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2410457 | 2410457 | 2022-04-15 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2410459 | 2410459 | 2022-04-15 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2407201 | 2407201 | 2022-04-14 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2407203 | 2407203 | 2022-04-14 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2403945 | 2403945 | 2022-04-13 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2403947 | 2403947 | 2022-04-13 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2400690 | 2400690 | 2022-04-12 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2400692 | 2400692 | 2022-04-12 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2397435 | 2397435 | 2022-04-11 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2397437 | 2397437 | 2022-04-11 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2394180 | 2394180 | 2022-04-10 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2394182 | 2394182 | 2022-04-10 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2394183 | 2394183 | 2022-04-10 | Unknown | Northern Mariana Islands | 5 | 0 | |
2390924 | 2390924 | 2022-04-09 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2390926 | 2390926 | 2022-04-09 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2390927 | 2390927 | 2022-04-09 | Unknown | Northern Mariana Islands | 5 | 0 | |
2387668 | 2387668 | 2022-04-08 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2387670 | 2387670 | 2022-04-08 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2387671 | 2387671 | 2022-04-08 | Unknown | Northern Mariana Islands | 5 | 0 | |
2384413 | 2384413 | 2022-04-07 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2384415 | 2384415 | 2022-04-07 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2384416 | 2384416 | 2022-04-07 | Unknown | Northern Mariana Islands | 5 | 0 | |
2381158 | 2381158 | 2022-04-06 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2381160 | 2381160 | 2022-04-06 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2381161 | 2381161 | 2022-04-06 | Unknown | Northern Mariana Islands | 5 | 0 | |
2377903 | 2377903 | 2022-04-05 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2377905 | 2377905 | 2022-04-05 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2377906 | 2377906 | 2022-04-05 | Unknown | Northern Mariana Islands | 5 | 0 | |
2374650 | 2374650 | 2022-04-04 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2374652 | 2374652 | 2022-04-04 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2371398 | 2371398 | 2022-04-03 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2371400 | 2371400 | 2022-04-03 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2368145 | 2368145 | 2022-04-02 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2368147 | 2368147 | 2022-04-02 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2364892 | 2364892 | 2022-04-01 | Rota | Northern Mariana Islands | 69100 | 415 | 0 |
2364894 | 2364894 | 2022-04-01 | Tinian | Northern Mariana Islands | 69120 | 341 | 0 |
2361638 | 2361638 | 2022-03-31 | Rota | Northern Mariana Islands | 69100 | 183 | 0 |
2361640 | 2361640 | 2022-03-31 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2358384 | 2358384 | 2022-03-30 | Rota | Northern Mariana Islands | 69100 | 183 | 0 |
2358386 | 2358386 | 2022-03-30 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2355130 | 2355130 | 2022-03-29 | Rota | Northern Mariana Islands | 69100 | 183 | 0 |
2355132 | 2355132 | 2022-03-29 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
2351877 | 2351877 | 2022-03-28 | Rota | Northern Mariana Islands | 69100 | 183 | 0 |
2351879 | 2351879 | 2022-03-28 | Tinian | Northern Mariana Islands | 69120 | 233 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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);