ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Pasquotank" 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 |
---|---|---|---|---|---|---|---|
536388 | 536388 | 2020-09-15 | Pasquotank | North Carolina | 37139 | 631 | 26 |
533152 | 533152 | 2020-09-14 | Pasquotank | North Carolina | 37139 | 630 | 26 |
529917 | 529917 | 2020-09-13 | Pasquotank | North Carolina | 37139 | 627 | 26 |
526680 | 526680 | 2020-09-12 | Pasquotank | North Carolina | 37139 | 622 | 26 |
523444 | 523444 | 2020-09-11 | Pasquotank | North Carolina | 37139 | 618 | 26 |
520208 | 520208 | 2020-09-10 | Pasquotank | North Carolina | 37139 | 612 | 26 |
516972 | 516972 | 2020-09-09 | Pasquotank | North Carolina | 37139 | 606 | 26 |
513737 | 513737 | 2020-09-08 | Pasquotank | North Carolina | 37139 | 602 | 26 |
510504 | 510504 | 2020-09-07 | Pasquotank | North Carolina | 37139 | 602 | 26 |
507271 | 507271 | 2020-09-06 | Pasquotank | North Carolina | 37139 | 600 | 26 |
504039 | 504039 | 2020-09-05 | Pasquotank | North Carolina | 37139 | 593 | 26 |
500805 | 500805 | 2020-09-04 | Pasquotank | North Carolina | 37139 | 587 | 25 |
497571 | 497571 | 2020-09-03 | Pasquotank | North Carolina | 37139 | 580 | 23 |
494338 | 494338 | 2020-09-02 | Pasquotank | North Carolina | 37139 | 572 | 23 |
491104 | 491104 | 2020-09-01 | Pasquotank | North Carolina | 37139 | 564 | 23 |
487871 | 487871 | 2020-08-31 | Pasquotank | North Carolina | 37139 | 548 | 23 |
484638 | 484638 | 2020-08-30 | Pasquotank | North Carolina | 37139 | 546 | 23 |
481403 | 481403 | 2020-08-29 | Pasquotank | North Carolina | 37139 | 544 | 23 |
478170 | 478170 | 2020-08-28 | Pasquotank | North Carolina | 37139 | 532 | 23 |
474937 | 474937 | 2020-08-27 | Pasquotank | North Carolina | 37139 | 523 | 23 |
471703 | 471703 | 2020-08-26 | Pasquotank | North Carolina | 37139 | 515 | 23 |
468471 | 468471 | 2020-08-25 | Pasquotank | North Carolina | 37139 | 512 | 22 |
465243 | 465243 | 2020-08-24 | Pasquotank | North Carolina | 37139 | 513 | 22 |
462014 | 462014 | 2020-08-23 | Pasquotank | North Carolina | 37139 | 507 | 22 |
458786 | 458786 | 2020-08-22 | Pasquotank | North Carolina | 37139 | 504 | 22 |
455558 | 455558 | 2020-08-21 | Pasquotank | North Carolina | 37139 | 483 | 21 |
452330 | 452330 | 2020-08-20 | Pasquotank | North Carolina | 37139 | 468 | 21 |
449102 | 449102 | 2020-08-19 | Pasquotank | North Carolina | 37139 | 464 | 21 |
445874 | 445874 | 2020-08-18 | Pasquotank | North Carolina | 37139 | 458 | 21 |
442648 | 442648 | 2020-08-17 | Pasquotank | North Carolina | 37139 | 456 | 20 |
439421 | 439421 | 2020-08-16 | Pasquotank | North Carolina | 37139 | 447 | 20 |
436196 | 436196 | 2020-08-15 | Pasquotank | North Carolina | 37139 | 443 | 20 |
432970 | 432970 | 2020-08-14 | Pasquotank | North Carolina | 37139 | 436 | 20 |
429744 | 429744 | 2020-08-13 | Pasquotank | North Carolina | 37139 | 430 | 20 |
426519 | 426519 | 2020-08-12 | Pasquotank | North Carolina | 37139 | 423 | 20 |
423296 | 423296 | 2020-08-11 | Pasquotank | North Carolina | 37139 | 423 | 20 |
420073 | 420073 | 2020-08-10 | Pasquotank | North Carolina | 37139 | 402 | 20 |
416853 | 416853 | 2020-08-09 | Pasquotank | North Carolina | 37139 | 401 | 20 |
413632 | 413632 | 2020-08-08 | Pasquotank | North Carolina | 37139 | 395 | 20 |
410412 | 410412 | 2020-08-07 | Pasquotank | North Carolina | 37139 | 388 | 19 |
407192 | 407192 | 2020-08-06 | Pasquotank | North Carolina | 37139 | 371 | 19 |
403973 | 403973 | 2020-08-05 | Pasquotank | North Carolina | 37139 | 360 | 17 |
400755 | 400755 | 2020-08-04 | Pasquotank | North Carolina | 37139 | 360 | 17 |
397540 | 397540 | 2020-08-03 | Pasquotank | North Carolina | 37139 | 359 | 17 |
394323 | 394323 | 2020-08-02 | Pasquotank | North Carolina | 37139 | 351 | 17 |
391107 | 391107 | 2020-08-01 | Pasquotank | North Carolina | 37139 | 351 | 17 |
387890 | 387890 | 2020-07-31 | Pasquotank | North Carolina | 37139 | 346 | 17 |
384673 | 384673 | 2020-07-30 | Pasquotank | North Carolina | 37139 | 336 | 17 |
381455 | 381455 | 2020-07-29 | Pasquotank | North Carolina | 37139 | 314 | 17 |
378238 | 378238 | 2020-07-28 | Pasquotank | North Carolina | 37139 | 311 | 17 |
375022 | 375022 | 2020-07-27 | Pasquotank | North Carolina | 37139 | 305 | 17 |
371810 | 371810 | 2020-07-26 | Pasquotank | North Carolina | 37139 | 298 | 17 |
368598 | 368598 | 2020-07-25 | Pasquotank | North Carolina | 37139 | 295 | 17 |
365389 | 365389 | 2020-07-24 | Pasquotank | North Carolina | 37139 | 288 | 17 |
362183 | 362183 | 2020-07-23 | Pasquotank | North Carolina | 37139 | 281 | 17 |
358977 | 358977 | 2020-07-22 | Pasquotank | North Carolina | 37139 | 278 | 17 |
355773 | 355773 | 2020-07-21 | Pasquotank | North Carolina | 37139 | 271 | 17 |
352570 | 352570 | 2020-07-20 | Pasquotank | North Carolina | 37139 | 267 | 17 |
349367 | 349367 | 2020-07-19 | Pasquotank | North Carolina | 37139 | 267 | 17 |
346166 | 346166 | 2020-07-18 | Pasquotank | North Carolina | 37139 | 267 | 17 |
342967 | 342967 | 2020-07-17 | Pasquotank | North Carolina | 37139 | 262 | 17 |
339769 | 339769 | 2020-07-16 | Pasquotank | North Carolina | 37139 | 262 | 17 |
336573 | 336573 | 2020-07-15 | Pasquotank | North Carolina | 37139 | 258 | 17 |
333379 | 333379 | 2020-07-14 | Pasquotank | North Carolina | 37139 | 255 | 17 |
330189 | 330189 | 2020-07-13 | Pasquotank | North Carolina | 37139 | 244 | 17 |
327002 | 327002 | 2020-07-12 | Pasquotank | North Carolina | 37139 | 243 | 17 |
323818 | 323818 | 2020-07-11 | Pasquotank | North Carolina | 37139 | 242 | 17 |
320638 | 320638 | 2020-07-10 | Pasquotank | North Carolina | 37139 | 234 | 17 |
317461 | 317461 | 2020-07-09 | Pasquotank | North Carolina | 37139 | 233 | 17 |
314287 | 314287 | 2020-07-08 | Pasquotank | North Carolina | 37139 | 233 | 17 |
311116 | 311116 | 2020-07-07 | Pasquotank | North Carolina | 37139 | 225 | 17 |
307948 | 307948 | 2020-07-06 | Pasquotank | North Carolina | 37139 | 221 | 17 |
304781 | 304781 | 2020-07-05 | Pasquotank | North Carolina | 37139 | 220 | 17 |
301618 | 301618 | 2020-07-04 | Pasquotank | North Carolina | 37139 | 218 | 17 |
298455 | 298455 | 2020-07-03 | Pasquotank | North Carolina | 37139 | 217 | 17 |
295295 | 295295 | 2020-07-02 | Pasquotank | North Carolina | 37139 | 212 | 17 |
292140 | 292140 | 2020-07-01 | Pasquotank | North Carolina | 37139 | 210 | 17 |
288988 | 288988 | 2020-06-30 | Pasquotank | North Carolina | 37139 | 203 | 15 |
285838 | 285838 | 2020-06-29 | Pasquotank | North Carolina | 37139 | 204 | 15 |
282693 | 282693 | 2020-06-28 | Pasquotank | North Carolina | 37139 | 204 | 15 |
279547 | 279547 | 2020-06-27 | Pasquotank | North Carolina | 37139 | 198 | 15 |
276399 | 276399 | 2020-06-26 | Pasquotank | North Carolina | 37139 | 180 | 15 |
273253 | 273253 | 2020-06-25 | Pasquotank | North Carolina | 37139 | 172 | 15 |
270114 | 270114 | 2020-06-24 | Pasquotank | North Carolina | 37139 | 172 | 15 |
266980 | 266980 | 2020-06-23 | Pasquotank | North Carolina | 37139 | 168 | 15 |
263852 | 263852 | 2020-06-22 | Pasquotank | North Carolina | 37139 | 164 | 15 |
260724 | 260724 | 2020-06-21 | Pasquotank | North Carolina | 37139 | 163 | 15 |
257597 | 257597 | 2020-06-20 | Pasquotank | North Carolina | 37139 | 155 | 15 |
254474 | 254474 | 2020-06-19 | Pasquotank | North Carolina | 37139 | 153 | 15 |
251359 | 251359 | 2020-06-18 | Pasquotank | North Carolina | 37139 | 152 | 15 |
248244 | 248244 | 2020-06-17 | Pasquotank | North Carolina | 37139 | 147 | 15 |
245131 | 245131 | 2020-06-16 | Pasquotank | North Carolina | 37139 | 131 | 14 |
242019 | 242019 | 2020-06-15 | Pasquotank | North Carolina | 37139 | 131 | 14 |
238910 | 238910 | 2020-06-14 | Pasquotank | North Carolina | 37139 | 131 | 14 |
235802 | 235802 | 2020-06-13 | Pasquotank | North Carolina | 37139 | 131 | 14 |
232697 | 232697 | 2020-06-12 | Pasquotank | North Carolina | 37139 | 128 | 14 |
229592 | 229592 | 2020-06-11 | Pasquotank | North Carolina | 37139 | 125 | 14 |
226488 | 226488 | 2020-06-10 | Pasquotank | North Carolina | 37139 | 120 | 14 |
223388 | 223388 | 2020-06-09 | Pasquotank | North Carolina | 37139 | 115 | 13 |
220294 | 220294 | 2020-06-08 | Pasquotank | North Carolina | 37139 | 114 | 13 |
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);