ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Stanly" 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 |
---|---|---|---|---|---|---|---|
536402 | 536402 | 2020-09-15 | Stanly | North Carolina | 37167 | 1733 | 52 |
533166 | 533166 | 2020-09-14 | Stanly | North Carolina | 37167 | 1720 | 52 |
529931 | 529931 | 2020-09-13 | Stanly | North Carolina | 37167 | 1713 | 52 |
526694 | 526694 | 2020-09-12 | Stanly | North Carolina | 37167 | 1705 | 52 |
523458 | 523458 | 2020-09-11 | Stanly | North Carolina | 37167 | 1655 | 52 |
520222 | 520222 | 2020-09-10 | Stanly | North Carolina | 37167 | 1645 | 52 |
516986 | 516986 | 2020-09-09 | Stanly | North Carolina | 37167 | 1637 | 52 |
513751 | 513751 | 2020-09-08 | Stanly | North Carolina | 37167 | 1628 | 52 |
510518 | 510518 | 2020-09-07 | Stanly | North Carolina | 37167 | 1623 | 53 |
507285 | 507285 | 2020-09-06 | Stanly | North Carolina | 37167 | 1618 | 53 |
504053 | 504053 | 2020-09-05 | Stanly | North Carolina | 37167 | 1612 | 53 |
500819 | 500819 | 2020-09-04 | Stanly | North Carolina | 37167 | 1609 | 31 |
497585 | 497585 | 2020-09-03 | Stanly | North Carolina | 37167 | 1556 | 31 |
494352 | 494352 | 2020-09-02 | Stanly | North Carolina | 37167 | 1534 | 31 |
491118 | 491118 | 2020-09-01 | Stanly | North Carolina | 37167 | 1528 | 31 |
487885 | 487885 | 2020-08-31 | Stanly | North Carolina | 37167 | 1490 | 31 |
484652 | 484652 | 2020-08-30 | Stanly | North Carolina | 37167 | 1475 | 31 |
481417 | 481417 | 2020-08-29 | Stanly | North Carolina | 37167 | 1467 | 31 |
478184 | 478184 | 2020-08-28 | Stanly | North Carolina | 37167 | 1440 | 31 |
474951 | 474951 | 2020-08-27 | Stanly | North Carolina | 37167 | 1427 | 31 |
471717 | 471717 | 2020-08-26 | Stanly | North Carolina | 37167 | 1413 | 31 |
468485 | 468485 | 2020-08-25 | Stanly | North Carolina | 37167 | 1400 | 31 |
465257 | 465257 | 2020-08-24 | Stanly | North Carolina | 37167 | 1381 | 31 |
462028 | 462028 | 2020-08-23 | Stanly | North Carolina | 37167 | 1375 | 31 |
458800 | 458800 | 2020-08-22 | Stanly | North Carolina | 37167 | 1363 | 31 |
455572 | 455572 | 2020-08-21 | Stanly | North Carolina | 37167 | 1345 | 31 |
452344 | 452344 | 2020-08-20 | Stanly | North Carolina | 37167 | 1300 | 31 |
449116 | 449116 | 2020-08-19 | Stanly | North Carolina | 37167 | 1276 | 31 |
445888 | 445888 | 2020-08-18 | Stanly | North Carolina | 37167 | 1261 | 31 |
442662 | 442662 | 2020-08-17 | Stanly | North Carolina | 37167 | 1237 | 31 |
439435 | 439435 | 2020-08-16 | Stanly | North Carolina | 37167 | 1235 | 31 |
436210 | 436210 | 2020-08-15 | Stanly | North Carolina | 37167 | 1224 | 31 |
432984 | 432984 | 2020-08-14 | Stanly | North Carolina | 37167 | 1207 | 31 |
429758 | 429758 | 2020-08-13 | Stanly | North Carolina | 37167 | 1171 | 31 |
426533 | 426533 | 2020-08-12 | Stanly | North Carolina | 37167 | 1103 | 31 |
423310 | 423310 | 2020-08-11 | Stanly | North Carolina | 37167 | 1089 | 26 |
420087 | 420087 | 2020-08-10 | Stanly | North Carolina | 37167 | 1075 | 26 |
416867 | 416867 | 2020-08-09 | Stanly | North Carolina | 37167 | 1064 | 26 |
413646 | 413646 | 2020-08-08 | Stanly | North Carolina | 37167 | 1049 | 26 |
410426 | 410426 | 2020-08-07 | Stanly | North Carolina | 37167 | 1026 | 24 |
407206 | 407206 | 2020-08-06 | Stanly | North Carolina | 37167 | 1000 | 24 |
403987 | 403987 | 2020-08-05 | Stanly | North Carolina | 37167 | 938 | 24 |
400769 | 400769 | 2020-08-04 | Stanly | North Carolina | 37167 | 928 | 11 |
397554 | 397554 | 2020-08-03 | Stanly | North Carolina | 37167 | 906 | 11 |
394337 | 394337 | 2020-08-02 | Stanly | North Carolina | 37167 | 897 | 11 |
391121 | 391121 | 2020-08-01 | Stanly | North Carolina | 37167 | 884 | 11 |
387904 | 387904 | 2020-07-31 | Stanly | North Carolina | 37167 | 866 | 11 |
384687 | 384687 | 2020-07-30 | Stanly | North Carolina | 37167 | 848 | 10 |
381469 | 381469 | 2020-07-29 | Stanly | North Carolina | 37167 | 827 | 8 |
378252 | 378252 | 2020-07-28 | Stanly | North Carolina | 37167 | 802 | 6 |
375036 | 375036 | 2020-07-27 | Stanly | North Carolina | 37167 | 793 | 6 |
371824 | 371824 | 2020-07-26 | Stanly | North Carolina | 37167 | 778 | 6 |
368612 | 368612 | 2020-07-25 | Stanly | North Carolina | 37167 | 764 | 6 |
365403 | 365403 | 2020-07-24 | Stanly | North Carolina | 37167 | 740 | 6 |
362197 | 362197 | 2020-07-23 | Stanly | North Carolina | 37167 | 722 | 6 |
358991 | 358991 | 2020-07-22 | Stanly | North Carolina | 37167 | 708 | 5 |
355787 | 355787 | 2020-07-21 | Stanly | North Carolina | 37167 | 670 | 5 |
352584 | 352584 | 2020-07-20 | Stanly | North Carolina | 37167 | 662 | 5 |
349381 | 349381 | 2020-07-19 | Stanly | North Carolina | 37167 | 657 | 5 |
346180 | 346180 | 2020-07-18 | Stanly | North Carolina | 37167 | 640 | 5 |
342981 | 342981 | 2020-07-17 | Stanly | North Carolina | 37167 | 621 | 5 |
339783 | 339783 | 2020-07-16 | Stanly | North Carolina | 37167 | 613 | 5 |
336587 | 336587 | 2020-07-15 | Stanly | North Carolina | 37167 | 597 | 5 |
333393 | 333393 | 2020-07-14 | Stanly | North Carolina | 37167 | 585 | 5 |
330203 | 330203 | 2020-07-13 | Stanly | North Carolina | 37167 | 572 | 5 |
327016 | 327016 | 2020-07-12 | Stanly | North Carolina | 37167 | 563 | 5 |
323832 | 323832 | 2020-07-11 | Stanly | North Carolina | 37167 | 553 | 5 |
320652 | 320652 | 2020-07-10 | Stanly | North Carolina | 37167 | 539 | 5 |
317475 | 317475 | 2020-07-09 | Stanly | North Carolina | 37167 | 531 | 5 |
314301 | 314301 | 2020-07-08 | Stanly | North Carolina | 37167 | 484 | 5 |
311130 | 311130 | 2020-07-07 | Stanly | North Carolina | 37167 | 481 | 5 |
307962 | 307962 | 2020-07-06 | Stanly | North Carolina | 37167 | 479 | 5 |
304795 | 304795 | 2020-07-05 | Stanly | North Carolina | 37167 | 468 | 5 |
301632 | 301632 | 2020-07-04 | Stanly | North Carolina | 37167 | 459 | 5 |
298469 | 298469 | 2020-07-03 | Stanly | North Carolina | 37167 | 437 | 5 |
295309 | 295309 | 2020-07-02 | Stanly | North Carolina | 37167 | 411 | 5 |
292154 | 292154 | 2020-07-01 | Stanly | North Carolina | 37167 | 394 | 5 |
289002 | 289002 | 2020-06-30 | Stanly | North Carolina | 37167 | 378 | 5 |
285852 | 285852 | 2020-06-29 | Stanly | North Carolina | 37167 | 373 | 5 |
282707 | 282707 | 2020-06-28 | Stanly | North Carolina | 37167 | 359 | 5 |
279561 | 279561 | 2020-06-27 | Stanly | North Carolina | 37167 | 340 | 5 |
276413 | 276413 | 2020-06-26 | Stanly | North Carolina | 37167 | 315 | 5 |
273267 | 273267 | 2020-06-25 | Stanly | North Carolina | 37167 | 308 | 5 |
270128 | 270128 | 2020-06-24 | Stanly | North Carolina | 37167 | 298 | 5 |
266994 | 266994 | 2020-06-23 | Stanly | North Carolina | 37167 | 282 | 5 |
263866 | 263866 | 2020-06-22 | Stanly | North Carolina | 37167 | 277 | 5 |
260738 | 260738 | 2020-06-21 | Stanly | North Carolina | 37167 | 234 | 5 |
257611 | 257611 | 2020-06-20 | Stanly | North Carolina | 37167 | 208 | 5 |
254488 | 254488 | 2020-06-19 | Stanly | North Carolina | 37167 | 195 | 5 |
251373 | 251373 | 2020-06-18 | Stanly | North Carolina | 37167 | 180 | 5 |
248258 | 248258 | 2020-06-17 | Stanly | North Carolina | 37167 | 174 | 5 |
245145 | 245145 | 2020-06-16 | Stanly | North Carolina | 37167 | 167 | 5 |
242033 | 242033 | 2020-06-15 | Stanly | North Carolina | 37167 | 164 | 5 |
238924 | 238924 | 2020-06-14 | Stanly | North Carolina | 37167 | 163 | 5 |
235816 | 235816 | 2020-06-13 | Stanly | North Carolina | 37167 | 150 | 4 |
232711 | 232711 | 2020-06-12 | Stanly | North Carolina | 37167 | 144 | 4 |
229606 | 229606 | 2020-06-11 | Stanly | North Carolina | 37167 | 130 | 4 |
226502 | 226502 | 2020-06-10 | Stanly | North Carolina | 37167 | 124 | 4 |
223402 | 223402 | 2020-06-09 | Stanly | North Carolina | 37167 | 119 | 4 |
220308 | 220308 | 2020-06-08 | Stanly | North Carolina | 37167 | 117 | 4 |
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);