ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
380 rows where county = "Unknown" and state = "Northern Mariana Islands" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
756985 | 756985 | 2020-11-22 | Unknown | Northern Mariana Islands | 2 | 0 | |
753738 | 753738 | 2020-11-21 | Unknown | Northern Mariana Islands | 1 | 0 | |
750492 | 750492 | 2020-11-20 | Unknown | Northern Mariana Islands | 1 | 0 | |
747246 | 747246 | 2020-11-19 | Unknown | Northern Mariana Islands | 1 | 0 | |
744000 | 744000 | 2020-11-18 | Unknown | Northern Mariana Islands | 1 | 0 | |
740753 | 740753 | 2020-11-17 | Unknown | Northern Mariana Islands | 1 | 0 | |
581823 | 581823 | 2020-09-29 | Unknown | Northern Mariana Islands | 15 | 0 | |
578583 | 578583 | 2020-09-28 | Unknown | Northern Mariana Islands | 15 | 0 | |
575342 | 575342 | 2020-09-27 | Unknown | Northern Mariana Islands | 15 | 0 | |
572098 | 572098 | 2020-09-26 | Unknown | Northern Mariana Islands | 15 | 0 | |
568856 | 568856 | 2020-09-25 | Unknown | Northern Mariana Islands | 15 | 0 | |
565615 | 565615 | 2020-09-24 | Unknown | Northern Mariana Islands | 15 | 0 | |
562374 | 562374 | 2020-09-23 | Unknown | Northern Mariana Islands | 15 | 0 | |
559137 | 559137 | 2020-09-22 | Unknown | Northern Mariana Islands | 15 | 0 | |
555900 | 555900 | 2020-09-21 | Unknown | Northern Mariana Islands | 15 | 0 | |
552663 | 552663 | 2020-09-20 | Unknown | Northern Mariana Islands | 14 | 0 | |
549424 | 549424 | 2020-09-19 | Unknown | Northern Mariana Islands | 14 | 0 | |
546185 | 546185 | 2020-09-18 | Unknown | Northern Mariana Islands | 8 | 0 | |
542948 | 542948 | 2020-09-17 | Unknown | Northern Mariana Islands | 8 | 0 | |
539712 | 539712 | 2020-09-16 | Unknown | Northern Mariana Islands | 7 | 0 | |
536475 | 536475 | 2020-09-15 | Unknown | Northern Mariana Islands | 7 | 0 | |
533239 | 533239 | 2020-09-14 | Unknown | Northern Mariana Islands | 7 | 0 | |
530004 | 530004 | 2020-09-13 | Unknown | Northern Mariana Islands | 6 | 0 | |
526767 | 526767 | 2020-09-12 | Unknown | Northern Mariana Islands | 6 | 0 | |
523531 | 523531 | 2020-09-11 | Unknown | Northern Mariana Islands | 5 | 0 | |
520295 | 520295 | 2020-09-10 | Unknown | Northern Mariana Islands | 5 | 0 | |
517059 | 517059 | 2020-09-09 | Unknown | Northern Mariana Islands | 5 | 0 | |
513824 | 513824 | 2020-09-08 | Unknown | Northern Mariana Islands | 5 | 0 | |
510591 | 510591 | 2020-09-07 | Unknown | Northern Mariana Islands | 5 | 0 | |
507358 | 507358 | 2020-09-06 | Unknown | Northern Mariana Islands | 4 | 0 | |
504126 | 504126 | 2020-09-05 | Unknown | Northern Mariana Islands | 4 | 0 | |
500892 | 500892 | 2020-09-04 | Unknown | Northern Mariana Islands | 3 | 0 | |
497658 | 497658 | 2020-09-03 | Unknown | Northern Mariana Islands | 3 | 0 | |
494425 | 494425 | 2020-09-02 | Unknown | Northern Mariana Islands | 3 | 0 | |
491191 | 491191 | 2020-09-01 | Unknown | Northern Mariana Islands | 3 | 0 | |
487958 | 487958 | 2020-08-31 | Unknown | Northern Mariana Islands | 2 | 0 | |
484725 | 484725 | 2020-08-30 | Unknown | Northern Mariana Islands | 2 | 0 | |
481490 | 481490 | 2020-08-29 | Unknown | Northern Mariana Islands | 2 | 0 | |
330272 | 330272 | 2020-07-13 | Unknown | Northern Mariana Islands | 33 | 2 | |
327085 | 327085 | 2020-07-12 | Unknown | Northern Mariana Islands | 33 | 2 | |
323900 | 323900 | 2020-07-11 | Unknown | Northern Mariana Islands | 33 | 2 | |
320720 | 320720 | 2020-07-10 | Unknown | Northern Mariana Islands | 31 | 2 | |
317543 | 317543 | 2020-07-09 | Unknown | Northern Mariana Islands | 31 | 2 | |
314370 | 314370 | 2020-07-08 | Unknown | Northern Mariana Islands | 31 | 2 | |
311198 | 311198 | 2020-07-07 | Unknown | Northern Mariana Islands | 31 | 2 | |
308029 | 308029 | 2020-07-06 | Unknown | Northern Mariana Islands | 31 | 2 | |
304862 | 304862 | 2020-07-05 | Unknown | Northern Mariana Islands | 31 | 2 | |
301699 | 301699 | 2020-07-04 | Unknown | Northern Mariana Islands | 31 | 2 | |
298536 | 298536 | 2020-07-03 | Unknown | Northern Mariana Islands | 31 | 2 | |
295376 | 295376 | 2020-07-02 | Unknown | Northern Mariana Islands | 30 | 2 | |
292221 | 292221 | 2020-07-01 | Unknown | Northern Mariana Islands | 30 | 2 | |
289069 | 289069 | 2020-06-30 | Unknown | Northern Mariana Islands | 30 | 2 | |
285919 | 285919 | 2020-06-29 | Unknown | Northern Mariana Islands | 30 | 2 | |
282774 | 282774 | 2020-06-28 | Unknown | Northern Mariana Islands | 30 | 2 | |
279628 | 279628 | 2020-06-27 | Unknown | Northern Mariana Islands | 30 | 2 | |
276480 | 276480 | 2020-06-26 | Unknown | Northern Mariana Islands | 30 | 2 | |
273333 | 273333 | 2020-06-25 | Unknown | Northern Mariana Islands | 30 | 2 | |
270194 | 270194 | 2020-06-24 | Unknown | Northern Mariana Islands | 30 | 2 | |
267060 | 267060 | 2020-06-23 | Unknown | Northern Mariana Islands | 30 | 2 | |
263932 | 263932 | 2020-06-22 | Unknown | Northern Mariana Islands | 30 | 2 | |
260804 | 260804 | 2020-06-21 | Unknown | Northern Mariana Islands | 30 | 2 | |
257677 | 257677 | 2020-06-20 | Unknown | Northern Mariana Islands | 30 | 2 | |
254552 | 254552 | 2020-06-19 | Unknown | Northern Mariana Islands | 30 | 2 | |
251437 | 251437 | 2020-06-18 | Unknown | Northern Mariana Islands | 30 | 2 | |
248322 | 248322 | 2020-06-17 | Unknown | Northern Mariana Islands | 30 | 2 | |
245209 | 245209 | 2020-06-16 | Unknown | Northern Mariana Islands | 30 | 2 | |
242097 | 242097 | 2020-06-15 | Unknown | Northern Mariana Islands | 30 | 2 | |
238988 | 238988 | 2020-06-14 | Unknown | Northern Mariana Islands | 30 | 2 | |
235880 | 235880 | 2020-06-13 | Unknown | Northern Mariana Islands | 30 | 2 | |
232775 | 232775 | 2020-06-12 | Unknown | Northern Mariana Islands | 30 | 2 | |
229670 | 229670 | 2020-06-11 | Unknown | Northern Mariana Islands | 30 | 2 | |
226566 | 226566 | 2020-06-10 | Unknown | Northern Mariana Islands | 30 | 2 | |
223466 | 223466 | 2020-06-09 | Unknown | Northern Mariana Islands | 30 | 2 | |
220371 | 220371 | 2020-06-08 | Unknown | Northern Mariana Islands | 28 | 2 | |
217279 | 217279 | 2020-06-07 | Unknown | Northern Mariana Islands | 27 | 2 | |
214189 | 214189 | 2020-06-06 | Unknown | Northern Mariana Islands | 26 | 2 | |
211103 | 211103 | 2020-06-05 | Unknown | Northern Mariana Islands | 26 | 2 | |
208021 | 208021 | 2020-06-04 | Unknown | Northern Mariana Islands | 26 | 2 | |
204940 | 204940 | 2020-06-03 | Unknown | Northern Mariana Islands | 24 | 2 | |
201863 | 201863 | 2020-06-02 | Unknown | Northern Mariana Islands | 23 | 2 | |
198788 | 198788 | 2020-06-01 | Unknown | Northern Mariana Islands | 22 | 2 | |
195715 | 195715 | 2020-05-31 | Unknown | Northern Mariana Islands | 22 | 2 | |
192645 | 192645 | 2020-05-30 | Unknown | Northern Mariana Islands | 22 | 2 | |
189581 | 189581 | 2020-05-29 | Unknown | Northern Mariana Islands | 22 | 2 | |
186521 | 186521 | 2020-05-28 | Unknown | Northern Mariana Islands | 22 | 2 | |
183464 | 183464 | 2020-05-27 | Unknown | Northern Mariana Islands | 22 | 2 | |
180415 | 180415 | 2020-05-26 | Unknown | Northern Mariana Islands | 22 | 2 | |
177372 | 177372 | 2020-05-25 | Unknown | Northern Mariana Islands | 22 | 2 | |
174328 | 174328 | 2020-05-24 | Unknown | Northern Mariana Islands | 22 | 2 | |
171286 | 171286 | 2020-05-23 | Unknown | Northern Mariana Islands | 22 | 2 | |
168247 | 168247 | 2020-05-22 | Unknown | Northern Mariana Islands | 22 | 2 | |
165211 | 165211 | 2020-05-21 | Unknown | Northern Mariana Islands | 22 | 2 | |
162182 | 162182 | 2020-05-20 | Unknown | Northern Mariana Islands | 21 | 2 | |
159155 | 159155 | 2020-05-19 | Unknown | Northern Mariana Islands | 21 | 2 | |
156135 | 156135 | 2020-05-18 | Unknown | Northern Mariana Islands | 21 | 2 | |
153118 | 153118 | 2020-05-17 | Unknown | Northern Mariana Islands | 21 | 2 | |
150107 | 150107 | 2020-05-16 | Unknown | Northern Mariana Islands | 21 | 2 | |
147100 | 147100 | 2020-05-15 | Unknown | Northern Mariana Islands | 19 | 2 | |
144099 | 144099 | 2020-05-14 | Unknown | Northern Mariana Islands | 19 | 2 | |
141104 | 141104 | 2020-05-13 | Unknown | Northern Mariana Islands | 19 | 2 |
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);