ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
759 rows where county = "Nome Census Area" and state = "Alaska" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
531271 | 531271 | 2020-09-14 | Nome Census Area | Alaska | 2180 | 54 | 0 |
528034 | 528034 | 2020-09-13 | Nome Census Area | Alaska | 2180 | 54 | 0 |
524798 | 524798 | 2020-09-12 | Nome Census Area | Alaska | 2180 | 54 | 0 |
521562 | 521562 | 2020-09-11 | Nome Census Area | Alaska | 2180 | 52 | 0 |
518325 | 518325 | 2020-09-10 | Nome Census Area | Alaska | 2180 | 51 | 0 |
515090 | 515090 | 2020-09-09 | Nome Census Area | Alaska | 2180 | 51 | 0 |
511857 | 511857 | 2020-09-08 | Nome Census Area | Alaska | 2180 | 50 | 0 |
508624 | 508624 | 2020-09-07 | Nome Census Area | Alaska | 2180 | 50 | 0 |
505392 | 505392 | 2020-09-06 | Nome Census Area | Alaska | 2180 | 49 | 0 |
502158 | 502158 | 2020-09-05 | Nome Census Area | Alaska | 2180 | 48 | 0 |
498924 | 498924 | 2020-09-04 | Nome Census Area | Alaska | 2180 | 48 | 0 |
495691 | 495691 | 2020-09-03 | Nome Census Area | Alaska | 2180 | 48 | 0 |
492457 | 492457 | 2020-09-02 | Nome Census Area | Alaska | 2180 | 45 | 0 |
489224 | 489224 | 2020-09-01 | Nome Census Area | Alaska | 2180 | 45 | 0 |
485991 | 485991 | 2020-08-31 | Nome Census Area | Alaska | 2180 | 45 | 0 |
482756 | 482756 | 2020-08-30 | Nome Census Area | Alaska | 2180 | 43 | 0 |
479522 | 479522 | 2020-08-29 | Nome Census Area | Alaska | 2180 | 40 | 0 |
476289 | 476289 | 2020-08-28 | Nome Census Area | Alaska | 2180 | 39 | 0 |
473056 | 473056 | 2020-08-27 | Nome Census Area | Alaska | 2180 | 36 | 0 |
469824 | 469824 | 2020-08-26 | Nome Census Area | Alaska | 2180 | 36 | 0 |
466595 | 466595 | 2020-08-25 | Nome Census Area | Alaska | 2180 | 36 | 0 |
463366 | 463366 | 2020-08-24 | Nome Census Area | Alaska | 2180 | 34 | 0 |
460137 | 460137 | 2020-08-23 | Nome Census Area | Alaska | 2180 | 34 | 0 |
456910 | 456910 | 2020-08-22 | Nome Census Area | Alaska | 2180 | 33 | 0 |
453682 | 453682 | 2020-08-21 | Nome Census Area | Alaska | 2180 | 33 | 0 |
450454 | 450454 | 2020-08-20 | Nome Census Area | Alaska | 2180 | 30 | 0 |
447226 | 447226 | 2020-08-19 | Nome Census Area | Alaska | 2180 | 29 | 0 |
443999 | 443999 | 2020-08-18 | Nome Census Area | Alaska | 2180 | 29 | 0 |
440773 | 440773 | 2020-08-17 | Nome Census Area | Alaska | 2180 | 29 | 0 |
437547 | 437547 | 2020-08-16 | Nome Census Area | Alaska | 2180 | 27 | 0 |
434321 | 434321 | 2020-08-15 | Nome Census Area | Alaska | 2180 | 27 | 0 |
431096 | 431096 | 2020-08-14 | Nome Census Area | Alaska | 2180 | 27 | 0 |
427868 | 427868 | 2020-08-13 | Nome Census Area | Alaska | 2180 | 27 | 0 |
424644 | 424644 | 2020-08-12 | Nome Census Area | Alaska | 2180 | 22 | 0 |
421423 | 421423 | 2020-08-11 | Nome Census Area | Alaska | 2180 | 22 | 0 |
418202 | 418202 | 2020-08-10 | Nome Census Area | Alaska | 2180 | 22 | 0 |
414981 | 414981 | 2020-08-09 | Nome Census Area | Alaska | 2180 | 22 | 0 |
411761 | 411761 | 2020-08-08 | Nome Census Area | Alaska | 2180 | 22 | 0 |
408542 | 408542 | 2020-08-07 | Nome Census Area | Alaska | 2180 | 22 | 0 |
405322 | 405322 | 2020-08-06 | Nome Census Area | Alaska | 2180 | 22 | 0 |
402104 | 402104 | 2020-08-05 | Nome Census Area | Alaska | 2180 | 22 | 0 |
398888 | 398888 | 2020-08-04 | Nome Census Area | Alaska | 2180 | 22 | 0 |
395672 | 395672 | 2020-08-03 | Nome Census Area | Alaska | 2180 | 20 | 0 |
392456 | 392456 | 2020-08-02 | Nome Census Area | Alaska | 2180 | 20 | 0 |
389239 | 389239 | 2020-08-01 | Nome Census Area | Alaska | 2180 | 20 | 0 |
386022 | 386022 | 2020-07-31 | Nome Census Area | Alaska | 2180 | 20 | 0 |
382804 | 382804 | 2020-07-30 | Nome Census Area | Alaska | 2180 | 20 | 0 |
379587 | 379587 | 2020-07-29 | Nome Census Area | Alaska | 2180 | 20 | 0 |
376371 | 376371 | 2020-07-28 | Nome Census Area | Alaska | 2180 | 20 | 0 |
373157 | 373157 | 2020-07-27 | Nome Census Area | Alaska | 2180 | 20 | 0 |
369945 | 369945 | 2020-07-26 | Nome Census Area | Alaska | 2180 | 20 | 0 |
366735 | 366735 | 2020-07-25 | Nome Census Area | Alaska | 2180 | 20 | 0 |
363528 | 363528 | 2020-07-24 | Nome Census Area | Alaska | 2180 | 20 | 0 |
360322 | 360322 | 2020-07-23 | Nome Census Area | Alaska | 2180 | 19 | 0 |
357117 | 357117 | 2020-07-22 | Nome Census Area | Alaska | 2180 | 19 | 0 |
353914 | 353914 | 2020-07-21 | Nome Census Area | Alaska | 2180 | 19 | 0 |
350712 | 350712 | 2020-07-20 | Nome Census Area | Alaska | 2180 | 19 | 0 |
347511 | 347511 | 2020-07-19 | Nome Census Area | Alaska | 2180 | 19 | 0 |
344311 | 344311 | 2020-07-18 | Nome Census Area | Alaska | 2180 | 18 | 0 |
341112 | 341112 | 2020-07-17 | Nome Census Area | Alaska | 2180 | 18 | 0 |
337916 | 337916 | 2020-07-16 | Nome Census Area | Alaska | 2180 | 18 | 0 |
334721 | 334721 | 2020-07-15 | Nome Census Area | Alaska | 2180 | 18 | 0 |
331528 | 331528 | 2020-07-14 | Nome Census Area | Alaska | 2180 | 18 | 0 |
328342 | 328342 | 2020-07-13 | Nome Census Area | Alaska | 2180 | 18 | 0 |
325156 | 325156 | 2020-07-12 | Nome Census Area | Alaska | 2180 | 18 | 0 |
321975 | 321975 | 2020-07-11 | Nome Census Area | Alaska | 2180 | 15 | 0 |
318796 | 318796 | 2020-07-10 | Nome Census Area | Alaska | 2180 | 14 | 0 |
315623 | 315623 | 2020-07-09 | Nome Census Area | Alaska | 2180 | 12 | 0 |
312448 | 312448 | 2020-07-08 | Nome Census Area | Alaska | 2180 | 11 | 0 |
309279 | 309279 | 2020-07-07 | Nome Census Area | Alaska | 2180 | 11 | 0 |
306110 | 306110 | 2020-07-06 | Nome Census Area | Alaska | 2180 | 11 | 0 |
302946 | 302946 | 2020-07-05 | Nome Census Area | Alaska | 2180 | 11 | 0 |
299782 | 299782 | 2020-07-04 | Nome Census Area | Alaska | 2180 | 11 | 0 |
296620 | 296620 | 2020-07-03 | Nome Census Area | Alaska | 2180 | 11 | 0 |
293464 | 293464 | 2020-07-02 | Nome Census Area | Alaska | 2180 | 10 | 0 |
290311 | 290311 | 2020-07-01 | Nome Census Area | Alaska | 2180 | 10 | 0 |
287161 | 287161 | 2020-06-30 | Nome Census Area | Alaska | 2180 | 9 | 0 |
284015 | 284015 | 2020-06-29 | Nome Census Area | Alaska | 2180 | 9 | 0 |
280869 | 280869 | 2020-06-28 | Nome Census Area | Alaska | 2180 | 8 | 0 |
277721 | 277721 | 2020-06-27 | Nome Census Area | Alaska | 2180 | 8 | 0 |
274573 | 274573 | 2020-06-26 | Nome Census Area | Alaska | 2180 | 8 | 0 |
271433 | 271433 | 2020-06-25 | Nome Census Area | Alaska | 2180 | 7 | 0 |
268298 | 268298 | 2020-06-24 | Nome Census Area | Alaska | 2180 | 7 | 0 |
265169 | 265169 | 2020-06-23 | Nome Census Area | Alaska | 2180 | 7 | 0 |
262040 | 262040 | 2020-06-22 | Nome Census Area | Alaska | 2180 | 6 | 0 |
258913 | 258913 | 2020-06-21 | Nome Census Area | Alaska | 2180 | 6 | 0 |
255786 | 255786 | 2020-06-20 | Nome Census Area | Alaska | 2180 | 6 | 0 |
252667 | 252667 | 2020-06-19 | Nome Census Area | Alaska | 2180 | 6 | 0 |
249552 | 249552 | 2020-06-18 | Nome Census Area | Alaska | 2180 | 6 | 0 |
246440 | 246440 | 2020-06-17 | Nome Census Area | Alaska | 2180 | 6 | 0 |
243327 | 243327 | 2020-06-16 | Nome Census Area | Alaska | 2180 | 5 | 0 |
240216 | 240216 | 2020-06-15 | Nome Census Area | Alaska | 2180 | 5 | 0 |
237108 | 237108 | 2020-06-14 | Nome Census Area | Alaska | 2180 | 5 | 0 |
234001 | 234001 | 2020-06-13 | Nome Census Area | Alaska | 2180 | 5 | 0 |
230896 | 230896 | 2020-06-12 | Nome Census Area | Alaska | 2180 | 4 | 0 |
227792 | 227792 | 2020-06-11 | Nome Census Area | Alaska | 2180 | 4 | 0 |
224691 | 224691 | 2020-06-10 | Nome Census Area | Alaska | 2180 | 4 | 0 |
221595 | 221595 | 2020-06-09 | Nome Census Area | Alaska | 2180 | 4 | 0 |
218501 | 218501 | 2020-06-08 | Nome Census Area | Alaska | 2180 | 3 | 0 |
215411 | 215411 | 2020-06-07 | Nome Census Area | Alaska | 2180 | 3 | 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);