ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72025 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 |
---|---|---|---|---|---|---|---|
1195451 | 1195451 | 2021-04-06 | Caguas | Puerto Rico | 72025 | 6085 | |
1192203 | 1192203 | 2021-04-05 | Caguas | Puerto Rico | 72025 | 6076 | |
1188954 | 1188954 | 2021-04-04 | Caguas | Puerto Rico | 72025 | 6052 | |
1185707 | 1185707 | 2021-04-03 | Caguas | Puerto Rico | 72025 | 6024 | |
1182460 | 1182460 | 2021-04-02 | Caguas | Puerto Rico | 72025 | 6004 | |
1179213 | 1179213 | 2021-04-01 | Caguas | Puerto Rico | 72025 | 5985 | |
1175966 | 1175966 | 2021-03-31 | Caguas | Puerto Rico | 72025 | 5974 | |
1172719 | 1172719 | 2021-03-30 | Caguas | Puerto Rico | 72025 | 5962 | |
1169472 | 1169472 | 2021-03-29 | Caguas | Puerto Rico | 72025 | 5950 | |
1166224 | 1166224 | 2021-03-28 | Caguas | Puerto Rico | 72025 | 5920 | |
1162976 | 1162976 | 2021-03-27 | Caguas | Puerto Rico | 72025 | 5902 | |
1159727 | 1159727 | 2021-03-26 | Caguas | Puerto Rico | 72025 | 5884 | |
1156480 | 1156480 | 2021-03-25 | Caguas | Puerto Rico | 72025 | 5873 | |
1153233 | 1153233 | 2021-03-24 | Caguas | Puerto Rico | 72025 | 5871 | |
1149986 | 1149986 | 2021-03-23 | Caguas | Puerto Rico | 72025 | 5868 | |
1146739 | 1146739 | 2021-03-22 | Caguas | Puerto Rico | 72025 | 5854 | |
1143492 | 1143492 | 2021-03-21 | Caguas | Puerto Rico | 72025 | 5841 | |
1140245 | 1140245 | 2021-03-20 | Caguas | Puerto Rico | 72025 | 5829 | |
1136999 | 1136999 | 2021-03-19 | Caguas | Puerto Rico | 72025 | 5821 | |
1133753 | 1133753 | 2021-03-18 | Caguas | Puerto Rico | 72025 | 5807 | |
1130505 | 1130505 | 2021-03-17 | Caguas | Puerto Rico | 72025 | 5806 | |
1127258 | 1127258 | 2021-03-16 | Caguas | Puerto Rico | 72025 | 5799 | |
1124012 | 1124012 | 2021-03-15 | Caguas | Puerto Rico | 72025 | 5794 | |
1120766 | 1120766 | 2021-03-14 | Caguas | Puerto Rico | 72025 | 5791 | |
1117519 | 1117519 | 2021-03-13 | Caguas | Puerto Rico | 72025 | 5784 | |
1114272 | 1114272 | 2021-03-12 | Caguas | Puerto Rico | 72025 | 5776 | |
1111026 | 1111026 | 2021-03-11 | Caguas | Puerto Rico | 72025 | 5768 | |
1107780 | 1107780 | 2021-03-10 | Caguas | Puerto Rico | 72025 | 5756 | |
1104534 | 1104534 | 2021-03-09 | Caguas | Puerto Rico | 72025 | 5756 | |
1101288 | 1101288 | 2021-03-08 | Caguas | Puerto Rico | 72025 | 5751 | |
1098042 | 1098042 | 2021-03-07 | Caguas | Puerto Rico | 72025 | 5681 | |
1094794 | 1094794 | 2021-03-06 | Caguas | Puerto Rico | 72025 | 5681 | |
1091548 | 1091548 | 2021-03-05 | Caguas | Puerto Rico | 72025 | 5672 | |
1088302 | 1088302 | 2021-03-04 | Caguas | Puerto Rico | 72025 | 5671 | |
1085057 | 1085057 | 2021-03-03 | Caguas | Puerto Rico | 72025 | 5666 | |
1081811 | 1081811 | 2021-03-02 | Caguas | Puerto Rico | 72025 | 5666 | |
1078565 | 1078565 | 2021-03-01 | Caguas | Puerto Rico | 72025 | 5654 | |
1075320 | 1075320 | 2021-02-28 | Caguas | Puerto Rico | 72025 | 5641 | |
1072074 | 1072074 | 2021-02-27 | Caguas | Puerto Rico | 72025 | 5625 | |
1068828 | 1068828 | 2021-02-26 | Caguas | Puerto Rico | 72025 | 5614 | |
1065583 | 1065583 | 2021-02-25 | Caguas | Puerto Rico | 72025 | 5602 | |
1062338 | 1062338 | 2021-02-24 | Caguas | Puerto Rico | 72025 | 5596 | |
1059093 | 1059093 | 2021-02-23 | Caguas | Puerto Rico | 72025 | 5592 | |
1055847 | 1055847 | 2021-02-22 | Caguas | Puerto Rico | 72025 | 5575 | |
1052601 | 1052601 | 2021-02-21 | Caguas | Puerto Rico | 72025 | 5564 | |
1049354 | 1049354 | 2021-02-20 | Caguas | Puerto Rico | 72025 | 5555 | |
1046107 | 1046107 | 2021-02-19 | Caguas | Puerto Rico | 72025 | 5543 | |
1042862 | 1042862 | 2021-02-18 | Caguas | Puerto Rico | 72025 | 5537 | |
1039617 | 1039617 | 2021-02-17 | Caguas | Puerto Rico | 72025 | 5537 | |
1036372 | 1036372 | 2021-02-16 | Caguas | Puerto Rico | 72025 | 5531 | |
1033127 | 1033127 | 2021-02-15 | Caguas | Puerto Rico | 72025 | 5514 | |
1029881 | 1029881 | 2021-02-14 | Caguas | Puerto Rico | 72025 | 5506 | |
1026634 | 1026634 | 2021-02-13 | Caguas | Puerto Rico | 72025 | 5488 | |
1023389 | 1023389 | 2021-02-12 | Caguas | Puerto Rico | 72025 | 5474 | |
1020144 | 1020144 | 2021-02-11 | Caguas | Puerto Rico | 72025 | 5455 | |
1016899 | 1016899 | 2021-02-10 | Caguas | Puerto Rico | 72025 | 5450 | |
1013654 | 1013654 | 2021-02-09 | Caguas | Puerto Rico | 72025 | 5444 | |
1010409 | 1010409 | 2021-02-08 | Caguas | Puerto Rico | 72025 | 5435 | |
1007163 | 1007163 | 2021-02-07 | Caguas | Puerto Rico | 72025 | 5416 | |
1003917 | 1003917 | 2021-02-06 | Caguas | Puerto Rico | 72025 | 5389 | |
1000671 | 1000671 | 2021-02-05 | Caguas | Puerto Rico | 72025 | 5373 | |
997425 | 997425 | 2021-02-04 | Caguas | Puerto Rico | 72025 | 5369 | |
994179 | 994179 | 2021-02-03 | Caguas | Puerto Rico | 72025 | 5358 | |
990933 | 990933 | 2021-02-02 | Caguas | Puerto Rico | 72025 | 5344 | |
987687 | 987687 | 2021-02-01 | Caguas | Puerto Rico | 72025 | 5325 | |
984440 | 984440 | 2021-01-31 | Caguas | Puerto Rico | 72025 | 5289 | |
981193 | 981193 | 2021-01-30 | Caguas | Puerto Rico | 72025 | 5286 | |
977947 | 977947 | 2021-01-29 | Caguas | Puerto Rico | 72025 | 5259 | |
974702 | 974702 | 2021-01-28 | Caguas | Puerto Rico | 72025 | 5244 | |
971457 | 971457 | 2021-01-27 | Caguas | Puerto Rico | 72025 | 5240 | |
968212 | 968212 | 2021-01-26 | Caguas | Puerto Rico | 72025 | 5231 | |
964968 | 964968 | 2021-01-25 | Caguas | Puerto Rico | 72025 | 5213 | |
961723 | 961723 | 2021-01-24 | Caguas | Puerto Rico | 72025 | 5187 | |
958478 | 958478 | 2021-01-23 | Caguas | Puerto Rico | 72025 | 5148 | |
955232 | 955232 | 2021-01-22 | Caguas | Puerto Rico | 72025 | 5106 | |
951987 | 951987 | 2021-01-21 | Caguas | Puerto Rico | 72025 | 5098 | |
948742 | 948742 | 2021-01-20 | Caguas | Puerto Rico | 72025 | 5085 | |
945496 | 945496 | 2021-01-19 | Caguas | Puerto Rico | 72025 | 5077 | |
942249 | 942249 | 2021-01-18 | Caguas | Puerto Rico | 72025 | 5056 | |
939004 | 939004 | 2021-01-17 | Caguas | Puerto Rico | 72025 | 5032 | |
935759 | 935759 | 2021-01-16 | Caguas | Puerto Rico | 72025 | 4973 | |
932514 | 932514 | 2021-01-15 | Caguas | Puerto Rico | 72025 | 4935 | |
929269 | 929269 | 2021-01-14 | Caguas | Puerto Rico | 72025 | 4889 | |
926024 | 926024 | 2021-01-13 | Caguas | Puerto Rico | 72025 | 4881 | |
922778 | 922778 | 2021-01-12 | Caguas | Puerto Rico | 72025 | 4865 | |
919533 | 919533 | 2021-01-11 | Caguas | Puerto Rico | 72025 | 4828 | |
916288 | 916288 | 2021-01-10 | Caguas | Puerto Rico | 72025 | 4811 | |
913043 | 913043 | 2021-01-09 | Caguas | Puerto Rico | 72025 | 4797 | |
909798 | 909798 | 2021-01-08 | Caguas | Puerto Rico | 72025 | 4767 | |
906553 | 906553 | 2021-01-07 | Caguas | Puerto Rico | 72025 | 4705 | |
903307 | 903307 | 2021-01-06 | Caguas | Puerto Rico | 72025 | 4693 | |
900062 | 900062 | 2021-01-05 | Caguas | Puerto Rico | 72025 | 4682 | |
896817 | 896817 | 2021-01-04 | Caguas | Puerto Rico | 72025 | 4662 | |
893571 | 893571 | 2021-01-03 | Caguas | Puerto Rico | 72025 | 4616 | |
890325 | 890325 | 2021-01-02 | Caguas | Puerto Rico | 72025 | 4608 | |
887078 | 887078 | 2021-01-01 | Caguas | Puerto Rico | 72025 | 4554 | |
883833 | 883833 | 2020-12-31 | Caguas | Puerto Rico | 72025 | 4504 | |
880588 | 880588 | 2020-12-30 | Caguas | Puerto Rico | 72025 | 4483 | |
877343 | 877343 | 2020-12-29 | Caguas | Puerto Rico | 72025 | 4477 | |
874098 | 874098 | 2020-12-28 | Caguas | Puerto Rico | 72025 | 4353 |
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);