ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Duplin" and state = "North Carolina" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536349 | 536349 | 2020-09-15 | Duplin | North Carolina | 37061 | 2121 | 52 |
533113 | 533113 | 2020-09-14 | Duplin | North Carolina | 37061 | 2121 | 52 |
529878 | 529878 | 2020-09-13 | Duplin | North Carolina | 37061 | 2121 | 52 |
526641 | 526641 | 2020-09-12 | Duplin | North Carolina | 37061 | 2116 | 52 |
523405 | 523405 | 2020-09-11 | Duplin | North Carolina | 37061 | 2113 | 52 |
520169 | 520169 | 2020-09-10 | Duplin | North Carolina | 37061 | 2106 | 52 |
516933 | 516933 | 2020-09-09 | Duplin | North Carolina | 37061 | 2099 | 52 |
513698 | 513698 | 2020-09-08 | Duplin | North Carolina | 37061 | 2099 | 52 |
510465 | 510465 | 2020-09-07 | Duplin | North Carolina | 37061 | 2098 | 52 |
507232 | 507232 | 2020-09-06 | Duplin | North Carolina | 37061 | 2098 | 52 |
504000 | 504000 | 2020-09-05 | Duplin | North Carolina | 37061 | 2092 | 52 |
500766 | 500766 | 2020-09-04 | Duplin | North Carolina | 37061 | 2089 | 52 |
497532 | 497532 | 2020-09-03 | Duplin | North Carolina | 37061 | 2086 | 52 |
494299 | 494299 | 2020-09-02 | Duplin | North Carolina | 37061 | 2085 | 52 |
491065 | 491065 | 2020-09-01 | Duplin | North Carolina | 37061 | 2085 | 52 |
487832 | 487832 | 2020-08-31 | Duplin | North Carolina | 37061 | 2083 | 52 |
484599 | 484599 | 2020-08-30 | Duplin | North Carolina | 37061 | 2078 | 52 |
481364 | 481364 | 2020-08-29 | Duplin | North Carolina | 37061 | 2076 | 50 |
478131 | 478131 | 2020-08-28 | Duplin | North Carolina | 37061 | 2071 | 50 |
474898 | 474898 | 2020-08-27 | Duplin | North Carolina | 37061 | 2065 | 50 |
471664 | 471664 | 2020-08-26 | Duplin | North Carolina | 37061 | 2061 | 49 |
468432 | 468432 | 2020-08-25 | Duplin | North Carolina | 37061 | 2060 | 49 |
465204 | 465204 | 2020-08-24 | Duplin | North Carolina | 37061 | 2060 | 49 |
461975 | 461975 | 2020-08-23 | Duplin | North Carolina | 37061 | 2055 | 49 |
458747 | 458747 | 2020-08-22 | Duplin | North Carolina | 37061 | 2051 | 49 |
455519 | 455519 | 2020-08-21 | Duplin | North Carolina | 37061 | 2048 | 49 |
452291 | 452291 | 2020-08-20 | Duplin | North Carolina | 37061 | 2043 | 49 |
449063 | 449063 | 2020-08-19 | Duplin | North Carolina | 37061 | 2037 | 49 |
445835 | 445835 | 2020-08-18 | Duplin | North Carolina | 37061 | 2030 | 49 |
442609 | 442609 | 2020-08-17 | Duplin | North Carolina | 37061 | 2025 | 49 |
439382 | 439382 | 2020-08-16 | Duplin | North Carolina | 37061 | 2027 | 49 |
436157 | 436157 | 2020-08-15 | Duplin | North Carolina | 37061 | 2023 | 49 |
432931 | 432931 | 2020-08-14 | Duplin | North Carolina | 37061 | 2019 | 48 |
429705 | 429705 | 2020-08-13 | Duplin | North Carolina | 37061 | 2017 | 48 |
426480 | 426480 | 2020-08-12 | Duplin | North Carolina | 37061 | 2011 | 48 |
423257 | 423257 | 2020-08-11 | Duplin | North Carolina | 37061 | 2016 | 48 |
420034 | 420034 | 2020-08-10 | Duplin | North Carolina | 37061 | 2015 | 48 |
416814 | 416814 | 2020-08-09 | Duplin | North Carolina | 37061 | 2013 | 48 |
413593 | 413593 | 2020-08-08 | Duplin | North Carolina | 37061 | 2006 | 48 |
410373 | 410373 | 2020-08-07 | Duplin | North Carolina | 37061 | 1970 | 48 |
407153 | 407153 | 2020-08-06 | Duplin | North Carolina | 37061 | 1966 | 48 |
403934 | 403934 | 2020-08-05 | Duplin | North Carolina | 37061 | 1961 | 48 |
400716 | 400716 | 2020-08-04 | Duplin | North Carolina | 37061 | 1952 | 47 |
397501 | 397501 | 2020-08-03 | Duplin | North Carolina | 37061 | 1939 | 43 |
394284 | 394284 | 2020-08-02 | Duplin | North Carolina | 37061 | 1937 | 42 |
391068 | 391068 | 2020-08-01 | Duplin | North Carolina | 37061 | 1924 | 42 |
387851 | 387851 | 2020-07-31 | Duplin | North Carolina | 37061 | 1913 | 42 |
384634 | 384634 | 2020-07-30 | Duplin | North Carolina | 37061 | 1900 | 42 |
381416 | 381416 | 2020-07-29 | Duplin | North Carolina | 37061 | 1890 | 42 |
378199 | 378199 | 2020-07-28 | Duplin | North Carolina | 37061 | 1887 | 42 |
374983 | 374983 | 2020-07-27 | Duplin | North Carolina | 37061 | 1874 | 40 |
371771 | 371771 | 2020-07-26 | Duplin | North Carolina | 37061 | 1862 | 40 |
368559 | 368559 | 2020-07-25 | Duplin | North Carolina | 37061 | 1846 | 40 |
365350 | 365350 | 2020-07-24 | Duplin | North Carolina | 37061 | 1831 | 40 |
362144 | 362144 | 2020-07-23 | Duplin | North Carolina | 37061 | 1820 | 40 |
358938 | 358938 | 2020-07-22 | Duplin | North Carolina | 37061 | 1807 | 35 |
355734 | 355734 | 2020-07-21 | Duplin | North Carolina | 37061 | 1787 | 35 |
352531 | 352531 | 2020-07-20 | Duplin | North Carolina | 37061 | 1768 | 35 |
349328 | 349328 | 2020-07-19 | Duplin | North Carolina | 37061 | 1766 | 33 |
346127 | 346127 | 2020-07-18 | Duplin | North Carolina | 37061 | 1742 | 33 |
342928 | 342928 | 2020-07-17 | Duplin | North Carolina | 37061 | 1732 | 33 |
339730 | 339730 | 2020-07-16 | Duplin | North Carolina | 37061 | 1728 | 33 |
336534 | 336534 | 2020-07-15 | Duplin | North Carolina | 37061 | 1720 | 33 |
333340 | 333340 | 2020-07-14 | Duplin | North Carolina | 37061 | 1696 | 33 |
330150 | 330150 | 2020-07-13 | Duplin | North Carolina | 37061 | 1672 | 33 |
326963 | 326963 | 2020-07-12 | Duplin | North Carolina | 37061 | 1667 | 33 |
323779 | 323779 | 2020-07-11 | Duplin | North Carolina | 37061 | 1672 | 33 |
320599 | 320599 | 2020-07-10 | Duplin | North Carolina | 37061 | 1646 | 32 |
317422 | 317422 | 2020-07-09 | Duplin | North Carolina | 37061 | 1637 | 29 |
314248 | 314248 | 2020-07-08 | Duplin | North Carolina | 37061 | 1620 | 28 |
311077 | 311077 | 2020-07-07 | Duplin | North Carolina | 37061 | 1595 | 28 |
307909 | 307909 | 2020-07-06 | Duplin | North Carolina | 37061 | 1579 | 28 |
304742 | 304742 | 2020-07-05 | Duplin | North Carolina | 37061 | 1561 | 28 |
301579 | 301579 | 2020-07-04 | Duplin | North Carolina | 37061 | 1542 | 28 |
298416 | 298416 | 2020-07-03 | Duplin | North Carolina | 37061 | 1533 | 27 |
295256 | 295256 | 2020-07-02 | Duplin | North Carolina | 37061 | 1509 | 27 |
292101 | 292101 | 2020-07-01 | Duplin | North Carolina | 37061 | 1486 | 27 |
288949 | 288949 | 2020-06-30 | Duplin | North Carolina | 37061 | 1468 | 27 |
285799 | 285799 | 2020-06-29 | Duplin | North Carolina | 37061 | 1460 | 27 |
282654 | 282654 | 2020-06-28 | Duplin | North Carolina | 37061 | 1438 | 27 |
279508 | 279508 | 2020-06-27 | Duplin | North Carolina | 37061 | 1422 | 27 |
276360 | 276360 | 2020-06-26 | Duplin | North Carolina | 37061 | 1398 | 21 |
273214 | 273214 | 2020-06-25 | Duplin | North Carolina | 37061 | 1373 | 20 |
270075 | 270075 | 2020-06-24 | Duplin | North Carolina | 37061 | 1369 | 20 |
266941 | 266941 | 2020-06-23 | Duplin | North Carolina | 37061 | 1355 | 20 |
263813 | 263813 | 2020-06-22 | Duplin | North Carolina | 37061 | 1345 | 20 |
260685 | 260685 | 2020-06-21 | Duplin | North Carolina | 37061 | 1332 | 20 |
257558 | 257558 | 2020-06-20 | Duplin | North Carolina | 37061 | 1317 | 20 |
254435 | 254435 | 2020-06-19 | Duplin | North Carolina | 37061 | 1279 | 20 |
251320 | 251320 | 2020-06-18 | Duplin | North Carolina | 37061 | 1257 | 20 |
248205 | 248205 | 2020-06-17 | Duplin | North Carolina | 37061 | 1231 | 20 |
245092 | 245092 | 2020-06-16 | Duplin | North Carolina | 37061 | 1228 | 20 |
241980 | 241980 | 2020-06-15 | Duplin | North Carolina | 37061 | 1213 | 20 |
238871 | 238871 | 2020-06-14 | Duplin | North Carolina | 37061 | 1182 | 20 |
235763 | 235763 | 2020-06-13 | Duplin | North Carolina | 37061 | 1150 | 20 |
232658 | 232658 | 2020-06-12 | Duplin | North Carolina | 37061 | 1130 | 20 |
229553 | 229553 | 2020-06-11 | Duplin | North Carolina | 37061 | 1096 | 20 |
226449 | 226449 | 2020-06-10 | Duplin | North Carolina | 37061 | 1072 | 20 |
223349 | 223349 | 2020-06-09 | Duplin | North Carolina | 37061 | 1062 | 20 |
220255 | 220255 | 2020-06-08 | Duplin | North Carolina | 37061 | 1047 | 19 |
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);