ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where county = "Wilson" 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 |
---|---|---|---|---|---|---|---|
536416 | 536416 | 2020-09-15 | Wilson | North Carolina | 37195 | 1979 | 44 |
533180 | 533180 | 2020-09-14 | Wilson | North Carolina | 37195 | 1968 | 44 |
529945 | 529945 | 2020-09-13 | Wilson | North Carolina | 37195 | 1954 | 44 |
526708 | 526708 | 2020-09-12 | Wilson | North Carolina | 37195 | 1932 | 44 |
523472 | 523472 | 2020-09-11 | Wilson | North Carolina | 37195 | 1913 | 44 |
520236 | 520236 | 2020-09-10 | Wilson | North Carolina | 37195 | 1881 | 43 |
517000 | 517000 | 2020-09-09 | Wilson | North Carolina | 37195 | 1870 | 40 |
513765 | 513765 | 2020-09-08 | Wilson | North Carolina | 37195 | 1862 | 40 |
510532 | 510532 | 2020-09-07 | Wilson | North Carolina | 37195 | 1852 | 40 |
507299 | 507299 | 2020-09-06 | Wilson | North Carolina | 37195 | 1845 | 40 |
504067 | 504067 | 2020-09-05 | Wilson | North Carolina | 37195 | 1819 | 40 |
500833 | 500833 | 2020-09-04 | Wilson | North Carolina | 37195 | 1800 | 38 |
497599 | 497599 | 2020-09-03 | Wilson | North Carolina | 37195 | 1779 | 38 |
494366 | 494366 | 2020-09-02 | Wilson | North Carolina | 37195 | 1754 | 36 |
491132 | 491132 | 2020-09-01 | Wilson | North Carolina | 37195 | 1752 | 36 |
487899 | 487899 | 2020-08-31 | Wilson | North Carolina | 37195 | 1733 | 36 |
484666 | 484666 | 2020-08-30 | Wilson | North Carolina | 37195 | 1721 | 36 |
481431 | 481431 | 2020-08-29 | Wilson | North Carolina | 37195 | 1715 | 36 |
478198 | 478198 | 2020-08-28 | Wilson | North Carolina | 37195 | 1698 | 36 |
474965 | 474965 | 2020-08-27 | Wilson | North Carolina | 37195 | 1694 | 36 |
471731 | 471731 | 2020-08-26 | Wilson | North Carolina | 37195 | 1677 | 36 |
468499 | 468499 | 2020-08-25 | Wilson | North Carolina | 37195 | 1679 | 36 |
465271 | 465271 | 2020-08-24 | Wilson | North Carolina | 37195 | 1670 | 36 |
462042 | 462042 | 2020-08-23 | Wilson | North Carolina | 37195 | 1656 | 36 |
458814 | 458814 | 2020-08-22 | Wilson | North Carolina | 37195 | 1645 | 36 |
455586 | 455586 | 2020-08-21 | Wilson | North Carolina | 37195 | 1620 | 36 |
452358 | 452358 | 2020-08-20 | Wilson | North Carolina | 37195 | 1604 | 36 |
449130 | 449130 | 2020-08-19 | Wilson | North Carolina | 37195 | 1584 | 36 |
445902 | 445902 | 2020-08-18 | Wilson | North Carolina | 37195 | 1582 | 36 |
442676 | 442676 | 2020-08-17 | Wilson | North Carolina | 37195 | 1563 | 36 |
439449 | 439449 | 2020-08-16 | Wilson | North Carolina | 37195 | 1562 | 36 |
436224 | 436224 | 2020-08-15 | Wilson | North Carolina | 37195 | 1552 | 36 |
432998 | 432998 | 2020-08-14 | Wilson | North Carolina | 37195 | 1536 | 36 |
429772 | 429772 | 2020-08-13 | Wilson | North Carolina | 37195 | 1525 | 36 |
426547 | 426547 | 2020-08-12 | Wilson | North Carolina | 37195 | 1514 | 34 |
423324 | 423324 | 2020-08-11 | Wilson | North Carolina | 37195 | 1502 | 34 |
420101 | 420101 | 2020-08-10 | Wilson | North Carolina | 37195 | 1491 | 34 |
416881 | 416881 | 2020-08-09 | Wilson | North Carolina | 37195 | 1490 | 34 |
413660 | 413660 | 2020-08-08 | Wilson | North Carolina | 37195 | 1476 | 34 |
410440 | 410440 | 2020-08-07 | Wilson | North Carolina | 37195 | 1458 | 34 |
407220 | 407220 | 2020-08-06 | Wilson | North Carolina | 37195 | 1449 | 34 |
404001 | 404001 | 2020-08-05 | Wilson | North Carolina | 37195 | 1427 | 34 |
400783 | 400783 | 2020-08-04 | Wilson | North Carolina | 37195 | 1423 | 34 |
397568 | 397568 | 2020-08-03 | Wilson | North Carolina | 37195 | 1418 | 34 |
394351 | 394351 | 2020-08-02 | Wilson | North Carolina | 37195 | 1399 | 34 |
391135 | 391135 | 2020-08-01 | Wilson | North Carolina | 37195 | 1382 | 34 |
387918 | 387918 | 2020-07-31 | Wilson | North Carolina | 37195 | 1370 | 33 |
384701 | 384701 | 2020-07-30 | Wilson | North Carolina | 37195 | 1354 | 32 |
381483 | 381483 | 2020-07-29 | Wilson | North Carolina | 37195 | 1338 | 32 |
378266 | 378266 | 2020-07-28 | Wilson | North Carolina | 37195 | 1310 | 28 |
375050 | 375050 | 2020-07-27 | Wilson | North Carolina | 37195 | 1303 | 28 |
371838 | 371838 | 2020-07-26 | Wilson | North Carolina | 37195 | 1288 | 28 |
368626 | 368626 | 2020-07-25 | Wilson | North Carolina | 37195 | 1272 | 28 |
365417 | 365417 | 2020-07-24 | Wilson | North Carolina | 37195 | 1261 | 28 |
362211 | 362211 | 2020-07-23 | Wilson | North Carolina | 37195 | 1231 | 28 |
359005 | 359005 | 2020-07-22 | Wilson | North Carolina | 37195 | 1200 | 28 |
355801 | 355801 | 2020-07-21 | Wilson | North Carolina | 37195 | 1174 | 28 |
352598 | 352598 | 2020-07-20 | Wilson | North Carolina | 37195 | 1136 | 28 |
349395 | 349395 | 2020-07-19 | Wilson | North Carolina | 37195 | 1128 | 28 |
346194 | 346194 | 2020-07-18 | Wilson | North Carolina | 37195 | 1099 | 28 |
342995 | 342995 | 2020-07-17 | Wilson | North Carolina | 37195 | 1075 | 28 |
339797 | 339797 | 2020-07-16 | Wilson | North Carolina | 37195 | 1036 | 27 |
336601 | 336601 | 2020-07-15 | Wilson | North Carolina | 37195 | 1024 | 26 |
333407 | 333407 | 2020-07-14 | Wilson | North Carolina | 37195 | 980 | 26 |
330217 | 330217 | 2020-07-13 | Wilson | North Carolina | 37195 | 942 | 24 |
327030 | 327030 | 2020-07-12 | Wilson | North Carolina | 37195 | 920 | 24 |
323846 | 323846 | 2020-07-11 | Wilson | North Carolina | 37195 | 907 | 24 |
320666 | 320666 | 2020-07-10 | Wilson | North Carolina | 37195 | 870 | 23 |
317489 | 317489 | 2020-07-09 | Wilson | North Carolina | 37195 | 854 | 23 |
314315 | 314315 | 2020-07-08 | Wilson | North Carolina | 37195 | 837 | 23 |
311144 | 311144 | 2020-07-07 | Wilson | North Carolina | 37195 | 800 | 23 |
307976 | 307976 | 2020-07-06 | Wilson | North Carolina | 37195 | 786 | 19 |
304809 | 304809 | 2020-07-05 | Wilson | North Carolina | 37195 | 764 | 19 |
301646 | 301646 | 2020-07-04 | Wilson | North Carolina | 37195 | 757 | 19 |
298483 | 298483 | 2020-07-03 | Wilson | North Carolina | 37195 | 767 | 20 |
295323 | 295323 | 2020-07-02 | Wilson | North Carolina | 37195 | 745 | 20 |
292168 | 292168 | 2020-07-01 | Wilson | North Carolina | 37195 | 726 | 19 |
289016 | 289016 | 2020-06-30 | Wilson | North Carolina | 37195 | 714 | 18 |
285866 | 285866 | 2020-06-29 | Wilson | North Carolina | 37195 | 696 | 18 |
282721 | 282721 | 2020-06-28 | Wilson | North Carolina | 37195 | 682 | 18 |
279575 | 279575 | 2020-06-27 | Wilson | North Carolina | 37195 | 674 | 18 |
276427 | 276427 | 2020-06-26 | Wilson | North Carolina | 37195 | 661 | 18 |
273281 | 273281 | 2020-06-25 | Wilson | North Carolina | 37195 | 644 | 18 |
270142 | 270142 | 2020-06-24 | Wilson | North Carolina | 37195 | 633 | 18 |
267008 | 267008 | 2020-06-23 | Wilson | North Carolina | 37195 | 615 | 18 |
263880 | 263880 | 2020-06-22 | Wilson | North Carolina | 37195 | 610 | 16 |
260752 | 260752 | 2020-06-21 | Wilson | North Carolina | 37195 | 603 | 16 |
257625 | 257625 | 2020-06-20 | Wilson | North Carolina | 37195 | 594 | 16 |
254502 | 254502 | 2020-06-19 | Wilson | North Carolina | 37195 | 556 | 15 |
251387 | 251387 | 2020-06-18 | Wilson | North Carolina | 37195 | 545 | 15 |
248272 | 248272 | 2020-06-17 | Wilson | North Carolina | 37195 | 527 | 15 |
245159 | 245159 | 2020-06-16 | Wilson | North Carolina | 37195 | 524 | 15 |
242047 | 242047 | 2020-06-15 | Wilson | North Carolina | 37195 | 518 | 13 |
238938 | 238938 | 2020-06-14 | Wilson | North Carolina | 37195 | 507 | 13 |
235830 | 235830 | 2020-06-13 | Wilson | North Carolina | 37195 | 496 | 13 |
232725 | 232725 | 2020-06-12 | Wilson | North Carolina | 37195 | 473 | 13 |
229620 | 229620 | 2020-06-11 | Wilson | North Carolina | 37195 | 464 | 13 |
226516 | 226516 | 2020-06-10 | Wilson | North Carolina | 37195 | 456 | 13 |
223416 | 223416 | 2020-06-09 | Wilson | North Carolina | 37195 | 452 | 13 |
220322 | 220322 | 2020-06-08 | Wilson | North Carolina | 37195 | 445 | 12 |
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);