ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
804 rows where county = "New York City" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1194983 | 1194983 | 2021-04-06 | New York City | New York | 867989 | 31531 | |
1191735 | 1191735 | 2021-04-05 | New York City | New York | 864732 | 31500 | |
1188486 | 1188486 | 2021-04-04 | New York City | New York | 861481 | 31449 | |
1185239 | 1185239 | 2021-04-03 | New York City | New York | 857653 | 31388 | |
1181992 | 1181992 | 2021-04-02 | New York City | New York | 854068 | 31316 | |
1178745 | 1178745 | 2021-04-01 | New York City | New York | 850006 | 31262 | |
1175498 | 1175498 | 2021-03-31 | New York City | New York | 845399 | 31209 | |
1172251 | 1172251 | 2021-03-30 | New York City | New York | 841913 | 31142 | |
1169004 | 1169004 | 2021-03-29 | New York City | New York | 839533 | 31117 | |
1165756 | 1165756 | 2021-03-28 | New York City | New York | 834198 | 31026 | |
1162508 | 1162508 | 2021-03-27 | New York City | New York | 829539 | 30949 | |
1159259 | 1159259 | 2021-03-26 | New York City | New York | 825104 | 30898 | |
1156012 | 1156012 | 2021-03-25 | New York City | New York | 821215 | 30852 | |
1152765 | 1152765 | 2021-03-24 | New York City | New York | 816580 | 30793 | |
1149518 | 1149518 | 2021-03-23 | New York City | New York | 799865 | 30564 | |
1146271 | 1146271 | 2021-03-22 | New York City | New York | 796373 | 30564 | |
1143024 | 1143024 | 2021-03-21 | New York City | New York | 794261 | 30564 | |
1139777 | 1139777 | 2021-03-20 | New York City | New York | 794261 | 30564 | |
1136531 | 1136531 | 2021-03-19 | New York City | New York | 791453 | 30519 | |
1133285 | 1133285 | 2021-03-18 | New York City | New York | 790069 | 30471 | |
1130037 | 1130037 | 2021-03-17 | New York City | New York | 788302 | 30406 | |
1126790 | 1126790 | 2021-03-16 | New York City | New York | 785307 | 30366 | |
1123544 | 1123544 | 2021-03-15 | New York City | New York | 781734 | 30303 | |
1120298 | 1120298 | 2021-03-14 | New York City | New York | 777418 | 30258 | |
1117051 | 1117051 | 2021-03-13 | New York City | New York | 773540 | 30174 | |
1113804 | 1113804 | 2021-03-12 | New York City | New York | 770654 | 30116 | |
1110558 | 1110558 | 2021-03-11 | New York City | New York | 766428 | 30068 | |
1107312 | 1107312 | 2021-03-10 | New York City | New York | 762458 | 29983 | |
1104066 | 1104066 | 2021-03-09 | New York City | New York | 759421 | 29911 | |
1100820 | 1100820 | 2021-03-08 | New York City | New York | 755495 | 29866 | |
1097574 | 1097574 | 2021-03-07 | New York City | New York | 752617 | 29823 | |
1094326 | 1094326 | 2021-03-06 | New York City | New York | 748241 | 29760 | |
1091080 | 1091080 | 2021-03-05 | New York City | New York | 743683 | 29700 | |
1087835 | 1087835 | 2021-03-04 | New York City | New York | 739632 | 29640 | |
1084590 | 1084590 | 2021-03-03 | New York City | New York | 735732 | 29564 | |
1081344 | 1081344 | 2021-03-02 | New York City | New York | 732557 | 29473 | |
1078098 | 1078098 | 2021-03-01 | New York City | New York | 728859 | 29408 | |
1074853 | 1074853 | 2021-02-28 | New York City | New York | 725155 | 29332 | |
1071607 | 1071607 | 2021-02-27 | New York City | New York | 720951 | 29253 | |
1068361 | 1068361 | 2021-02-26 | New York City | New York | 716678 | 29173 | |
1065116 | 1065116 | 2021-02-25 | New York City | New York | 712389 | 29088 | |
1061872 | 1061872 | 2021-02-24 | New York City | New York | 707929 | 29025 | |
1058626 | 1058626 | 2021-02-23 | New York City | New York | 704616 | 28954 | |
1055380 | 1055380 | 2021-02-22 | New York City | New York | 700815 | 28888 | |
1052134 | 1052134 | 2021-02-21 | New York City | New York | 697306 | 28824 | |
1048887 | 1048887 | 2021-02-20 | New York City | New York | 694295 | 28748 | |
1045640 | 1045640 | 2021-02-19 | New York City | New York | 689599 | 28686 | |
1042395 | 1042395 | 2021-02-18 | New York City | New York | 684864 | 28590 | |
1039150 | 1039150 | 2021-02-17 | New York City | New York | 678638 | 28493 | |
1035905 | 1035905 | 2021-02-16 | New York City | New York | 675727 | 28428 | |
1032660 | 1032660 | 2021-02-15 | New York City | New York | 672071 | 28341 | |
1029414 | 1029414 | 2021-02-14 | New York City | New York | 668443 | 28270 | |
1026167 | 1026167 | 2021-02-13 | New York City | New York | 664307 | 28193 | |
1022922 | 1022922 | 2021-02-12 | New York City | New York | 659734 | 28094 | |
1019677 | 1019677 | 2021-02-11 | New York City | New York | 655228 | 28021 | |
1016432 | 1016432 | 2021-02-10 | New York City | New York | 650123 | 27949 | |
1013187 | 1013187 | 2021-02-09 | New York City | New York | 647322 | 27856 | |
1009942 | 1009942 | 2021-02-08 | New York City | New York | 642557 | 27768 | |
1006696 | 1006696 | 2021-02-07 | New York City | New York | 637486 | 27705 | |
1003450 | 1003450 | 2021-02-06 | New York City | New York | 632306 | 27609 | |
1000204 | 1000204 | 2021-02-05 | New York City | New York | 626716 | 27506 | |
996958 | 996958 | 2021-02-04 | New York City | New York | 623713 | 27428 | |
993712 | 993712 | 2021-02-03 | New York City | New York | 621218 | 27354 | |
990466 | 990466 | 2021-02-02 | New York City | New York | 617406 | 27298 | |
987220 | 987220 | 2021-02-01 | New York City | New York | 613480 | 27226 | |
983973 | 983973 | 2021-01-31 | New York City | New York | 608862 | 27138 | |
980726 | 980726 | 2021-01-30 | New York City | New York | 603428 | 27042 | |
977480 | 977480 | 2021-01-29 | New York City | New York | 597312 | 26953 | |
974235 | 974235 | 2021-01-28 | New York City | New York | 591160 | 26856 | |
970990 | 970990 | 2021-01-27 | New York City | New York | 584673 | 26763 | |
967745 | 967745 | 2021-01-26 | New York City | New York | 580389 | 26720 | |
964501 | 964501 | 2021-01-25 | New York City | New York | 575332 | 26648 | |
961256 | 961256 | 2021-01-24 | New York City | New York | 569668 | 26558 | |
958011 | 958011 | 2021-01-23 | New York City | New York | 564245 | 26466 | |
954765 | 954765 | 2021-01-22 | New York City | New York | 558262 | 26398 | |
951520 | 951520 | 2021-01-21 | New York City | New York | 551415 | 26331 | |
948275 | 948275 | 2021-01-20 | New York City | New York | 546195 | 26249 | |
945028 | 945028 | 2021-01-19 | New York City | New York | 541846 | 26161 | |
941782 | 941782 | 2021-01-18 | New York City | New York | 536287 | 26104 | |
938537 | 938537 | 2021-01-17 | New York City | New York | 529834 | 26036 | |
935292 | 935292 | 2021-01-16 | New York City | New York | 524231 | 25970 | |
932047 | 932047 | 2021-01-15 | New York City | New York | 517963 | 25909 | |
928802 | 928802 | 2021-01-14 | New York City | New York | 510711 | 25834 | |
925557 | 925557 | 2021-01-13 | New York City | New York | 504826 | 25741 | |
922311 | 922311 | 2021-01-12 | New York City | New York | 498877 | 25698 | |
919066 | 919066 | 2021-01-11 | New York City | New York | 493306 | 25635 | |
915821 | 915821 | 2021-01-10 | New York City | New York | 487551 | 25562 | |
912576 | 912576 | 2021-01-09 | New York City | New York | 481279 | 25505 | |
909331 | 909331 | 2021-01-08 | New York City | New York | 474339 | 25453 | |
906086 | 906086 | 2021-01-07 | New York City | New York | 467327 | 25416 | |
902840 | 902840 | 2021-01-06 | New York City | New York | 460988 | 25362 | |
899595 | 899595 | 2021-01-05 | New York City | New York | 455997 | 25309 | |
896350 | 896350 | 2021-01-04 | New York City | New York | 450658 | 25284 | |
893104 | 893104 | 2021-01-03 | New York City | New York | 446899 | 25244 | |
889858 | 889858 | 2021-01-02 | New York City | New York | 442695 | 25211 | |
886611 | 886611 | 2021-01-01 | New York City | New York | 436692 | 25186 | |
883366 | 883366 | 2020-12-31 | New York City | New York | 430863 | 25144 | |
880121 | 880121 | 2020-12-30 | New York City | New York | 426279 | 25099 | |
876876 | 876876 | 2020-12-29 | New York City | New York | 422074 | 25055 | |
873631 | 873631 | 2020-12-28 | New York City | New York | 416922 | 25008 |
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);