ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Guayanilla" 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 |
---|---|---|---|---|---|---|---|
1065601 | 1065601 | 2021-02-25 | Guayanilla | Puerto Rico | 72059 | 428 | |
1062356 | 1062356 | 2021-02-24 | Guayanilla | Puerto Rico | 72059 | 428 | |
1059111 | 1059111 | 2021-02-23 | Guayanilla | Puerto Rico | 72059 | 427 | |
1055865 | 1055865 | 2021-02-22 | Guayanilla | Puerto Rico | 72059 | 427 | |
1052619 | 1052619 | 2021-02-21 | Guayanilla | Puerto Rico | 72059 | 427 | |
1049372 | 1049372 | 2021-02-20 | Guayanilla | Puerto Rico | 72059 | 425 | |
1046125 | 1046125 | 2021-02-19 | Guayanilla | Puerto Rico | 72059 | 424 | |
1042880 | 1042880 | 2021-02-18 | Guayanilla | Puerto Rico | 72059 | 424 | |
1039635 | 1039635 | 2021-02-17 | Guayanilla | Puerto Rico | 72059 | 424 | |
1036390 | 1036390 | 2021-02-16 | Guayanilla | Puerto Rico | 72059 | 423 | |
1033145 | 1033145 | 2021-02-15 | Guayanilla | Puerto Rico | 72059 | 421 | |
1029899 | 1029899 | 2021-02-14 | Guayanilla | Puerto Rico | 72059 | 420 | |
1026652 | 1026652 | 2021-02-13 | Guayanilla | Puerto Rico | 72059 | 420 | |
1023407 | 1023407 | 2021-02-12 | Guayanilla | Puerto Rico | 72059 | 415 | |
1020162 | 1020162 | 2021-02-11 | Guayanilla | Puerto Rico | 72059 | 414 | |
1016917 | 1016917 | 2021-02-10 | Guayanilla | Puerto Rico | 72059 | 413 | |
1013672 | 1013672 | 2021-02-09 | Guayanilla | Puerto Rico | 72059 | 413 | |
1010427 | 1010427 | 2021-02-08 | Guayanilla | Puerto Rico | 72059 | 413 | |
1007181 | 1007181 | 2021-02-07 | Guayanilla | Puerto Rico | 72059 | 413 | |
1003935 | 1003935 | 2021-02-06 | Guayanilla | Puerto Rico | 72059 | 413 | |
1000689 | 1000689 | 2021-02-05 | Guayanilla | Puerto Rico | 72059 | 408 | |
997443 | 997443 | 2021-02-04 | Guayanilla | Puerto Rico | 72059 | 408 | |
994197 | 994197 | 2021-02-03 | Guayanilla | Puerto Rico | 72059 | 406 | |
990951 | 990951 | 2021-02-02 | Guayanilla | Puerto Rico | 72059 | 406 | |
987705 | 987705 | 2021-02-01 | Guayanilla | Puerto Rico | 72059 | 403 | |
984458 | 984458 | 2021-01-31 | Guayanilla | Puerto Rico | 72059 | 398 | |
981211 | 981211 | 2021-01-30 | Guayanilla | Puerto Rico | 72059 | 398 | |
977965 | 977965 | 2021-01-29 | Guayanilla | Puerto Rico | 72059 | 395 | |
974720 | 974720 | 2021-01-28 | Guayanilla | Puerto Rico | 72059 | 394 | |
971475 | 971475 | 2021-01-27 | Guayanilla | Puerto Rico | 72059 | 393 | |
968230 | 968230 | 2021-01-26 | Guayanilla | Puerto Rico | 72059 | 393 | |
964986 | 964986 | 2021-01-25 | Guayanilla | Puerto Rico | 72059 | 392 | |
961741 | 961741 | 2021-01-24 | Guayanilla | Puerto Rico | 72059 | 390 | |
958496 | 958496 | 2021-01-23 | Guayanilla | Puerto Rico | 72059 | 386 | |
955250 | 955250 | 2021-01-22 | Guayanilla | Puerto Rico | 72059 | 385 | |
952005 | 952005 | 2021-01-21 | Guayanilla | Puerto Rico | 72059 | 381 | |
948760 | 948760 | 2021-01-20 | Guayanilla | Puerto Rico | 72059 | 380 | |
945514 | 945514 | 2021-01-19 | Guayanilla | Puerto Rico | 72059 | 380 | |
942267 | 942267 | 2021-01-18 | Guayanilla | Puerto Rico | 72059 | 378 | |
939022 | 939022 | 2021-01-17 | Guayanilla | Puerto Rico | 72059 | 377 | |
935777 | 935777 | 2021-01-16 | Guayanilla | Puerto Rico | 72059 | 376 | |
932532 | 932532 | 2021-01-15 | Guayanilla | Puerto Rico | 72059 | 374 | |
929287 | 929287 | 2021-01-14 | Guayanilla | Puerto Rico | 72059 | 366 | |
926042 | 926042 | 2021-01-13 | Guayanilla | Puerto Rico | 72059 | 364 | |
922796 | 922796 | 2021-01-12 | Guayanilla | Puerto Rico | 72059 | 364 | |
919551 | 919551 | 2021-01-11 | Guayanilla | Puerto Rico | 72059 | 360 | |
916306 | 916306 | 2021-01-10 | Guayanilla | Puerto Rico | 72059 | 358 | |
913061 | 913061 | 2021-01-09 | Guayanilla | Puerto Rico | 72059 | 358 | |
909816 | 909816 | 2021-01-08 | Guayanilla | Puerto Rico | 72059 | 358 | |
906571 | 906571 | 2021-01-07 | Guayanilla | Puerto Rico | 72059 | 358 | |
903325 | 903325 | 2021-01-06 | Guayanilla | Puerto Rico | 72059 | 356 | |
900080 | 900080 | 2021-01-05 | Guayanilla | Puerto Rico | 72059 | 355 | |
896835 | 896835 | 2021-01-04 | Guayanilla | Puerto Rico | 72059 | 353 | |
893589 | 893589 | 2021-01-03 | Guayanilla | Puerto Rico | 72059 | 352 | |
890343 | 890343 | 2021-01-02 | Guayanilla | Puerto Rico | 72059 | 352 | |
887096 | 887096 | 2021-01-01 | Guayanilla | Puerto Rico | 72059 | 350 | |
883851 | 883851 | 2020-12-31 | Guayanilla | Puerto Rico | 72059 | 349 | |
880606 | 880606 | 2020-12-30 | Guayanilla | Puerto Rico | 72059 | 349 | |
877361 | 877361 | 2020-12-29 | Guayanilla | Puerto Rico | 72059 | 348 | |
874116 | 874116 | 2020-12-28 | Guayanilla | Puerto Rico | 72059 | 346 | |
870871 | 870871 | 2020-12-27 | Guayanilla | Puerto Rico | 72059 | 345 | |
867626 | 867626 | 2020-12-26 | Guayanilla | Puerto Rico | 72059 | 345 | |
864381 | 864381 | 2020-12-25 | Guayanilla | Puerto Rico | 72059 | 344 | |
861136 | 861136 | 2020-12-24 | Guayanilla | Puerto Rico | 72059 | 344 | |
857891 | 857891 | 2020-12-23 | Guayanilla | Puerto Rico | 72059 | 343 | |
854646 | 854646 | 2020-12-22 | Guayanilla | Puerto Rico | 72059 | 343 | |
851401 | 851401 | 2020-12-21 | Guayanilla | Puerto Rico | 72059 | 342 | |
848156 | 848156 | 2020-12-20 | Guayanilla | Puerto Rico | 72059 | 342 | |
844911 | 844911 | 2020-12-19 | Guayanilla | Puerto Rico | 72059 | 341 | |
841665 | 841665 | 2020-12-18 | Guayanilla | Puerto Rico | 72059 | 339 | |
838420 | 838420 | 2020-12-17 | Guayanilla | Puerto Rico | 72059 | 340 | |
835174 | 835174 | 2020-12-16 | Guayanilla | Puerto Rico | 72059 | 336 | |
831928 | 831928 | 2020-12-15 | Guayanilla | Puerto Rico | 72059 | 336 | |
828681 | 828681 | 2020-12-14 | Guayanilla | Puerto Rico | 72059 | 336 | |
825435 | 825435 | 2020-12-13 | Guayanilla | Puerto Rico | 72059 | 335 | |
822188 | 822188 | 2020-12-12 | Guayanilla | Puerto Rico | 72059 | 332 | |
818942 | 818942 | 2020-12-11 | Guayanilla | Puerto Rico | 72059 | 331 | |
815696 | 815696 | 2020-12-10 | Guayanilla | Puerto Rico | 72059 | 329 | |
812450 | 812450 | 2020-12-09 | Guayanilla | Puerto Rico | 72059 | 328 | |
809206 | 809206 | 2020-12-08 | Guayanilla | Puerto Rico | 72059 | 328 | |
805961 | 805961 | 2020-12-07 | Guayanilla | Puerto Rico | 72059 | 325 | |
802716 | 802716 | 2020-12-06 | Guayanilla | Puerto Rico | 72059 | 325 | |
799471 | 799471 | 2020-12-05 | Guayanilla | Puerto Rico | 72059 | 322 | |
796226 | 796226 | 2020-12-04 | Guayanilla | Puerto Rico | 72059 | 320 | |
792981 | 792981 | 2020-12-03 | Guayanilla | Puerto Rico | 72059 | 318 | |
789736 | 789736 | 2020-12-02 | Guayanilla | Puerto Rico | 72059 | 318 | |
786491 | 786491 | 2020-12-01 | Guayanilla | Puerto Rico | 72059 | 318 | |
783247 | 783247 | 2020-11-30 | Guayanilla | Puerto Rico | 72059 | 316 | |
780002 | 780002 | 2020-11-29 | Guayanilla | Puerto Rico | 72059 | 314 | |
776756 | 776756 | 2020-11-28 | Guayanilla | Puerto Rico | 72059 | 314 | |
773511 | 773511 | 2020-11-27 | Guayanilla | Puerto Rico | 72059 | 307 | |
770266 | 770266 | 2020-11-26 | Guayanilla | Puerto Rico | 72059 | 302 | |
767020 | 767020 | 2020-11-25 | Guayanilla | Puerto Rico | 72059 | 300 | |
763775 | 763775 | 2020-11-24 | Guayanilla | Puerto Rico | 72059 | 300 | |
760530 | 760530 | 2020-11-23 | Guayanilla | Puerto Rico | 72059 | 298 | |
757285 | 757285 | 2020-11-22 | Guayanilla | Puerto Rico | 72059 | 296 | |
754038 | 754038 | 2020-11-21 | Guayanilla | Puerto Rico | 72059 | 294 | |
750792 | 750792 | 2020-11-20 | Guayanilla | Puerto Rico | 72059 | 293 | |
747546 | 747546 | 2020-11-19 | Guayanilla | Puerto Rico | 72059 | 291 | |
744300 | 744300 | 2020-11-18 | Guayanilla | Puerto Rico | 72059 | 290 |
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);