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 state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
17034 | 17034 | 2020-03-28 | Unknown | Northern Mariana Islands | 2 | 0 | |
18968 | 18968 | 2020-03-29 | Unknown | Northern Mariana Islands | 2 | 0 | |
21011 | 21011 | 2020-03-30 | Unknown | Northern Mariana Islands | 2 | 0 | |
23143 | 23143 | 2020-03-31 | Unknown | Northern Mariana Islands | 2 | 0 | |
25338 | 25338 | 2020-04-01 | Unknown | Northern Mariana Islands | 6 | 1 | |
27604 | 27604 | 2020-04-02 | Unknown | Northern Mariana Islands | 8 | 1 | |
29933 | 29933 | 2020-04-03 | Unknown | Northern Mariana Islands | 8 | 1 | |
32321 | 32321 | 2020-04-04 | Unknown | Northern Mariana Islands | 8 | 1 | |
34754 | 34754 | 2020-04-05 | Unknown | Northern Mariana Islands | 8 | 1 | |
37223 | 37223 | 2020-04-06 | Unknown | Northern Mariana Islands | 8 | 1 | |
39740 | 39740 | 2020-04-07 | Unknown | Northern Mariana Islands | 8 | 2 | |
42298 | 42298 | 2020-04-08 | Unknown | Northern Mariana Islands | 11 | 2 | |
44883 | 44883 | 2020-04-09 | Unknown | Northern Mariana Islands | 11 | 2 | |
47498 | 47498 | 2020-04-10 | Unknown | Northern Mariana Islands | 11 | 2 | |
50153 | 50153 | 2020-04-11 | Unknown | Northern Mariana Islands | 11 | 2 | |
52826 | 52826 | 2020-04-12 | Unknown | Northern Mariana Islands | 11 | 2 | |
55510 | 55510 | 2020-04-13 | Unknown | Northern Mariana Islands | 11 | 2 | |
58211 | 58211 | 2020-04-14 | Unknown | Northern Mariana Islands | 13 | 2 | |
60925 | 60925 | 2020-04-15 | Unknown | Northern Mariana Islands | 13 | 2 | |
63651 | 63651 | 2020-04-16 | Unknown | Northern Mariana Islands | 13 | 2 | |
66394 | 66394 | 2020-04-17 | Unknown | Northern Mariana Islands | 14 | 2 | |
69151 | 69151 | 2020-04-18 | Unknown | Northern Mariana Islands | 14 | 2 | |
71918 | 71918 | 2020-04-19 | Unknown | Northern Mariana Islands | 14 | 2 | |
74693 | 74693 | 2020-04-20 | Unknown | Northern Mariana Islands | 14 | 2 | |
77474 | 77474 | 2020-04-21 | Unknown | Northern Mariana Islands | 14 | 2 | |
80264 | 80264 | 2020-04-22 | Unknown | Northern Mariana Islands | 14 | 2 | |
83063 | 83063 | 2020-04-23 | Unknown | Northern Mariana Islands | 14 | 2 | |
85867 | 85867 | 2020-04-24 | Unknown | Northern Mariana Islands | 14 | 2 | |
88681 | 88681 | 2020-04-25 | Unknown | Northern Mariana Islands | 14 | 2 | |
91497 | 91497 | 2020-04-26 | Unknown | Northern Mariana Islands | 14 | 2 | |
94323 | 94323 | 2020-04-27 | Unknown | Northern Mariana Islands | 14 | 2 | |
97160 | 97160 | 2020-04-28 | Unknown | Northern Mariana Islands | 14 | 2 | |
100009 | 100009 | 2020-04-29 | Unknown | Northern Mariana Islands | 14 | 2 | |
102862 | 102862 | 2020-04-30 | Unknown | Northern Mariana Islands | 14 | 2 | |
105725 | 105725 | 2020-05-01 | Unknown | Northern Mariana Islands | 14 | 2 | |
108592 | 108592 | 2020-05-02 | Unknown | Northern Mariana Islands | 14 | 2 | |
111466 | 111466 | 2020-05-03 | Unknown | Northern Mariana Islands | 14 | 2 | |
114347 | 114347 | 2020-05-04 | Unknown | Northern Mariana Islands | 14 | 2 | |
117228 | 117228 | 2020-05-05 | Unknown | Northern Mariana Islands | 14 | 2 | |
120189 | 120189 | 2020-05-06 | Unknown | Northern Mariana Islands | 15 | 2 | |
123166 | 123166 | 2020-05-07 | Unknown | Northern Mariana Islands | 15 | 2 | |
126149 | 126149 | 2020-05-08 | Unknown | Northern Mariana Islands | 15 | 2 | |
129138 | 129138 | 2020-05-09 | Unknown | Northern Mariana Islands | 16 | 2 | |
132127 | 132127 | 2020-05-10 | Unknown | Northern Mariana Islands | 16 | 2 | |
135118 | 135118 | 2020-05-11 | Unknown | Northern Mariana Islands | 19 | 2 | |
138108 | 138108 | 2020-05-12 | Unknown | Northern Mariana Islands | 19 | 2 | |
141104 | 141104 | 2020-05-13 | Unknown | Northern Mariana Islands | 19 | 2 | |
144099 | 144099 | 2020-05-14 | Unknown | Northern Mariana Islands | 19 | 2 | |
147100 | 147100 | 2020-05-15 | Unknown | Northern Mariana Islands | 19 | 2 | |
150107 | 150107 | 2020-05-16 | Unknown | Northern Mariana Islands | 21 | 2 | |
153118 | 153118 | 2020-05-17 | Unknown | Northern Mariana Islands | 21 | 2 | |
156135 | 156135 | 2020-05-18 | Unknown | Northern Mariana Islands | 21 | 2 | |
159155 | 159155 | 2020-05-19 | Unknown | Northern Mariana Islands | 21 | 2 | |
162182 | 162182 | 2020-05-20 | Unknown | Northern Mariana Islands | 21 | 2 | |
165211 | 165211 | 2020-05-21 | Unknown | Northern Mariana Islands | 22 | 2 | |
168247 | 168247 | 2020-05-22 | Unknown | Northern Mariana Islands | 22 | 2 | |
171286 | 171286 | 2020-05-23 | Unknown | Northern Mariana Islands | 22 | 2 | |
174328 | 174328 | 2020-05-24 | Unknown | Northern Mariana Islands | 22 | 2 | |
177372 | 177372 | 2020-05-25 | Unknown | Northern Mariana Islands | 22 | 2 | |
180415 | 180415 | 2020-05-26 | Unknown | Northern Mariana Islands | 22 | 2 | |
183464 | 183464 | 2020-05-27 | Unknown | Northern Mariana Islands | 22 | 2 | |
186521 | 186521 | 2020-05-28 | Unknown | Northern Mariana Islands | 22 | 2 | |
189581 | 189581 | 2020-05-29 | Unknown | Northern Mariana Islands | 22 | 2 | |
192645 | 192645 | 2020-05-30 | Unknown | Northern Mariana Islands | 22 | 2 | |
195715 | 195715 | 2020-05-31 | Unknown | Northern Mariana Islands | 22 | 2 | |
198788 | 198788 | 2020-06-01 | Unknown | Northern Mariana Islands | 22 | 2 | |
201863 | 201863 | 2020-06-02 | Unknown | Northern Mariana Islands | 23 | 2 | |
204940 | 204940 | 2020-06-03 | Unknown | Northern Mariana Islands | 24 | 2 | |
208021 | 208021 | 2020-06-04 | Unknown | Northern Mariana Islands | 26 | 2 | |
211103 | 211103 | 2020-06-05 | Unknown | Northern Mariana Islands | 26 | 2 | |
214189 | 214189 | 2020-06-06 | Unknown | Northern Mariana Islands | 26 | 2 | |
217279 | 217279 | 2020-06-07 | Unknown | Northern Mariana Islands | 27 | 2 | |
220371 | 220371 | 2020-06-08 | Unknown | Northern Mariana Islands | 28 | 2 | |
223466 | 223466 | 2020-06-09 | Unknown | Northern Mariana Islands | 30 | 2 | |
226566 | 226566 | 2020-06-10 | Unknown | Northern Mariana Islands | 30 | 2 | |
229670 | 229670 | 2020-06-11 | Unknown | Northern Mariana Islands | 30 | 2 | |
232775 | 232775 | 2020-06-12 | Unknown | Northern Mariana Islands | 30 | 2 | |
235880 | 235880 | 2020-06-13 | Unknown | Northern Mariana Islands | 30 | 2 | |
238988 | 238988 | 2020-06-14 | Unknown | Northern Mariana Islands | 30 | 2 | |
242097 | 242097 | 2020-06-15 | Unknown | Northern Mariana Islands | 30 | 2 | |
245209 | 245209 | 2020-06-16 | Unknown | Northern Mariana Islands | 30 | 2 | |
248322 | 248322 | 2020-06-17 | Unknown | Northern Mariana Islands | 30 | 2 | |
251437 | 251437 | 2020-06-18 | Unknown | Northern Mariana Islands | 30 | 2 | |
254552 | 254552 | 2020-06-19 | Unknown | Northern Mariana Islands | 30 | 2 | |
257677 | 257677 | 2020-06-20 | Unknown | Northern Mariana Islands | 30 | 2 | |
260804 | 260804 | 2020-06-21 | Unknown | Northern Mariana Islands | 30 | 2 | |
263932 | 263932 | 2020-06-22 | Unknown | Northern Mariana Islands | 30 | 2 | |
267060 | 267060 | 2020-06-23 | Unknown | Northern Mariana Islands | 30 | 2 | |
270194 | 270194 | 2020-06-24 | Unknown | Northern Mariana Islands | 30 | 2 | |
273333 | 273333 | 2020-06-25 | Unknown | Northern Mariana Islands | 30 | 2 | |
276480 | 276480 | 2020-06-26 | Unknown | Northern Mariana Islands | 30 | 2 | |
279628 | 279628 | 2020-06-27 | Unknown | Northern Mariana Islands | 30 | 2 | |
282774 | 282774 | 2020-06-28 | Unknown | Northern Mariana Islands | 30 | 2 | |
285919 | 285919 | 2020-06-29 | Unknown | Northern Mariana Islands | 30 | 2 | |
289069 | 289069 | 2020-06-30 | Unknown | Northern Mariana Islands | 30 | 2 | |
292221 | 292221 | 2020-07-01 | Unknown | Northern Mariana Islands | 30 | 2 | |
295376 | 295376 | 2020-07-02 | Unknown | Northern Mariana Islands | 30 | 2 | |
298536 | 298536 | 2020-07-03 | Unknown | Northern Mariana Islands | 31 | 2 | |
301699 | 301699 | 2020-07-04 | Unknown | Northern Mariana Islands | 31 | 2 | |
304862 | 304862 | 2020-07-05 | Unknown | Northern Mariana Islands | 31 | 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);