ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Lajas" 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 |
---|---|---|---|---|---|---|---|
1065611 | 1065611 | 2021-02-25 | Lajas | Puerto Rico | 72079 | 411 | |
1062366 | 1062366 | 2021-02-24 | Lajas | Puerto Rico | 72079 | 411 | |
1059121 | 1059121 | 2021-02-23 | Lajas | Puerto Rico | 72079 | 411 | |
1055875 | 1055875 | 2021-02-22 | Lajas | Puerto Rico | 72079 | 411 | |
1052629 | 1052629 | 2021-02-21 | Lajas | Puerto Rico | 72079 | 411 | |
1049382 | 1049382 | 2021-02-20 | Lajas | Puerto Rico | 72079 | 409 | |
1046135 | 1046135 | 2021-02-19 | Lajas | Puerto Rico | 72079 | 409 | |
1042890 | 1042890 | 2021-02-18 | Lajas | Puerto Rico | 72079 | 409 | |
1039645 | 1039645 | 2021-02-17 | Lajas | Puerto Rico | 72079 | 409 | |
1036400 | 1036400 | 2021-02-16 | Lajas | Puerto Rico | 72079 | 410 | |
1033155 | 1033155 | 2021-02-15 | Lajas | Puerto Rico | 72079 | 405 | |
1029909 | 1029909 | 2021-02-14 | Lajas | Puerto Rico | 72079 | 403 | |
1026662 | 1026662 | 2021-02-13 | Lajas | Puerto Rico | 72079 | 397 | |
1023417 | 1023417 | 2021-02-12 | Lajas | Puerto Rico | 72079 | 391 | |
1020172 | 1020172 | 2021-02-11 | Lajas | Puerto Rico | 72079 | 389 | |
1016927 | 1016927 | 2021-02-10 | Lajas | Puerto Rico | 72079 | 388 | |
1013682 | 1013682 | 2021-02-09 | Lajas | Puerto Rico | 72079 | 388 | |
1010437 | 1010437 | 2021-02-08 | Lajas | Puerto Rico | 72079 | 384 | |
1007191 | 1007191 | 2021-02-07 | Lajas | Puerto Rico | 72079 | 377 | |
1003945 | 1003945 | 2021-02-06 | Lajas | Puerto Rico | 72079 | 375 | |
1000699 | 1000699 | 2021-02-05 | Lajas | Puerto Rico | 72079 | 370 | |
997453 | 997453 | 2021-02-04 | Lajas | Puerto Rico | 72079 | 370 | |
994207 | 994207 | 2021-02-03 | Lajas | Puerto Rico | 72079 | 369 | |
990961 | 990961 | 2021-02-02 | Lajas | Puerto Rico | 72079 | 369 | |
987715 | 987715 | 2021-02-01 | Lajas | Puerto Rico | 72079 | 369 | |
984468 | 984468 | 2021-01-31 | Lajas | Puerto Rico | 72079 | 366 | |
981221 | 981221 | 2021-01-30 | Lajas | Puerto Rico | 72079 | 365 | |
977975 | 977975 | 2021-01-29 | Lajas | Puerto Rico | 72079 | 362 | |
974730 | 974730 | 2021-01-28 | Lajas | Puerto Rico | 72079 | 362 | |
971485 | 971485 | 2021-01-27 | Lajas | Puerto Rico | 72079 | 361 | |
968240 | 968240 | 2021-01-26 | Lajas | Puerto Rico | 72079 | 361 | |
964996 | 964996 | 2021-01-25 | Lajas | Puerto Rico | 72079 | 360 | |
961751 | 961751 | 2021-01-24 | Lajas | Puerto Rico | 72079 | 358 | |
958506 | 958506 | 2021-01-23 | Lajas | Puerto Rico | 72079 | 354 | |
955260 | 955260 | 2021-01-22 | Lajas | Puerto Rico | 72079 | 353 | |
952015 | 952015 | 2021-01-21 | Lajas | Puerto Rico | 72079 | 350 | |
948770 | 948770 | 2021-01-20 | Lajas | Puerto Rico | 72079 | 349 | |
945524 | 945524 | 2021-01-19 | Lajas | Puerto Rico | 72079 | 349 | |
942277 | 942277 | 2021-01-18 | Lajas | Puerto Rico | 72079 | 348 | |
939032 | 939032 | 2021-01-17 | Lajas | Puerto Rico | 72079 | 345 | |
935787 | 935787 | 2021-01-16 | Lajas | Puerto Rico | 72079 | 341 | |
932542 | 932542 | 2021-01-15 | Lajas | Puerto Rico | 72079 | 340 | |
929297 | 929297 | 2021-01-14 | Lajas | Puerto Rico | 72079 | 335 | |
926052 | 926052 | 2021-01-13 | Lajas | Puerto Rico | 72079 | 335 | |
922806 | 922806 | 2021-01-12 | Lajas | Puerto Rico | 72079 | 335 | |
919561 | 919561 | 2021-01-11 | Lajas | Puerto Rico | 72079 | 334 | |
916316 | 916316 | 2021-01-10 | Lajas | Puerto Rico | 72079 | 333 | |
913071 | 913071 | 2021-01-09 | Lajas | Puerto Rico | 72079 | 333 | |
909826 | 909826 | 2021-01-08 | Lajas | Puerto Rico | 72079 | 333 | |
906581 | 906581 | 2021-01-07 | Lajas | Puerto Rico | 72079 | 330 | |
903335 | 903335 | 2021-01-06 | Lajas | Puerto Rico | 72079 | 329 | |
900090 | 900090 | 2021-01-05 | Lajas | Puerto Rico | 72079 | 329 | |
896845 | 896845 | 2021-01-04 | Lajas | Puerto Rico | 72079 | 329 | |
893599 | 893599 | 2021-01-03 | Lajas | Puerto Rico | 72079 | 328 | |
890353 | 890353 | 2021-01-02 | Lajas | Puerto Rico | 72079 | 328 | |
887106 | 887106 | 2021-01-01 | Lajas | Puerto Rico | 72079 | 327 | |
883861 | 883861 | 2020-12-31 | Lajas | Puerto Rico | 72079 | 324 | |
880616 | 880616 | 2020-12-30 | Lajas | Puerto Rico | 72079 | 323 | |
877371 | 877371 | 2020-12-29 | Lajas | Puerto Rico | 72079 | 323 | |
874126 | 874126 | 2020-12-28 | Lajas | Puerto Rico | 72079 | 306 | |
870881 | 870881 | 2020-12-27 | Lajas | Puerto Rico | 72079 | 305 | |
867636 | 867636 | 2020-12-26 | Lajas | Puerto Rico | 72079 | 301 | |
864391 | 864391 | 2020-12-25 | Lajas | Puerto Rico | 72079 | 300 | |
861146 | 861146 | 2020-12-24 | Lajas | Puerto Rico | 72079 | 300 | |
857901 | 857901 | 2020-12-23 | Lajas | Puerto Rico | 72079 | 296 | |
854656 | 854656 | 2020-12-22 | Lajas | Puerto Rico | 72079 | 295 | |
851411 | 851411 | 2020-12-21 | Lajas | Puerto Rico | 72079 | 295 | |
848166 | 848166 | 2020-12-20 | Lajas | Puerto Rico | 72079 | 294 | |
844921 | 844921 | 2020-12-19 | Lajas | Puerto Rico | 72079 | 291 | |
841675 | 841675 | 2020-12-18 | Lajas | Puerto Rico | 72079 | 286 | |
838430 | 838430 | 2020-12-17 | Lajas | Puerto Rico | 72079 | 284 | |
835184 | 835184 | 2020-12-16 | Lajas | Puerto Rico | 72079 | 276 | |
831938 | 831938 | 2020-12-15 | Lajas | Puerto Rico | 72079 | 276 | |
828691 | 828691 | 2020-12-14 | Lajas | Puerto Rico | 72079 | 276 | |
825445 | 825445 | 2020-12-13 | Lajas | Puerto Rico | 72079 | 276 | |
822198 | 822198 | 2020-12-12 | Lajas | Puerto Rico | 72079 | 275 | |
818952 | 818952 | 2020-12-11 | Lajas | Puerto Rico | 72079 | 275 | |
815706 | 815706 | 2020-12-10 | Lajas | Puerto Rico | 72079 | 274 | |
812460 | 812460 | 2020-12-09 | Lajas | Puerto Rico | 72079 | 274 | |
809216 | 809216 | 2020-12-08 | Lajas | Puerto Rico | 72079 | 274 | |
805971 | 805971 | 2020-12-07 | Lajas | Puerto Rico | 72079 | 273 | |
802726 | 802726 | 2020-12-06 | Lajas | Puerto Rico | 72079 | 266 | |
799481 | 799481 | 2020-12-05 | Lajas | Puerto Rico | 72079 | 265 | |
796236 | 796236 | 2020-12-04 | Lajas | Puerto Rico | 72079 | 264 | |
792991 | 792991 | 2020-12-03 | Lajas | Puerto Rico | 72079 | 263 | |
789746 | 789746 | 2020-12-02 | Lajas | Puerto Rico | 72079 | 262 | |
786501 | 786501 | 2020-12-01 | Lajas | Puerto Rico | 72079 | 261 | |
783257 | 783257 | 2020-11-30 | Lajas | Puerto Rico | 72079 | 260 | |
780012 | 780012 | 2020-11-29 | Lajas | Puerto Rico | 72079 | 259 | |
776766 | 776766 | 2020-11-28 | Lajas | Puerto Rico | 72079 | 259 | |
773521 | 773521 | 2020-11-27 | Lajas | Puerto Rico | 72079 | 258 | |
770276 | 770276 | 2020-11-26 | Lajas | Puerto Rico | 72079 | 258 | |
767030 | 767030 | 2020-11-25 | Lajas | Puerto Rico | 72079 | 254 | |
763785 | 763785 | 2020-11-24 | Lajas | Puerto Rico | 72079 | 254 | |
760540 | 760540 | 2020-11-23 | Lajas | Puerto Rico | 72079 | 254 | |
757295 | 757295 | 2020-11-22 | Lajas | Puerto Rico | 72079 | 251 | |
754048 | 754048 | 2020-11-21 | Lajas | Puerto Rico | 72079 | 249 | |
750802 | 750802 | 2020-11-20 | Lajas | Puerto Rico | 72079 | 248 | |
747556 | 747556 | 2020-11-19 | Lajas | Puerto Rico | 72079 | 245 | |
744310 | 744310 | 2020-11-18 | Lajas | Puerto Rico | 72079 | 243 |
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);