ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Edgecombe" 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 |
---|---|---|---|---|---|---|---|
536351 | 536351 | 2020-09-15 | Edgecombe | North Carolina | 37065 | 1189 | 36 |
533115 | 533115 | 2020-09-14 | Edgecombe | North Carolina | 37065 | 1175 | 30 |
529880 | 529880 | 2020-09-13 | Edgecombe | North Carolina | 37065 | 1171 | 30 |
526643 | 526643 | 2020-09-12 | Edgecombe | North Carolina | 37065 | 1157 | 30 |
523407 | 523407 | 2020-09-11 | Edgecombe | North Carolina | 37065 | 1146 | 27 |
520171 | 520171 | 2020-09-10 | Edgecombe | North Carolina | 37065 | 1110 | 23 |
516935 | 516935 | 2020-09-09 | Edgecombe | North Carolina | 37065 | 1097 | 23 |
513700 | 513700 | 2020-09-08 | Edgecombe | North Carolina | 37065 | 1081 | 22 |
510467 | 510467 | 2020-09-07 | Edgecombe | North Carolina | 37065 | 1073 | 22 |
507234 | 507234 | 2020-09-06 | Edgecombe | North Carolina | 37065 | 1071 | 22 |
504002 | 504002 | 2020-09-05 | Edgecombe | North Carolina | 37065 | 1062 | 22 |
500768 | 500768 | 2020-09-04 | Edgecombe | North Carolina | 37065 | 1046 | 22 |
497534 | 497534 | 2020-09-03 | Edgecombe | North Carolina | 37065 | 1023 | 21 |
494301 | 494301 | 2020-09-02 | Edgecombe | North Carolina | 37065 | 996 | 21 |
491067 | 491067 | 2020-09-01 | Edgecombe | North Carolina | 37065 | 968 | 20 |
487834 | 487834 | 2020-08-31 | Edgecombe | North Carolina | 37065 | 955 | 19 |
484601 | 484601 | 2020-08-30 | Edgecombe | North Carolina | 37065 | 948 | 19 |
481366 | 481366 | 2020-08-29 | Edgecombe | North Carolina | 37065 | 938 | 19 |
478133 | 478133 | 2020-08-28 | Edgecombe | North Carolina | 37065 | 912 | 19 |
474900 | 474900 | 2020-08-27 | Edgecombe | North Carolina | 37065 | 891 | 19 |
471666 | 471666 | 2020-08-26 | Edgecombe | North Carolina | 37065 | 871 | 17 |
468434 | 468434 | 2020-08-25 | Edgecombe | North Carolina | 37065 | 857 | 17 |
465206 | 465206 | 2020-08-24 | Edgecombe | North Carolina | 37065 | 854 | 17 |
461977 | 461977 | 2020-08-23 | Edgecombe | North Carolina | 37065 | 845 | 17 |
458749 | 458749 | 2020-08-22 | Edgecombe | North Carolina | 37065 | 830 | 17 |
455521 | 455521 | 2020-08-21 | Edgecombe | North Carolina | 37065 | 815 | 17 |
452293 | 452293 | 2020-08-20 | Edgecombe | North Carolina | 37065 | 792 | 16 |
449065 | 449065 | 2020-08-19 | Edgecombe | North Carolina | 37065 | 772 | 15 |
445837 | 445837 | 2020-08-18 | Edgecombe | North Carolina | 37065 | 753 | 14 |
442611 | 442611 | 2020-08-17 | Edgecombe | North Carolina | 37065 | 745 | 13 |
439384 | 439384 | 2020-08-16 | Edgecombe | North Carolina | 37065 | 736 | 13 |
436159 | 436159 | 2020-08-15 | Edgecombe | North Carolina | 37065 | 725 | 13 |
432933 | 432933 | 2020-08-14 | Edgecombe | North Carolina | 37065 | 709 | 13 |
429707 | 429707 | 2020-08-13 | Edgecombe | North Carolina | 37065 | 691 | 13 |
426482 | 426482 | 2020-08-12 | Edgecombe | North Carolina | 37065 | 672 | 13 |
423259 | 423259 | 2020-08-11 | Edgecombe | North Carolina | 37065 | 664 | 13 |
420036 | 420036 | 2020-08-10 | Edgecombe | North Carolina | 37065 | 656 | 13 |
416816 | 416816 | 2020-08-09 | Edgecombe | North Carolina | 37065 | 646 | 13 |
413595 | 413595 | 2020-08-08 | Edgecombe | North Carolina | 37065 | 632 | 13 |
410375 | 410375 | 2020-08-07 | Edgecombe | North Carolina | 37065 | 626 | 12 |
407155 | 407155 | 2020-08-06 | Edgecombe | North Carolina | 37065 | 616 | 12 |
403936 | 403936 | 2020-08-05 | Edgecombe | North Carolina | 37065 | 605 | 12 |
400718 | 400718 | 2020-08-04 | Edgecombe | North Carolina | 37065 | 596 | 12 |
397503 | 397503 | 2020-08-03 | Edgecombe | North Carolina | 37065 | 589 | 11 |
394286 | 394286 | 2020-08-02 | Edgecombe | North Carolina | 37065 | 579 | 11 |
391070 | 391070 | 2020-08-01 | Edgecombe | North Carolina | 37065 | 574 | 11 |
387853 | 387853 | 2020-07-31 | Edgecombe | North Carolina | 37065 | 564 | 11 |
384636 | 384636 | 2020-07-30 | Edgecombe | North Carolina | 37065 | 560 | 11 |
381418 | 381418 | 2020-07-29 | Edgecombe | North Carolina | 37065 | 549 | 10 |
378201 | 378201 | 2020-07-28 | Edgecombe | North Carolina | 37065 | 533 | 10 |
374985 | 374985 | 2020-07-27 | Edgecombe | North Carolina | 37065 | 526 | 10 |
371773 | 371773 | 2020-07-26 | Edgecombe | North Carolina | 37065 | 514 | 10 |
368561 | 368561 | 2020-07-25 | Edgecombe | North Carolina | 37065 | 503 | 10 |
365352 | 365352 | 2020-07-24 | Edgecombe | North Carolina | 37065 | 489 | 10 |
362146 | 362146 | 2020-07-23 | Edgecombe | North Carolina | 37065 | 477 | 10 |
358940 | 358940 | 2020-07-22 | Edgecombe | North Carolina | 37065 | 473 | 10 |
355736 | 355736 | 2020-07-21 | Edgecombe | North Carolina | 37065 | 463 | 10 |
352533 | 352533 | 2020-07-20 | Edgecombe | North Carolina | 37065 | 454 | 10 |
349330 | 349330 | 2020-07-19 | Edgecombe | North Carolina | 37065 | 440 | 10 |
346129 | 346129 | 2020-07-18 | Edgecombe | North Carolina | 37065 | 427 | 10 |
342930 | 342930 | 2020-07-17 | Edgecombe | North Carolina | 37065 | 420 | 9 |
339732 | 339732 | 2020-07-16 | Edgecombe | North Carolina | 37065 | 415 | 9 |
336536 | 336536 | 2020-07-15 | Edgecombe | North Carolina | 37065 | 409 | 9 |
333342 | 333342 | 2020-07-14 | Edgecombe | North Carolina | 37065 | 402 | 9 |
330152 | 330152 | 2020-07-13 | Edgecombe | North Carolina | 37065 | 388 | 9 |
326965 | 326965 | 2020-07-12 | Edgecombe | North Carolina | 37065 | 379 | 9 |
323781 | 323781 | 2020-07-11 | Edgecombe | North Carolina | 37065 | 377 | 9 |
320601 | 320601 | 2020-07-10 | Edgecombe | North Carolina | 37065 | 370 | 9 |
317424 | 317424 | 2020-07-09 | Edgecombe | North Carolina | 37065 | 363 | 9 |
314250 | 314250 | 2020-07-08 | Edgecombe | North Carolina | 37065 | 352 | 9 |
311079 | 311079 | 2020-07-07 | Edgecombe | North Carolina | 37065 | 352 | 9 |
307911 | 307911 | 2020-07-06 | Edgecombe | North Carolina | 37065 | 347 | 9 |
304744 | 304744 | 2020-07-05 | Edgecombe | North Carolina | 37065 | 334 | 9 |
301581 | 301581 | 2020-07-04 | Edgecombe | North Carolina | 37065 | 334 | 9 |
298418 | 298418 | 2020-07-03 | Edgecombe | North Carolina | 37065 | 329 | 9 |
295258 | 295258 | 2020-07-02 | Edgecombe | North Carolina | 37065 | 326 | 9 |
292103 | 292103 | 2020-07-01 | Edgecombe | North Carolina | 37065 | 317 | 9 |
288951 | 288951 | 2020-06-30 | Edgecombe | North Carolina | 37065 | 315 | 9 |
285801 | 285801 | 2020-06-29 | Edgecombe | North Carolina | 37065 | 313 | 9 |
282656 | 282656 | 2020-06-28 | Edgecombe | North Carolina | 37065 | 309 | 9 |
279510 | 279510 | 2020-06-27 | Edgecombe | North Carolina | 37065 | 302 | 9 |
276362 | 276362 | 2020-06-26 | Edgecombe | North Carolina | 37065 | 298 | 9 |
273216 | 273216 | 2020-06-25 | Edgecombe | North Carolina | 37065 | 290 | 9 |
270077 | 270077 | 2020-06-24 | Edgecombe | North Carolina | 37065 | 284 | 9 |
266943 | 266943 | 2020-06-23 | Edgecombe | North Carolina | 37065 | 276 | 9 |
263815 | 263815 | 2020-06-22 | Edgecombe | North Carolina | 37065 | 274 | 9 |
260687 | 260687 | 2020-06-21 | Edgecombe | North Carolina | 37065 | 273 | 9 |
257560 | 257560 | 2020-06-20 | Edgecombe | North Carolina | 37065 | 268 | 9 |
254437 | 254437 | 2020-06-19 | Edgecombe | North Carolina | 37065 | 262 | 9 |
251322 | 251322 | 2020-06-18 | Edgecombe | North Carolina | 37065 | 257 | 9 |
248207 | 248207 | 2020-06-17 | Edgecombe | North Carolina | 37065 | 256 | 9 |
245094 | 245094 | 2020-06-16 | Edgecombe | North Carolina | 37065 | 254 | 9 |
241982 | 241982 | 2020-06-15 | Edgecombe | North Carolina | 37065 | 252 | 9 |
238873 | 238873 | 2020-06-14 | Edgecombe | North Carolina | 37065 | 253 | 9 |
235765 | 235765 | 2020-06-13 | Edgecombe | North Carolina | 37065 | 244 | 9 |
232660 | 232660 | 2020-06-12 | Edgecombe | North Carolina | 37065 | 235 | 9 |
229555 | 229555 | 2020-06-11 | Edgecombe | North Carolina | 37065 | 233 | 9 |
226451 | 226451 | 2020-06-10 | Edgecombe | North Carolina | 37065 | 231 | 9 |
223351 | 223351 | 2020-06-09 | Edgecombe | North Carolina | 37065 | 230 | 9 |
220257 | 220257 | 2020-06-08 | Edgecombe | North Carolina | 37065 | 229 | 9 |
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);