ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
802 rows where county = "Wake" 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 |
---|---|---|---|---|---|---|---|
1195104 | 1195104 | 2021-04-06 | Wake | North Carolina | 37183 | 82170 | 690 |
1191856 | 1191856 | 2021-04-05 | Wake | North Carolina | 37183 | 81962 | 690 |
1188607 | 1188607 | 2021-04-04 | Wake | North Carolina | 37183 | 81448 | 684 |
1185360 | 1185360 | 2021-04-03 | Wake | North Carolina | 37183 | 81448 | 684 |
1182113 | 1182113 | 2021-04-02 | Wake | North Carolina | 37183 | 81448 | 684 |
1178866 | 1178866 | 2021-04-01 | Wake | North Carolina | 37183 | 81448 | 684 |
1175619 | 1175619 | 2021-03-31 | Wake | North Carolina | 37183 | 81222 | 684 |
1172372 | 1172372 | 2021-03-30 | Wake | North Carolina | 37183 | 80975 | 684 |
1169125 | 1169125 | 2021-03-29 | Wake | North Carolina | 37183 | 80740 | 684 |
1165877 | 1165877 | 2021-03-28 | Wake | North Carolina | 37183 | 80346 | 678 |
1162629 | 1162629 | 2021-03-27 | Wake | North Carolina | 37183 | 80346 | 678 |
1159380 | 1159380 | 2021-03-26 | Wake | North Carolina | 37183 | 80346 | 678 |
1156133 | 1156133 | 2021-03-25 | Wake | North Carolina | 37183 | 80019 | 673 |
1152886 | 1152886 | 2021-03-24 | Wake | North Carolina | 37183 | 79872 | 646 |
1149639 | 1149639 | 2021-03-23 | Wake | North Carolina | 37183 | 79395 | 588 |
1146392 | 1146392 | 2021-03-22 | Wake | North Carolina | 37183 | 79274 | 587 |
1143145 | 1143145 | 2021-03-21 | Wake | North Carolina | 37183 | 78725 | 586 |
1139898 | 1139898 | 2021-03-20 | Wake | North Carolina | 37183 | 78725 | 586 |
1136652 | 1136652 | 2021-03-19 | Wake | North Carolina | 37183 | 78725 | 584 |
1133406 | 1133406 | 2021-03-18 | Wake | North Carolina | 37183 | 78546 | 583 |
1130158 | 1130158 | 2021-03-17 | Wake | North Carolina | 37183 | 77964 | 576 |
1126911 | 1126911 | 2021-03-16 | Wake | North Carolina | 37183 | 77964 | 574 |
1123665 | 1123665 | 2021-03-15 | Wake | North Carolina | 37183 | 77197 | 574 |
1120419 | 1120419 | 2021-03-14 | Wake | North Carolina | 37183 | 77197 | 572 |
1117172 | 1117172 | 2021-03-13 | Wake | North Carolina | 37183 | 77197 | 572 |
1113925 | 1113925 | 2021-03-12 | Wake | North Carolina | 37183 | 77197 | 566 |
1110679 | 1110679 | 2021-03-11 | Wake | North Carolina | 37183 | 77038 | 566 |
1107433 | 1107433 | 2021-03-10 | Wake | North Carolina | 37183 | 76880 | 565 |
1104187 | 1104187 | 2021-03-09 | Wake | North Carolina | 37183 | 76627 | 552 |
1100941 | 1100941 | 2021-03-08 | Wake | North Carolina | 37183 | 76386 | 550 |
1097695 | 1097695 | 2021-03-07 | Wake | North Carolina | 37183 | 76084 | 550 |
1094447 | 1094447 | 2021-03-06 | Wake | North Carolina | 37183 | 76084 | 550 |
1091201 | 1091201 | 2021-03-05 | Wake | North Carolina | 37183 | 76084 | 541 |
1087956 | 1087956 | 2021-03-04 | Wake | North Carolina | 37183 | 75883 | 534 |
1084711 | 1084711 | 2021-03-03 | Wake | North Carolina | 37183 | 75538 | 532 |
1081465 | 1081465 | 2021-03-02 | Wake | North Carolina | 37183 | 75337 | 527 |
1078219 | 1078219 | 2021-03-01 | Wake | North Carolina | 37183 | 74709 | 524 |
1074974 | 1074974 | 2021-02-28 | Wake | North Carolina | 37183 | 74709 | 521 |
1071728 | 1071728 | 2021-02-27 | Wake | North Carolina | 37183 | 74709 | 521 |
1068482 | 1068482 | 2021-02-26 | Wake | North Carolina | 37183 | 74709 | 521 |
1065237 | 1065237 | 2021-02-25 | Wake | North Carolina | 37183 | 74490 | 522 |
1061993 | 1061993 | 2021-02-24 | Wake | North Carolina | 37183 | 74124 | 520 |
1058747 | 1058747 | 2021-02-23 | Wake | North Carolina | 37183 | 74033 | 519 |
1055501 | 1055501 | 2021-02-22 | Wake | North Carolina | 37183 | 73948 | 520 |
1052255 | 1052255 | 2021-02-21 | Wake | North Carolina | 37183 | 73227 | 523 |
1049008 | 1049008 | 2021-02-20 | Wake | North Carolina | 37183 | 73227 | 523 |
1045761 | 1045761 | 2021-02-19 | Wake | North Carolina | 37183 | 73227 | 523 |
1042516 | 1042516 | 2021-02-18 | Wake | North Carolina | 37183 | 73078 | 518 |
1039271 | 1039271 | 2021-02-17 | Wake | North Carolina | 37183 | 72499 | 518 |
1036026 | 1036026 | 2021-02-16 | Wake | North Carolina | 37183 | 72499 | 518 |
1032781 | 1032781 | 2021-02-15 | Wake | North Carolina | 37183 | 72265 | 515 |
1029535 | 1029535 | 2021-02-14 | Wake | North Carolina | 37183 | 71546 | 512 |
1026288 | 1026288 | 2021-02-13 | Wake | North Carolina | 37183 | 71546 | 505 |
1023043 | 1023043 | 2021-02-12 | Wake | North Carolina | 37183 | 71546 | 505 |
1019798 | 1019798 | 2021-02-11 | Wake | North Carolina | 37183 | 71158 | 505 |
1016553 | 1016553 | 2021-02-10 | Wake | North Carolina | 37183 | 70514 | 501 |
1013308 | 1013308 | 2021-02-09 | Wake | North Carolina | 37183 | 70367 | 496 |
1010063 | 1010063 | 2021-02-08 | Wake | North Carolina | 37183 | 69026 | 495 |
1006817 | 1006817 | 2021-02-07 | Wake | North Carolina | 37183 | 69026 | 495 |
1003571 | 1003571 | 2021-02-06 | Wake | North Carolina | 37183 | 69026 | 496 |
1000325 | 1000325 | 2021-02-05 | Wake | North Carolina | 37183 | 69026 | 493 |
997079 | 997079 | 2021-02-04 | Wake | North Carolina | 37183 | 68495 | 468 |
993833 | 993833 | 2021-02-03 | Wake | North Carolina | 37183 | 66901 | 444 |
990587 | 990587 | 2021-02-02 | Wake | North Carolina | 37183 | 66901 | 436 |
987341 | 987341 | 2021-02-01 | Wake | North Carolina | 37183 | 66925 | 427 |
984094 | 984094 | 2021-01-31 | Wake | North Carolina | 37183 | 65128 | 427 |
980847 | 980847 | 2021-01-30 | Wake | North Carolina | 37183 | 64756 | 428 |
977601 | 977601 | 2021-01-29 | Wake | North Carolina | 37183 | 64756 | 428 |
974356 | 974356 | 2021-01-28 | Wake | North Carolina | 37183 | 63196 | 427 |
971111 | 971111 | 2021-01-27 | Wake | North Carolina | 37183 | 62477 | 413 |
967866 | 967866 | 2021-01-26 | Wake | North Carolina | 37183 | 62414 | 413 |
964622 | 964622 | 2021-01-25 | Wake | North Carolina | 37183 | 61709 | 413 |
961377 | 961377 | 2021-01-24 | Wake | North Carolina | 37183 | 61106 | 413 |
958132 | 958132 | 2021-01-23 | Wake | North Carolina | 37183 | 60748 | 413 |
954886 | 954886 | 2021-01-22 | Wake | North Carolina | 37183 | 60748 | 401 |
951641 | 951641 | 2021-01-21 | Wake | North Carolina | 37183 | 59156 | 397 |
948396 | 948396 | 2021-01-20 | Wake | North Carolina | 37183 | 58895 | 396 |
945150 | 945150 | 2021-01-19 | Wake | North Carolina | 37183 | 57650 | 396 |
941903 | 941903 | 2021-01-18 | Wake | North Carolina | 37183 | 56369 | 396 |
938658 | 938658 | 2021-01-17 | Wake | North Carolina | 37183 | 56859 | 396 |
935413 | 935413 | 2021-01-16 | Wake | North Carolina | 37183 | 56241 | 394 |
932168 | 932168 | 2021-01-15 | Wake | North Carolina | 37183 | 55561 | 394 |
928923 | 928923 | 2021-01-14 | Wake | North Carolina | 37183 | 54261 | 374 |
925678 | 925678 | 2021-01-13 | Wake | North Carolina | 37183 | 53462 | 374 |
922432 | 922432 | 2021-01-12 | Wake | North Carolina | 37183 | 53330 | 373 |
919187 | 919187 | 2021-01-11 | Wake | North Carolina | 37183 | 53330 | 373 |
915942 | 915942 | 2021-01-10 | Wake | North Carolina | 37183 | 51290 | 373 |
912697 | 912697 | 2021-01-09 | Wake | North Carolina | 37183 | 50627 | 362 |
909452 | 909452 | 2021-01-08 | Wake | North Carolina | 37183 | 50475 | 361 |
906207 | 906207 | 2021-01-07 | Wake | North Carolina | 37183 | 50475 | 354 |
902961 | 902961 | 2021-01-06 | Wake | North Carolina | 37183 | 48580 | 354 |
899716 | 899716 | 2021-01-05 | Wake | North Carolina | 37183 | 48580 | 351 |
896471 | 896471 | 2021-01-04 | Wake | North Carolina | 37183 | 47435 | 348 |
893225 | 893225 | 2021-01-03 | Wake | North Carolina | 37183 | 45944 | 348 |
889979 | 889979 | 2021-01-02 | Wake | North Carolina | 37183 | 45944 | 348 |
886732 | 886732 | 2021-01-01 | Wake | North Carolina | 37183 | 45944 | 344 |
883487 | 883487 | 2020-12-31 | Wake | North Carolina | 37183 | 44203 | 344 |
880242 | 880242 | 2020-12-30 | Wake | North Carolina | 37183 | 44203 | 345 |
876997 | 876997 | 2020-12-29 | Wake | North Carolina | 37183 | 43539 | 337 |
873752 | 873752 | 2020-12-28 | Wake | North Carolina | 37183 | 42609 | 337 |
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);