ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72037 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 |
---|---|---|---|---|---|---|---|
1195457 | 1195457 | 2021-04-06 | Ceiba | Puerto Rico | 72037 | 420 | |
1192209 | 1192209 | 2021-04-05 | Ceiba | Puerto Rico | 72037 | 420 | |
1188960 | 1188960 | 2021-04-04 | Ceiba | Puerto Rico | 72037 | 419 | |
1185713 | 1185713 | 2021-04-03 | Ceiba | Puerto Rico | 72037 | 417 | |
1182466 | 1182466 | 2021-04-02 | Ceiba | Puerto Rico | 72037 | 416 | |
1179219 | 1179219 | 2021-04-01 | Ceiba | Puerto Rico | 72037 | 416 | |
1175972 | 1175972 | 2021-03-31 | Ceiba | Puerto Rico | 72037 | 416 | |
1172725 | 1172725 | 2021-03-30 | Ceiba | Puerto Rico | 72037 | 416 | |
1169478 | 1169478 | 2021-03-29 | Ceiba | Puerto Rico | 72037 | 416 | |
1166230 | 1166230 | 2021-03-28 | Ceiba | Puerto Rico | 72037 | 414 | |
1162982 | 1162982 | 2021-03-27 | Ceiba | Puerto Rico | 72037 | 414 | |
1159733 | 1159733 | 2021-03-26 | Ceiba | Puerto Rico | 72037 | 413 | |
1156486 | 1156486 | 2021-03-25 | Ceiba | Puerto Rico | 72037 | 413 | |
1153239 | 1153239 | 2021-03-24 | Ceiba | Puerto Rico | 72037 | 413 | |
1149992 | 1149992 | 2021-03-23 | Ceiba | Puerto Rico | 72037 | 413 | |
1146745 | 1146745 | 2021-03-22 | Ceiba | Puerto Rico | 72037 | 413 | |
1143498 | 1143498 | 2021-03-21 | Ceiba | Puerto Rico | 72037 | 413 | |
1140251 | 1140251 | 2021-03-20 | Ceiba | Puerto Rico | 72037 | 412 | |
1137005 | 1137005 | 2021-03-19 | Ceiba | Puerto Rico | 72037 | 410 | |
1133759 | 1133759 | 2021-03-18 | Ceiba | Puerto Rico | 72037 | 410 | |
1130511 | 1130511 | 2021-03-17 | Ceiba | Puerto Rico | 72037 | 410 | |
1127264 | 1127264 | 2021-03-16 | Ceiba | Puerto Rico | 72037 | 410 | |
1124018 | 1124018 | 2021-03-15 | Ceiba | Puerto Rico | 72037 | 410 | |
1120772 | 1120772 | 2021-03-14 | Ceiba | Puerto Rico | 72037 | 410 | |
1117525 | 1117525 | 2021-03-13 | Ceiba | Puerto Rico | 72037 | 410 | |
1114278 | 1114278 | 2021-03-12 | Ceiba | Puerto Rico | 72037 | 410 | |
1111032 | 1111032 | 2021-03-11 | Ceiba | Puerto Rico | 72037 | 409 | |
1107786 | 1107786 | 2021-03-10 | Ceiba | Puerto Rico | 72037 | 409 | |
1104540 | 1104540 | 2021-03-09 | Ceiba | Puerto Rico | 72037 | 409 | |
1101294 | 1101294 | 2021-03-08 | Ceiba | Puerto Rico | 72037 | 409 | |
1098048 | 1098048 | 2021-03-07 | Ceiba | Puerto Rico | 72037 | 406 | |
1094800 | 1094800 | 2021-03-06 | Ceiba | Puerto Rico | 72037 | 406 | |
1091554 | 1091554 | 2021-03-05 | Ceiba | Puerto Rico | 72037 | 406 | |
1088308 | 1088308 | 2021-03-04 | Ceiba | Puerto Rico | 72037 | 403 | |
1085063 | 1085063 | 2021-03-03 | Ceiba | Puerto Rico | 72037 | 403 | |
1081817 | 1081817 | 2021-03-02 | Ceiba | Puerto Rico | 72037 | 403 | |
1078571 | 1078571 | 2021-03-01 | Ceiba | Puerto Rico | 72037 | 403 | |
1075326 | 1075326 | 2021-02-28 | Ceiba | Puerto Rico | 72037 | 403 | |
1072080 | 1072080 | 2021-02-27 | Ceiba | Puerto Rico | 72037 | 402 | |
1068834 | 1068834 | 2021-02-26 | Ceiba | Puerto Rico | 72037 | 402 | |
1065589 | 1065589 | 2021-02-25 | Ceiba | Puerto Rico | 72037 | 401 | |
1062344 | 1062344 | 2021-02-24 | Ceiba | Puerto Rico | 72037 | 401 | |
1059099 | 1059099 | 2021-02-23 | Ceiba | Puerto Rico | 72037 | 401 | |
1055853 | 1055853 | 2021-02-22 | Ceiba | Puerto Rico | 72037 | 401 | |
1052607 | 1052607 | 2021-02-21 | Ceiba | Puerto Rico | 72037 | 401 | |
1049360 | 1049360 | 2021-02-20 | Ceiba | Puerto Rico | 72037 | 401 | |
1046113 | 1046113 | 2021-02-19 | Ceiba | Puerto Rico | 72037 | 398 | |
1042868 | 1042868 | 2021-02-18 | Ceiba | Puerto Rico | 72037 | 397 | |
1039623 | 1039623 | 2021-02-17 | Ceiba | Puerto Rico | 72037 | 396 | |
1036378 | 1036378 | 2021-02-16 | Ceiba | Puerto Rico | 72037 | 396 | |
1033133 | 1033133 | 2021-02-15 | Ceiba | Puerto Rico | 72037 | 395 | |
1029887 | 1029887 | 2021-02-14 | Ceiba | Puerto Rico | 72037 | 395 | |
1026640 | 1026640 | 2021-02-13 | Ceiba | Puerto Rico | 72037 | 395 | |
1023395 | 1023395 | 2021-02-12 | Ceiba | Puerto Rico | 72037 | 394 | |
1020150 | 1020150 | 2021-02-11 | Ceiba | Puerto Rico | 72037 | 394 | |
1016905 | 1016905 | 2021-02-10 | Ceiba | Puerto Rico | 72037 | 394 | |
1013660 | 1013660 | 2021-02-09 | Ceiba | Puerto Rico | 72037 | 393 | |
1010415 | 1010415 | 2021-02-08 | Ceiba | Puerto Rico | 72037 | 393 | |
1007169 | 1007169 | 2021-02-07 | Ceiba | Puerto Rico | 72037 | 391 | |
1003923 | 1003923 | 2021-02-06 | Ceiba | Puerto Rico | 72037 | 389 | |
1000677 | 1000677 | 2021-02-05 | Ceiba | Puerto Rico | 72037 | 385 | |
997431 | 997431 | 2021-02-04 | Ceiba | Puerto Rico | 72037 | 385 | |
994185 | 994185 | 2021-02-03 | Ceiba | Puerto Rico | 72037 | 384 | |
990939 | 990939 | 2021-02-02 | Ceiba | Puerto Rico | 72037 | 384 | |
987693 | 987693 | 2021-02-01 | Ceiba | Puerto Rico | 72037 | 383 | |
984446 | 984446 | 2021-01-31 | Ceiba | Puerto Rico | 72037 | 379 | |
981199 | 981199 | 2021-01-30 | Ceiba | Puerto Rico | 72037 | 378 | |
977953 | 977953 | 2021-01-29 | Ceiba | Puerto Rico | 72037 | 378 | |
974708 | 974708 | 2021-01-28 | Ceiba | Puerto Rico | 72037 | 377 | |
971463 | 971463 | 2021-01-27 | Ceiba | Puerto Rico | 72037 | 376 | |
968218 | 968218 | 2021-01-26 | Ceiba | Puerto Rico | 72037 | 376 | |
964974 | 964974 | 2021-01-25 | Ceiba | Puerto Rico | 72037 | 375 | |
961729 | 961729 | 2021-01-24 | Ceiba | Puerto Rico | 72037 | 374 | |
958484 | 958484 | 2021-01-23 | Ceiba | Puerto Rico | 72037 | 371 | |
955238 | 955238 | 2021-01-22 | Ceiba | Puerto Rico | 72037 | 359 | |
951993 | 951993 | 2021-01-21 | Ceiba | Puerto Rico | 72037 | 357 | |
948748 | 948748 | 2021-01-20 | Ceiba | Puerto Rico | 72037 | 356 | |
945502 | 945502 | 2021-01-19 | Ceiba | Puerto Rico | 72037 | 355 | |
942255 | 942255 | 2021-01-18 | Ceiba | Puerto Rico | 72037 | 352 | |
939010 | 939010 | 2021-01-17 | Ceiba | Puerto Rico | 72037 | 349 | |
935765 | 935765 | 2021-01-16 | Ceiba | Puerto Rico | 72037 | 349 | |
932520 | 932520 | 2021-01-15 | Ceiba | Puerto Rico | 72037 | 348 | |
929275 | 929275 | 2021-01-14 | Ceiba | Puerto Rico | 72037 | 347 | |
926030 | 926030 | 2021-01-13 | Ceiba | Puerto Rico | 72037 | 347 | |
922784 | 922784 | 2021-01-12 | Ceiba | Puerto Rico | 72037 | 346 | |
919539 | 919539 | 2021-01-11 | Ceiba | Puerto Rico | 72037 | 339 | |
916294 | 916294 | 2021-01-10 | Ceiba | Puerto Rico | 72037 | 338 | |
913049 | 913049 | 2021-01-09 | Ceiba | Puerto Rico | 72037 | 338 | |
909804 | 909804 | 2021-01-08 | Ceiba | Puerto Rico | 72037 | 338 | |
906559 | 906559 | 2021-01-07 | Ceiba | Puerto Rico | 72037 | 334 | |
903313 | 903313 | 2021-01-06 | Ceiba | Puerto Rico | 72037 | 334 | |
900068 | 900068 | 2021-01-05 | Ceiba | Puerto Rico | 72037 | 333 | |
896823 | 896823 | 2021-01-04 | Ceiba | Puerto Rico | 72037 | 330 | |
893577 | 893577 | 2021-01-03 | Ceiba | Puerto Rico | 72037 | 330 | |
890331 | 890331 | 2021-01-02 | Ceiba | Puerto Rico | 72037 | 329 | |
887084 | 887084 | 2021-01-01 | Ceiba | Puerto Rico | 72037 | 325 | |
883839 | 883839 | 2020-12-31 | Ceiba | Puerto Rico | 72037 | 320 | |
880594 | 880594 | 2020-12-30 | Ceiba | Puerto Rico | 72037 | 319 | |
877349 | 877349 | 2020-12-29 | Ceiba | Puerto Rico | 72037 | 319 | |
874104 | 874104 | 2020-12-28 | Ceiba | Puerto Rico | 72037 | 307 |
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);