ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,832 rows where state = "Northern Mariana Islands" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, deaths, date (date)
cases 213 ✖
- 2 346
- 6 116
- 1 94
- 181 89
- 53 43
- 341 43
- 415 43
- 10397 43
- 233 33
- 183 32
- 9308 32
- 389 30
- 24 28
- 66 27
- 5190 27
- 30 24
- 9 21
- 14 21
- 8 20
- 11 20
- 5 17
- 21 17
- 15 16
- 3507 14
- 31 13
- 157 13
- 22 12
- 68 12
- 4090 12
- 120 11
- 131 10
- 141 10
- 2954 10
- 4 9
- 7 9
- 110 9
- 111 9
- 336 9
- 127 8
- 129 8
- 152 8
- 158 8
- 160 8
- 36 7
- 50 7
- 86 7
- 98 7
- 100 7
- 102 7
- 104 7
- 126 7
- 162 7
- 235 7
- 306 7
- 2110 7
- 13 6
- 37 6
- 41 6
- 43 6
- 90 6
- 132 6
- 155 6
- 166 6
- 179 6
- 259 6
- 267 6
- 285 6
- 19 5
- 39 5
- 73 5
- 75 5
- 94 5
- 123 5
- 142 5
- 144 5
- 168 5
- 252 5
- 276 5
- 3 4
- 23 4
- 48 4
- 128 4
- 133 4
- 274 4
- 283 4
- 284 4
- 317 4
- 350 4
- 1298 4
- 2411 4
- 26 3
- 27 3
- 28 3
- 33 3
- 45 3
- 47 3
- 49 3
- 84 3
- 96 3
- 113 3
- 116 3
- 167 3
- 170 3
- 228 3
- 244 3
- 264 3
- 387 3
- 655 3
- 709 3
- 787 3
- 965 3
- 1119 3
- 1341 3
- 2073 3
- 16 2
- 35 2
- 46 2
- 78 2
- 79 2
- 114 2
- 122 2
- 156 2
- 172 2
- 174 2
- 242 2
- 243 2
- 262 2
- 266 2
- 275 2
- 460 2
- 676 2
- 1513 2
- 34 1
- 44 1
- 52 1
- 63 1
- 69 1
- 71 1
- 80 1
- 89 1
- 107 1
- 109 1
- 145 1
- 146 1
- 147 1
- 159 1
- 180 1
- 198 1
- 202 1
- 209 1
- 224 1
- 225 1
- 226 1
- 245 1
- 246 1
- 250 1
- 254 1
- 256 1
- 257 1
- 261 1
- 263 1
- 292 1
- 295 1
- 303 1
- 321 1
- 324 1
- 334 1
- 371 1
- 407 1
- 429 1
- 445 1
- 453 1
- 461 1
- 490 1
- 496 1
- 505 1
- 522 1
- 549 1
- 560 1
- 573 1
- 602 1
- 611 1
- 653 1
- 667 1
- 748 1
- 811 1
- 822 1
- 851 1
- 910 1
- 1010 1
- 1052 1
- 1053 1
- 1261 1
- 1273 1
- 1283 1
- 1504 1
- 1623 1
- 1722 1
- 1730 1
- 1919 1
- 2466 1
- 2647 1
- 2873 1
- 3031 1
- 3142 1
- 3364 1
- 3431 1
- 3602 1
- 3828 1
- 3985 1
- 4124 1
- 4254 1
- 4315 1
state 1
- Northern Mariana Islands · 1,832 ✖
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);