ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
716 rows where county = "North Slope Borough" and state = "Alaska" sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
184671 | 184671 | 2020-05-28 | North Slope Borough | Alaska | 2185 | 1 | 0 |
187728 | 187728 | 2020-05-29 | North Slope Borough | Alaska | 2185 | 1 | 0 |
190792 | 190792 | 2020-05-30 | North Slope Borough | Alaska | 2185 | 1 | 0 |
193859 | 193859 | 2020-05-31 | North Slope Borough | Alaska | 2185 | 1 | 0 |
196929 | 196929 | 2020-06-01 | North Slope Borough | Alaska | 2185 | 1 | 0 |
200002 | 200002 | 2020-06-02 | North Slope Borough | Alaska | 2185 | 1 | 0 |
203078 | 203078 | 2020-06-03 | North Slope Borough | Alaska | 2185 | 1 | 0 |
206158 | 206158 | 2020-06-04 | North Slope Borough | Alaska | 2185 | 1 | 0 |
209240 | 209240 | 2020-06-05 | North Slope Borough | Alaska | 2185 | 1 | 0 |
212325 | 212325 | 2020-06-06 | North Slope Borough | Alaska | 2185 | 1 | 0 |
215412 | 215412 | 2020-06-07 | North Slope Borough | Alaska | 2185 | 1 | 0 |
218502 | 218502 | 2020-06-08 | North Slope Borough | Alaska | 2185 | 1 | 0 |
221596 | 221596 | 2020-06-09 | North Slope Borough | Alaska | 2185 | 1 | 0 |
224692 | 224692 | 2020-06-10 | North Slope Borough | Alaska | 2185 | 1 | 0 |
227793 | 227793 | 2020-06-11 | North Slope Borough | Alaska | 2185 | 1 | 0 |
230897 | 230897 | 2020-06-12 | North Slope Borough | Alaska | 2185 | 1 | 0 |
234002 | 234002 | 2020-06-13 | North Slope Borough | Alaska | 2185 | 1 | 0 |
237109 | 237109 | 2020-06-14 | North Slope Borough | Alaska | 2185 | 1 | 0 |
240217 | 240217 | 2020-06-15 | North Slope Borough | Alaska | 2185 | 1 | 0 |
243328 | 243328 | 2020-06-16 | North Slope Borough | Alaska | 2185 | 1 | 0 |
246441 | 246441 | 2020-06-17 | North Slope Borough | Alaska | 2185 | 2 | 0 |
249553 | 249553 | 2020-06-18 | North Slope Borough | Alaska | 2185 | 2 | 0 |
252668 | 252668 | 2020-06-19 | North Slope Borough | Alaska | 2185 | 3 | 0 |
255787 | 255787 | 2020-06-20 | North Slope Borough | Alaska | 2185 | 3 | 0 |
258914 | 258914 | 2020-06-21 | North Slope Borough | Alaska | 2185 | 3 | 0 |
262041 | 262041 | 2020-06-22 | North Slope Borough | Alaska | 2185 | 4 | 0 |
265170 | 265170 | 2020-06-23 | North Slope Borough | Alaska | 2185 | 4 | 0 |
268299 | 268299 | 2020-06-24 | North Slope Borough | Alaska | 2185 | 4 | 0 |
271434 | 271434 | 2020-06-25 | North Slope Borough | Alaska | 2185 | 4 | 0 |
274574 | 274574 | 2020-06-26 | North Slope Borough | Alaska | 2185 | 4 | 0 |
277722 | 277722 | 2020-06-27 | North Slope Borough | Alaska | 2185 | 4 | 0 |
280870 | 280870 | 2020-06-28 | North Slope Borough | Alaska | 2185 | 4 | 0 |
284016 | 284016 | 2020-06-29 | North Slope Borough | Alaska | 2185 | 4 | 0 |
287162 | 287162 | 2020-06-30 | North Slope Borough | Alaska | 2185 | 4 | 0 |
290312 | 290312 | 2020-07-01 | North Slope Borough | Alaska | 2185 | 4 | 0 |
293465 | 293465 | 2020-07-02 | North Slope Borough | Alaska | 2185 | 4 | 0 |
296621 | 296621 | 2020-07-03 | North Slope Borough | Alaska | 2185 | 4 | 0 |
299783 | 299783 | 2020-07-04 | North Slope Borough | Alaska | 2185 | 4 | 0 |
302947 | 302947 | 2020-07-05 | North Slope Borough | Alaska | 2185 | 4 | 0 |
306111 | 306111 | 2020-07-06 | North Slope Borough | Alaska | 2185 | 4 | 0 |
309280 | 309280 | 2020-07-07 | North Slope Borough | Alaska | 2185 | 4 | 0 |
312449 | 312449 | 2020-07-08 | North Slope Borough | Alaska | 2185 | 4 | 0 |
315624 | 315624 | 2020-07-09 | North Slope Borough | Alaska | 2185 | 4 | 0 |
318797 | 318797 | 2020-07-10 | North Slope Borough | Alaska | 2185 | 4 | 0 |
321976 | 321976 | 2020-07-11 | North Slope Borough | Alaska | 2185 | 4 | 0 |
325157 | 325157 | 2020-07-12 | North Slope Borough | Alaska | 2185 | 5 | 0 |
328343 | 328343 | 2020-07-13 | North Slope Borough | Alaska | 2185 | 6 | 0 |
331529 | 331529 | 2020-07-14 | North Slope Borough | Alaska | 2185 | 6 | 0 |
334722 | 334722 | 2020-07-15 | North Slope Borough | Alaska | 2185 | 6 | 0 |
337917 | 337917 | 2020-07-16 | North Slope Borough | Alaska | 2185 | 6 | 0 |
341113 | 341113 | 2020-07-17 | North Slope Borough | Alaska | 2185 | 6 | 0 |
344312 | 344312 | 2020-07-18 | North Slope Borough | Alaska | 2185 | 7 | 0 |
347512 | 347512 | 2020-07-19 | North Slope Borough | Alaska | 2185 | 7 | 0 |
350713 | 350713 | 2020-07-20 | North Slope Borough | Alaska | 2185 | 7 | 0 |
353915 | 353915 | 2020-07-21 | North Slope Borough | Alaska | 2185 | 8 | 0 |
357118 | 357118 | 2020-07-22 | North Slope Borough | Alaska | 2185 | 9 | 0 |
360323 | 360323 | 2020-07-23 | North Slope Borough | Alaska | 2185 | 9 | 0 |
363529 | 363529 | 2020-07-24 | North Slope Borough | Alaska | 2185 | 9 | 0 |
366736 | 366736 | 2020-07-25 | North Slope Borough | Alaska | 2185 | 9 | 0 |
369946 | 369946 | 2020-07-26 | North Slope Borough | Alaska | 2185 | 9 | 0 |
373158 | 373158 | 2020-07-27 | North Slope Borough | Alaska | 2185 | 12 | 0 |
376372 | 376372 | 2020-07-28 | North Slope Borough | Alaska | 2185 | 13 | 0 |
379588 | 379588 | 2020-07-29 | North Slope Borough | Alaska | 2185 | 14 | 0 |
382805 | 382805 | 2020-07-30 | North Slope Borough | Alaska | 2185 | 15 | 0 |
386023 | 386023 | 2020-07-31 | North Slope Borough | Alaska | 2185 | 15 | 0 |
389240 | 389240 | 2020-08-01 | North Slope Borough | Alaska | 2185 | 15 | 0 |
392457 | 392457 | 2020-08-02 | North Slope Borough | Alaska | 2185 | 15 | 0 |
395673 | 395673 | 2020-08-03 | North Slope Borough | Alaska | 2185 | 17 | 0 |
398889 | 398889 | 2020-08-04 | North Slope Borough | Alaska | 2185 | 18 | 0 |
402105 | 402105 | 2020-08-05 | North Slope Borough | Alaska | 2185 | 18 | 0 |
405323 | 405323 | 2020-08-06 | North Slope Borough | Alaska | 2185 | 18 | 0 |
408543 | 408543 | 2020-08-07 | North Slope Borough | Alaska | 2185 | 18 | 0 |
411762 | 411762 | 2020-08-08 | North Slope Borough | Alaska | 2185 | 21 | 0 |
414982 | 414982 | 2020-08-09 | North Slope Borough | Alaska | 2185 | 21 | 0 |
418203 | 418203 | 2020-08-10 | North Slope Borough | Alaska | 2185 | 21 | 0 |
421424 | 421424 | 2020-08-11 | North Slope Borough | Alaska | 2185 | 22 | 0 |
424645 | 424645 | 2020-08-12 | North Slope Borough | Alaska | 2185 | 22 | 0 |
427869 | 427869 | 2020-08-13 | North Slope Borough | Alaska | 2185 | 23 | 0 |
431097 | 431097 | 2020-08-14 | North Slope Borough | Alaska | 2185 | 26 | 0 |
434322 | 434322 | 2020-08-15 | North Slope Borough | Alaska | 2185 | 27 | 0 |
437548 | 437548 | 2020-08-16 | North Slope Borough | Alaska | 2185 | 29 | 0 |
440774 | 440774 | 2020-08-17 | North Slope Borough | Alaska | 2185 | 30 | 0 |
444000 | 444000 | 2020-08-18 | North Slope Borough | Alaska | 2185 | 30 | 0 |
447227 | 447227 | 2020-08-19 | North Slope Borough | Alaska | 2185 | 32 | 0 |
450455 | 450455 | 2020-08-20 | North Slope Borough | Alaska | 2185 | 34 | 0 |
453683 | 453683 | 2020-08-21 | North Slope Borough | Alaska | 2185 | 35 | 0 |
456911 | 456911 | 2020-08-22 | North Slope Borough | Alaska | 2185 | 36 | 0 |
460138 | 460138 | 2020-08-23 | North Slope Borough | Alaska | 2185 | 36 | 0 |
463367 | 463367 | 2020-08-24 | North Slope Borough | Alaska | 2185 | 36 | 0 |
466596 | 466596 | 2020-08-25 | North Slope Borough | Alaska | 2185 | 38 | 0 |
469825 | 469825 | 2020-08-26 | North Slope Borough | Alaska | 2185 | 38 | 0 |
473057 | 473057 | 2020-08-27 | North Slope Borough | Alaska | 2185 | 39 | 0 |
476290 | 476290 | 2020-08-28 | North Slope Borough | Alaska | 2185 | 41 | 0 |
479523 | 479523 | 2020-08-29 | North Slope Borough | Alaska | 2185 | 40 | 0 |
482757 | 482757 | 2020-08-30 | North Slope Borough | Alaska | 2185 | 43 | 0 |
485992 | 485992 | 2020-08-31 | North Slope Borough | Alaska | 2185 | 43 | 0 |
489225 | 489225 | 2020-09-01 | North Slope Borough | Alaska | 2185 | 43 | 0 |
492458 | 492458 | 2020-09-02 | North Slope Borough | Alaska | 2185 | 45 | 0 |
495692 | 495692 | 2020-09-03 | North Slope Borough | Alaska | 2185 | 46 | 0 |
498925 | 498925 | 2020-09-04 | North Slope Borough | Alaska | 2185 | 47 | 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);