ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Onslow", fips = 37133 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 |
---|---|---|---|---|---|---|---|
536385 | 536385 | 2020-09-15 | Onslow | North Carolina | 37133 | 1731 | 20 |
533149 | 533149 | 2020-09-14 | Onslow | North Carolina | 37133 | 1707 | 18 |
529914 | 529914 | 2020-09-13 | Onslow | North Carolina | 37133 | 1696 | 18 |
526677 | 526677 | 2020-09-12 | Onslow | North Carolina | 37133 | 1695 | 18 |
523441 | 523441 | 2020-09-11 | Onslow | North Carolina | 37133 | 1674 | 18 |
520205 | 520205 | 2020-09-10 | Onslow | North Carolina | 37133 | 1665 | 17 |
516969 | 516969 | 2020-09-09 | Onslow | North Carolina | 37133 | 1654 | 17 |
513734 | 513734 | 2020-09-08 | Onslow | North Carolina | 37133 | 1642 | 17 |
510501 | 510501 | 2020-09-07 | Onslow | North Carolina | 37133 | 1627 | 17 |
507268 | 507268 | 2020-09-06 | Onslow | North Carolina | 37133 | 1617 | 17 |
504036 | 504036 | 2020-09-05 | Onslow | North Carolina | 37133 | 1608 | 17 |
500802 | 500802 | 2020-09-04 | Onslow | North Carolina | 37133 | 1576 | 16 |
497568 | 497568 | 2020-09-03 | Onslow | North Carolina | 37133 | 1527 | 14 |
494335 | 494335 | 2020-09-02 | Onslow | North Carolina | 37133 | 1509 | 13 |
491101 | 491101 | 2020-09-01 | Onslow | North Carolina | 37133 | 1501 | 12 |
487868 | 487868 | 2020-08-31 | Onslow | North Carolina | 37133 | 1474 | 12 |
484635 | 484635 | 2020-08-30 | Onslow | North Carolina | 37133 | 1460 | 12 |
481400 | 481400 | 2020-08-29 | Onslow | North Carolina | 37133 | 1460 | 12 |
478167 | 478167 | 2020-08-28 | Onslow | North Carolina | 37133 | 1440 | 12 |
474934 | 474934 | 2020-08-27 | Onslow | North Carolina | 37133 | 1421 | 14 |
471700 | 471700 | 2020-08-26 | Onslow | North Carolina | 37133 | 1403 | 14 |
468468 | 468468 | 2020-08-25 | Onslow | North Carolina | 37133 | 1391 | 14 |
465240 | 465240 | 2020-08-24 | Onslow | North Carolina | 37133 | 1355 | 13 |
462011 | 462011 | 2020-08-23 | Onslow | North Carolina | 37133 | 1340 | 13 |
458783 | 458783 | 2020-08-22 | Onslow | North Carolina | 37133 | 1334 | 13 |
455555 | 455555 | 2020-08-21 | Onslow | North Carolina | 37133 | 1313 | 12 |
452327 | 452327 | 2020-08-20 | Onslow | North Carolina | 37133 | 1280 | 12 |
449099 | 449099 | 2020-08-19 | Onslow | North Carolina | 37133 | 1254 | 12 |
445871 | 445871 | 2020-08-18 | Onslow | North Carolina | 37133 | 1242 | 12 |
442645 | 442645 | 2020-08-17 | Onslow | North Carolina | 37133 | 1208 | 12 |
439418 | 439418 | 2020-08-16 | Onslow | North Carolina | 37133 | 1200 | 12 |
436193 | 436193 | 2020-08-15 | Onslow | North Carolina | 37133 | 1194 | 12 |
432967 | 432967 | 2020-08-14 | Onslow | North Carolina | 37133 | 1178 | 12 |
429741 | 429741 | 2020-08-13 | Onslow | North Carolina | 37133 | 1154 | 12 |
426516 | 426516 | 2020-08-12 | Onslow | North Carolina | 37133 | 1138 | 11 |
423293 | 423293 | 2020-08-11 | Onslow | North Carolina | 37133 | 1108 | 11 |
420070 | 420070 | 2020-08-10 | Onslow | North Carolina | 37133 | 1079 | 10 |
416850 | 416850 | 2020-08-09 | Onslow | North Carolina | 37133 | 1065 | 10 |
413629 | 413629 | 2020-08-08 | Onslow | North Carolina | 37133 | 1047 | 10 |
410409 | 410409 | 2020-08-07 | Onslow | North Carolina | 37133 | 1026 | 10 |
407189 | 407189 | 2020-08-06 | Onslow | North Carolina | 37133 | 1015 | 10 |
403970 | 403970 | 2020-08-05 | Onslow | North Carolina | 37133 | 987 | 10 |
400752 | 400752 | 2020-08-04 | Onslow | North Carolina | 37133 | 961 | 10 |
397537 | 397537 | 2020-08-03 | Onslow | North Carolina | 37133 | 934 | 10 |
394320 | 394320 | 2020-08-02 | Onslow | North Carolina | 37133 | 930 | 10 |
391104 | 391104 | 2020-08-01 | Onslow | North Carolina | 37133 | 917 | 10 |
387887 | 387887 | 2020-07-31 | Onslow | North Carolina | 37133 | 890 | 10 |
384670 | 384670 | 2020-07-30 | Onslow | North Carolina | 37133 | 820 | 10 |
381452 | 381452 | 2020-07-29 | Onslow | North Carolina | 37133 | 773 | 9 |
378235 | 378235 | 2020-07-28 | Onslow | North Carolina | 37133 | 730 | 9 |
375019 | 375019 | 2020-07-27 | Onslow | North Carolina | 37133 | 722 | 9 |
371807 | 371807 | 2020-07-26 | Onslow | North Carolina | 37133 | 712 | 9 |
368595 | 368595 | 2020-07-25 | Onslow | North Carolina | 37133 | 707 | 9 |
365386 | 365386 | 2020-07-24 | Onslow | North Carolina | 37133 | 671 | 7 |
362180 | 362180 | 2020-07-23 | Onslow | North Carolina | 37133 | 646 | 7 |
358974 | 358974 | 2020-07-22 | Onslow | North Carolina | 37133 | 618 | 7 |
355770 | 355770 | 2020-07-21 | Onslow | North Carolina | 37133 | 596 | 7 |
352567 | 352567 | 2020-07-20 | Onslow | North Carolina | 37133 | 564 | 6 |
349364 | 349364 | 2020-07-19 | Onslow | North Carolina | 37133 | 558 | 6 |
346163 | 346163 | 2020-07-18 | Onslow | North Carolina | 37133 | 547 | 6 |
342964 | 342964 | 2020-07-17 | Onslow | North Carolina | 37133 | 507 | 5 |
339766 | 339766 | 2020-07-16 | Onslow | North Carolina | 37133 | 464 | 5 |
336570 | 336570 | 2020-07-15 | Onslow | North Carolina | 37133 | 454 | 3 |
333376 | 333376 | 2020-07-14 | Onslow | North Carolina | 37133 | 436 | 3 |
330186 | 330186 | 2020-07-13 | Onslow | North Carolina | 37133 | 418 | 3 |
326999 | 326999 | 2020-07-12 | Onslow | North Carolina | 37133 | 412 | 3 |
323815 | 323815 | 2020-07-11 | Onslow | North Carolina | 37133 | 399 | 3 |
320635 | 320635 | 2020-07-10 | Onslow | North Carolina | 37133 | 382 | 3 |
317458 | 317458 | 2020-07-09 | Onslow | North Carolina | 37133 | 372 | 3 |
314284 | 314284 | 2020-07-08 | Onslow | North Carolina | 37133 | 367 | 3 |
311113 | 311113 | 2020-07-07 | Onslow | North Carolina | 37133 | 359 | 3 |
307945 | 307945 | 2020-07-06 | Onslow | North Carolina | 37133 | 353 | 3 |
304778 | 304778 | 2020-07-05 | Onslow | North Carolina | 37133 | 345 | 3 |
301615 | 301615 | 2020-07-04 | Onslow | North Carolina | 37133 | 339 | 3 |
298452 | 298452 | 2020-07-03 | Onslow | North Carolina | 37133 | 334 | 3 |
295292 | 295292 | 2020-07-02 | Onslow | North Carolina | 37133 | 324 | 3 |
292137 | 292137 | 2020-07-01 | Onslow | North Carolina | 37133 | 308 | 3 |
288985 | 288985 | 2020-06-30 | Onslow | North Carolina | 37133 | 284 | 3 |
285835 | 285835 | 2020-06-29 | Onslow | North Carolina | 37133 | 270 | 3 |
282690 | 282690 | 2020-06-28 | Onslow | North Carolina | 37133 | 258 | 3 |
279544 | 279544 | 2020-06-27 | Onslow | North Carolina | 37133 | 249 | 3 |
276396 | 276396 | 2020-06-26 | Onslow | North Carolina | 37133 | 243 | 3 |
273250 | 273250 | 2020-06-25 | Onslow | North Carolina | 37133 | 229 | 3 |
270111 | 270111 | 2020-06-24 | Onslow | North Carolina | 37133 | 224 | 3 |
266977 | 266977 | 2020-06-23 | Onslow | North Carolina | 37133 | 215 | 3 |
263849 | 263849 | 2020-06-22 | Onslow | North Carolina | 37133 | 213 | 3 |
260721 | 260721 | 2020-06-21 | Onslow | North Carolina | 37133 | 211 | 3 |
257594 | 257594 | 2020-06-20 | Onslow | North Carolina | 37133 | 206 | 3 |
254471 | 254471 | 2020-06-19 | Onslow | North Carolina | 37133 | 188 | 3 |
251356 | 251356 | 2020-06-18 | Onslow | North Carolina | 37133 | 180 | 3 |
248241 | 248241 | 2020-06-17 | Onslow | North Carolina | 37133 | 178 | 3 |
245128 | 245128 | 2020-06-16 | Onslow | North Carolina | 37133 | 166 | 3 |
242016 | 242016 | 2020-06-15 | Onslow | North Carolina | 37133 | 160 | 3 |
238907 | 238907 | 2020-06-14 | Onslow | North Carolina | 37133 | 159 | 3 |
235799 | 235799 | 2020-06-13 | Onslow | North Carolina | 37133 | 156 | 3 |
232694 | 232694 | 2020-06-12 | Onslow | North Carolina | 37133 | 149 | 2 |
229589 | 229589 | 2020-06-11 | Onslow | North Carolina | 37133 | 145 | 2 |
226485 | 226485 | 2020-06-10 | Onslow | North Carolina | 37133 | 136 | 2 |
223385 | 223385 | 2020-06-09 | Onslow | North Carolina | 37133 | 136 | 2 |
220291 | 220291 | 2020-06-08 | Onslow | North Carolina | 37133 | 134 | 2 |
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);