ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72001 and state = "Puerto Rico" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1055835 | 1055835 | 2021-02-22 | Adjuntas | Puerto Rico | 72001 | 461 | |
1052589 | 1052589 | 2021-02-21 | Adjuntas | Puerto Rico | 72001 | 461 | |
1049342 | 1049342 | 2021-02-20 | Adjuntas | Puerto Rico | 72001 | 461 | |
1046095 | 1046095 | 2021-02-19 | Adjuntas | Puerto Rico | 72001 | 460 | |
1042850 | 1042850 | 2021-02-18 | Adjuntas | Puerto Rico | 72001 | 459 | |
1039605 | 1039605 | 2021-02-17 | Adjuntas | Puerto Rico | 72001 | 459 | |
1036360 | 1036360 | 2021-02-16 | Adjuntas | Puerto Rico | 72001 | 459 | |
1033115 | 1033115 | 2021-02-15 | Adjuntas | Puerto Rico | 72001 | 459 | |
1029869 | 1029869 | 2021-02-14 | Adjuntas | Puerto Rico | 72001 | 459 | |
1026622 | 1026622 | 2021-02-13 | Adjuntas | Puerto Rico | 72001 | 457 | |
1023377 | 1023377 | 2021-02-12 | Adjuntas | Puerto Rico | 72001 | 456 | |
1020132 | 1020132 | 2021-02-11 | Adjuntas | Puerto Rico | 72001 | 454 | |
1016887 | 1016887 | 2021-02-10 | Adjuntas | Puerto Rico | 72001 | 454 | |
1013642 | 1013642 | 2021-02-09 | Adjuntas | Puerto Rico | 72001 | 454 | |
1010397 | 1010397 | 2021-02-08 | Adjuntas | Puerto Rico | 72001 | 454 | |
1007151 | 1007151 | 2021-02-07 | Adjuntas | Puerto Rico | 72001 | 454 | |
1003905 | 1003905 | 2021-02-06 | Adjuntas | Puerto Rico | 72001 | 453 | |
1000659 | 1000659 | 2021-02-05 | Adjuntas | Puerto Rico | 72001 | 452 | |
997413 | 997413 | 2021-02-04 | Adjuntas | Puerto Rico | 72001 | 452 | |
994167 | 994167 | 2021-02-03 | Adjuntas | Puerto Rico | 72001 | 452 | |
990921 | 990921 | 2021-02-02 | Adjuntas | Puerto Rico | 72001 | 452 | |
987675 | 987675 | 2021-02-01 | Adjuntas | Puerto Rico | 72001 | 452 | |
984428 | 984428 | 2021-01-31 | Adjuntas | Puerto Rico | 72001 | 452 | |
981181 | 981181 | 2021-01-30 | Adjuntas | Puerto Rico | 72001 | 451 | |
977935 | 977935 | 2021-01-29 | Adjuntas | Puerto Rico | 72001 | 450 | |
974690 | 974690 | 2021-01-28 | Adjuntas | Puerto Rico | 72001 | 449 | |
971445 | 971445 | 2021-01-27 | Adjuntas | Puerto Rico | 72001 | 449 | |
968200 | 968200 | 2021-01-26 | Adjuntas | Puerto Rico | 72001 | 449 | |
964956 | 964956 | 2021-01-25 | Adjuntas | Puerto Rico | 72001 | 446 | |
961711 | 961711 | 2021-01-24 | Adjuntas | Puerto Rico | 72001 | 445 | |
958466 | 958466 | 2021-01-23 | Adjuntas | Puerto Rico | 72001 | 445 | |
955220 | 955220 | 2021-01-22 | Adjuntas | Puerto Rico | 72001 | 443 | |
951975 | 951975 | 2021-01-21 | Adjuntas | Puerto Rico | 72001 | 443 | |
948730 | 948730 | 2021-01-20 | Adjuntas | Puerto Rico | 72001 | 443 | |
945484 | 945484 | 2021-01-19 | Adjuntas | Puerto Rico | 72001 | 441 | |
942237 | 942237 | 2021-01-18 | Adjuntas | Puerto Rico | 72001 | 441 | |
938992 | 938992 | 2021-01-17 | Adjuntas | Puerto Rico | 72001 | 439 | |
935747 | 935747 | 2021-01-16 | Adjuntas | Puerto Rico | 72001 | 437 | |
932502 | 932502 | 2021-01-15 | Adjuntas | Puerto Rico | 72001 | 436 | |
929257 | 929257 | 2021-01-14 | Adjuntas | Puerto Rico | 72001 | 432 | |
926012 | 926012 | 2021-01-13 | Adjuntas | Puerto Rico | 72001 | 432 | |
922766 | 922766 | 2021-01-12 | Adjuntas | Puerto Rico | 72001 | 432 | |
919521 | 919521 | 2021-01-11 | Adjuntas | Puerto Rico | 72001 | 430 | |
916276 | 916276 | 2021-01-10 | Adjuntas | Puerto Rico | 72001 | 430 | |
913031 | 913031 | 2021-01-09 | Adjuntas | Puerto Rico | 72001 | 421 | |
909786 | 909786 | 2021-01-08 | Adjuntas | Puerto Rico | 72001 | 421 | |
906541 | 906541 | 2021-01-07 | Adjuntas | Puerto Rico | 72001 | 419 | |
903295 | 903295 | 2021-01-06 | Adjuntas | Puerto Rico | 72001 | 417 | |
900050 | 900050 | 2021-01-05 | Adjuntas | Puerto Rico | 72001 | 416 | |
896805 | 896805 | 2021-01-04 | Adjuntas | Puerto Rico | 72001 | 416 | |
893559 | 893559 | 2021-01-03 | Adjuntas | Puerto Rico | 72001 | 415 | |
890313 | 890313 | 2021-01-02 | Adjuntas | Puerto Rico | 72001 | 406 | |
887066 | 887066 | 2021-01-01 | Adjuntas | Puerto Rico | 72001 | 400 | |
883821 | 883821 | 2020-12-31 | Adjuntas | Puerto Rico | 72001 | 396 | |
880576 | 880576 | 2020-12-30 | Adjuntas | Puerto Rico | 72001 | 394 | |
877331 | 877331 | 2020-12-29 | Adjuntas | Puerto Rico | 72001 | 394 | |
874086 | 874086 | 2020-12-28 | Adjuntas | Puerto Rico | 72001 | 379 | |
870841 | 870841 | 2020-12-27 | Adjuntas | Puerto Rico | 72001 | 379 | |
867596 | 867596 | 2020-12-26 | Adjuntas | Puerto Rico | 72001 | 376 | |
864351 | 864351 | 2020-12-25 | Adjuntas | Puerto Rico | 72001 | 367 | |
861106 | 861106 | 2020-12-24 | Adjuntas | Puerto Rico | 72001 | 364 | |
857861 | 857861 | 2020-12-23 | Adjuntas | Puerto Rico | 72001 | 357 | |
854616 | 854616 | 2020-12-22 | Adjuntas | Puerto Rico | 72001 | 356 | |
851371 | 851371 | 2020-12-21 | Adjuntas | Puerto Rico | 72001 | 352 | |
848126 | 848126 | 2020-12-20 | Adjuntas | Puerto Rico | 72001 | 347 | |
844881 | 844881 | 2020-12-19 | Adjuntas | Puerto Rico | 72001 | 344 | |
841635 | 841635 | 2020-12-18 | Adjuntas | Puerto Rico | 72001 | 339 | |
838390 | 838390 | 2020-12-17 | Adjuntas | Puerto Rico | 72001 | 333 | |
835144 | 835144 | 2020-12-16 | Adjuntas | Puerto Rico | 72001 | 316 | |
831898 | 831898 | 2020-12-15 | Adjuntas | Puerto Rico | 72001 | 316 | |
828651 | 828651 | 2020-12-14 | Adjuntas | Puerto Rico | 72001 | 311 | |
825405 | 825405 | 2020-12-13 | Adjuntas | Puerto Rico | 72001 | 303 | |
822158 | 822158 | 2020-12-12 | Adjuntas | Puerto Rico | 72001 | 300 | |
818912 | 818912 | 2020-12-11 | Adjuntas | Puerto Rico | 72001 | 293 | |
815666 | 815666 | 2020-12-10 | Adjuntas | Puerto Rico | 72001 | 268 | |
812420 | 812420 | 2020-12-09 | Adjuntas | Puerto Rico | 72001 | 265 | |
809176 | 809176 | 2020-12-08 | Adjuntas | Puerto Rico | 72001 | 265 | |
805931 | 805931 | 2020-12-07 | Adjuntas | Puerto Rico | 72001 | 258 | |
802686 | 802686 | 2020-12-06 | Adjuntas | Puerto Rico | 72001 | 254 | |
799441 | 799441 | 2020-12-05 | Adjuntas | Puerto Rico | 72001 | 249 | |
796196 | 796196 | 2020-12-04 | Adjuntas | Puerto Rico | 72001 | 248 | |
792951 | 792951 | 2020-12-03 | Adjuntas | Puerto Rico | 72001 | 247 | |
789706 | 789706 | 2020-12-02 | Adjuntas | Puerto Rico | 72001 | 244 | |
786461 | 786461 | 2020-12-01 | Adjuntas | Puerto Rico | 72001 | 244 | |
783217 | 783217 | 2020-11-30 | Adjuntas | Puerto Rico | 72001 | 244 | |
779972 | 779972 | 2020-11-29 | Adjuntas | Puerto Rico | 72001 | 240 | |
776726 | 776726 | 2020-11-28 | Adjuntas | Puerto Rico | 72001 | 240 | |
773481 | 773481 | 2020-11-27 | Adjuntas | Puerto Rico | 72001 | 237 | |
770236 | 770236 | 2020-11-26 | Adjuntas | Puerto Rico | 72001 | 236 | |
766990 | 766990 | 2020-11-25 | Adjuntas | Puerto Rico | 72001 | 233 | |
763745 | 763745 | 2020-11-24 | Adjuntas | Puerto Rico | 72001 | 233 | |
760500 | 760500 | 2020-11-23 | Adjuntas | Puerto Rico | 72001 | 232 | |
757255 | 757255 | 2020-11-22 | Adjuntas | Puerto Rico | 72001 | 226 | |
754008 | 754008 | 2020-11-21 | Adjuntas | Puerto Rico | 72001 | 226 | |
750762 | 750762 | 2020-11-20 | Adjuntas | Puerto Rico | 72001 | 223 | |
747516 | 747516 | 2020-11-19 | Adjuntas | Puerto Rico | 72001 | 222 | |
744270 | 744270 | 2020-11-18 | Adjuntas | Puerto Rico | 72001 | 221 | |
741023 | 741023 | 2020-11-17 | Adjuntas | Puerto Rico | 72001 | 221 | |
737777 | 737777 | 2020-11-16 | Adjuntas | Puerto Rico | 72001 | 221 | |
734533 | 734533 | 2020-11-15 | Adjuntas | Puerto Rico | 72001 | 221 |
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);