ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 37031 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 |
---|---|---|---|---|---|---|---|
536334 | 536334 | 2020-09-15 | Carteret | North Carolina | 37031 | 587 | 5 |
533098 | 533098 | 2020-09-14 | Carteret | North Carolina | 37031 | 583 | 5 |
529863 | 529863 | 2020-09-13 | Carteret | North Carolina | 37031 | 579 | 5 |
526626 | 526626 | 2020-09-12 | Carteret | North Carolina | 37031 | 573 | 5 |
523390 | 523390 | 2020-09-11 | Carteret | North Carolina | 37031 | 572 | 5 |
520154 | 520154 | 2020-09-10 | Carteret | North Carolina | 37031 | 570 | 5 |
516918 | 516918 | 2020-09-09 | Carteret | North Carolina | 37031 | 559 | 5 |
513683 | 513683 | 2020-09-08 | Carteret | North Carolina | 37031 | 555 | 5 |
510450 | 510450 | 2020-09-07 | Carteret | North Carolina | 37031 | 554 | 5 |
507217 | 507217 | 2020-09-06 | Carteret | North Carolina | 37031 | 546 | 5 |
503985 | 503985 | 2020-09-05 | Carteret | North Carolina | 37031 | 540 | 5 |
500751 | 500751 | 2020-09-04 | Carteret | North Carolina | 37031 | 534 | 5 |
497517 | 497517 | 2020-09-03 | Carteret | North Carolina | 37031 | 526 | 5 |
494284 | 494284 | 2020-09-02 | Carteret | North Carolina | 37031 | 513 | 5 |
491050 | 491050 | 2020-09-01 | Carteret | North Carolina | 37031 | 509 | 5 |
487817 | 487817 | 2020-08-31 | Carteret | North Carolina | 37031 | 500 | 5 |
484584 | 484584 | 2020-08-30 | Carteret | North Carolina | 37031 | 492 | 5 |
481349 | 481349 | 2020-08-29 | Carteret | North Carolina | 37031 | 482 | 5 |
478116 | 478116 | 2020-08-28 | Carteret | North Carolina | 37031 | 466 | 5 |
474883 | 474883 | 2020-08-27 | Carteret | North Carolina | 37031 | 460 | 5 |
471649 | 471649 | 2020-08-26 | Carteret | North Carolina | 37031 | 446 | 5 |
468417 | 468417 | 2020-08-25 | Carteret | North Carolina | 37031 | 445 | 5 |
465189 | 465189 | 2020-08-24 | Carteret | North Carolina | 37031 | 436 | 5 |
461960 | 461960 | 2020-08-23 | Carteret | North Carolina | 37031 | 423 | 5 |
458732 | 458732 | 2020-08-22 | Carteret | North Carolina | 37031 | 414 | 5 |
455504 | 455504 | 2020-08-21 | Carteret | North Carolina | 37031 | 409 | 5 |
452276 | 452276 | 2020-08-20 | Carteret | North Carolina | 37031 | 399 | 5 |
449048 | 449048 | 2020-08-19 | Carteret | North Carolina | 37031 | 392 | 5 |
445820 | 445820 | 2020-08-18 | Carteret | North Carolina | 37031 | 385 | 5 |
442594 | 442594 | 2020-08-17 | Carteret | North Carolina | 37031 | 381 | 5 |
439367 | 439367 | 2020-08-16 | Carteret | North Carolina | 37031 | 377 | 5 |
436142 | 436142 | 2020-08-15 | Carteret | North Carolina | 37031 | 374 | 5 |
432916 | 432916 | 2020-08-14 | Carteret | North Carolina | 37031 | 369 | 5 |
429690 | 429690 | 2020-08-13 | Carteret | North Carolina | 37031 | 362 | 5 |
426465 | 426465 | 2020-08-12 | Carteret | North Carolina | 37031 | 352 | 5 |
423242 | 423242 | 2020-08-11 | Carteret | North Carolina | 37031 | 351 | 5 |
420019 | 420019 | 2020-08-10 | Carteret | North Carolina | 37031 | 348 | 5 |
416799 | 416799 | 2020-08-09 | Carteret | North Carolina | 37031 | 344 | 5 |
413578 | 413578 | 2020-08-08 | Carteret | North Carolina | 37031 | 339 | 5 |
410358 | 410358 | 2020-08-07 | Carteret | North Carolina | 37031 | 328 | 5 |
407138 | 407138 | 2020-08-06 | Carteret | North Carolina | 37031 | 323 | 5 |
403919 | 403919 | 2020-08-05 | Carteret | North Carolina | 37031 | 308 | 5 |
400701 | 400701 | 2020-08-04 | Carteret | North Carolina | 37031 | 307 | 5 |
397486 | 397486 | 2020-08-03 | Carteret | North Carolina | 37031 | 300 | 4 |
394269 | 394269 | 2020-08-02 | Carteret | North Carolina | 37031 | 295 | 4 |
391053 | 391053 | 2020-08-01 | Carteret | North Carolina | 37031 | 286 | 4 |
387836 | 387836 | 2020-07-31 | Carteret | North Carolina | 37031 | 284 | 4 |
384619 | 384619 | 2020-07-30 | Carteret | North Carolina | 37031 | 279 | 4 |
381401 | 381401 | 2020-07-29 | Carteret | North Carolina | 37031 | 272 | 4 |
378184 | 378184 | 2020-07-28 | Carteret | North Carolina | 37031 | 271 | 4 |
374968 | 374968 | 2020-07-27 | Carteret | North Carolina | 37031 | 267 | 4 |
371756 | 371756 | 2020-07-26 | Carteret | North Carolina | 37031 | 262 | 4 |
368544 | 368544 | 2020-07-25 | Carteret | North Carolina | 37031 | 238 | 4 |
365335 | 365335 | 2020-07-24 | Carteret | North Carolina | 37031 | 210 | 4 |
362129 | 362129 | 2020-07-23 | Carteret | North Carolina | 37031 | 180 | 4 |
358923 | 358923 | 2020-07-22 | Carteret | North Carolina | 37031 | 178 | 4 |
355719 | 355719 | 2020-07-21 | Carteret | North Carolina | 37031 | 176 | 4 |
352516 | 352516 | 2020-07-20 | Carteret | North Carolina | 37031 | 178 | 4 |
349313 | 349313 | 2020-07-19 | Carteret | North Carolina | 37031 | 176 | 4 |
346112 | 346112 | 2020-07-18 | Carteret | North Carolina | 37031 | 173 | 4 |
342913 | 342913 | 2020-07-17 | Carteret | North Carolina | 37031 | 168 | 4 |
339715 | 339715 | 2020-07-16 | Carteret | North Carolina | 37031 | 164 | 4 |
336519 | 336519 | 2020-07-15 | Carteret | North Carolina | 37031 | 152 | 3 |
333325 | 333325 | 2020-07-14 | Carteret | North Carolina | 37031 | 144 | 3 |
330135 | 330135 | 2020-07-13 | Carteret | North Carolina | 37031 | 136 | 3 |
326948 | 326948 | 2020-07-12 | Carteret | North Carolina | 37031 | 130 | 3 |
323764 | 323764 | 2020-07-11 | Carteret | North Carolina | 37031 | 121 | 3 |
320584 | 320584 | 2020-07-10 | Carteret | North Carolina | 37031 | 117 | 3 |
317407 | 317407 | 2020-07-09 | Carteret | North Carolina | 37031 | 111 | 3 |
314233 | 314233 | 2020-07-08 | Carteret | North Carolina | 37031 | 111 | 3 |
311062 | 311062 | 2020-07-07 | Carteret | North Carolina | 37031 | 110 | 3 |
307894 | 307894 | 2020-07-06 | Carteret | North Carolina | 37031 | 109 | 3 |
304727 | 304727 | 2020-07-05 | Carteret | North Carolina | 37031 | 105 | 3 |
301564 | 301564 | 2020-07-04 | Carteret | North Carolina | 37031 | 101 | 3 |
298401 | 298401 | 2020-07-03 | Carteret | North Carolina | 37031 | 100 | 3 |
295241 | 295241 | 2020-07-02 | Carteret | North Carolina | 37031 | 91 | 3 |
292086 | 292086 | 2020-07-01 | Carteret | North Carolina | 37031 | 87 | 3 |
288934 | 288934 | 2020-06-30 | Carteret | North Carolina | 37031 | 87 | 3 |
285784 | 285784 | 2020-06-29 | Carteret | North Carolina | 37031 | 84 | 3 |
282639 | 282639 | 2020-06-28 | Carteret | North Carolina | 37031 | 76 | 3 |
279493 | 279493 | 2020-06-27 | Carteret | North Carolina | 37031 | 70 | 3 |
276345 | 276345 | 2020-06-26 | Carteret | North Carolina | 37031 | 67 | 3 |
273199 | 273199 | 2020-06-25 | Carteret | North Carolina | 37031 | 64 | 3 |
270060 | 270060 | 2020-06-24 | Carteret | North Carolina | 37031 | 61 | 3 |
266926 | 266926 | 2020-06-23 | Carteret | North Carolina | 37031 | 59 | 3 |
263798 | 263798 | 2020-06-22 | Carteret | North Carolina | 37031 | 57 | 3 |
260670 | 260670 | 2020-06-21 | Carteret | North Carolina | 37031 | 53 | 3 |
257543 | 257543 | 2020-06-20 | Carteret | North Carolina | 37031 | 52 | 3 |
254420 | 254420 | 2020-06-19 | Carteret | North Carolina | 37031 | 51 | 3 |
251305 | 251305 | 2020-06-18 | Carteret | North Carolina | 37031 | 49 | 3 |
248190 | 248190 | 2020-06-17 | Carteret | North Carolina | 37031 | 47 | 3 |
245077 | 245077 | 2020-06-16 | Carteret | North Carolina | 37031 | 48 | 3 |
241965 | 241965 | 2020-06-15 | Carteret | North Carolina | 37031 | 47 | 3 |
238856 | 238856 | 2020-06-14 | Carteret | North Carolina | 37031 | 46 | 3 |
235748 | 235748 | 2020-06-13 | Carteret | North Carolina | 37031 | 46 | 3 |
232643 | 232643 | 2020-06-12 | Carteret | North Carolina | 37031 | 45 | 3 |
229538 | 229538 | 2020-06-11 | Carteret | North Carolina | 37031 | 43 | 3 |
226434 | 226434 | 2020-06-10 | Carteret | North Carolina | 37031 | 42 | 3 |
223334 | 223334 | 2020-06-09 | Carteret | North Carolina | 37031 | 40 | 3 |
220240 | 220240 | 2020-06-08 | Carteret | North Carolina | 37031 | 40 | 3 |
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);