ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72127 and state = "Puerto Rico" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
117549 | 117549 | 2020-05-05 | San Juan | Puerto Rico | 72127 | 287 | |
120511 | 120511 | 2020-05-06 | San Juan | Puerto Rico | 72127 | 294 | |
123488 | 123488 | 2020-05-07 | San Juan | Puerto Rico | 72127 | 298 | |
126471 | 126471 | 2020-05-08 | San Juan | Puerto Rico | 72127 | 319 | |
129460 | 129460 | 2020-05-09 | San Juan | Puerto Rico | 72127 | 321 | |
132449 | 132449 | 2020-05-10 | San Juan | Puerto Rico | 72127 | 331 | |
135440 | 135440 | 2020-05-11 | San Juan | Puerto Rico | 72127 | 339 | |
138430 | 138430 | 2020-05-12 | San Juan | Puerto Rico | 72127 | 344 | |
141426 | 141426 | 2020-05-13 | San Juan | Puerto Rico | 72127 | 349 | |
144422 | 144422 | 2020-05-14 | San Juan | Puerto Rico | 72127 | 363 | |
147423 | 147423 | 2020-05-15 | San Juan | Puerto Rico | 72127 | 373 | |
150431 | 150431 | 2020-05-16 | San Juan | Puerto Rico | 72127 | 383 | |
153442 | 153442 | 2020-05-17 | San Juan | Puerto Rico | 72127 | 392 | |
156459 | 156459 | 2020-05-18 | San Juan | Puerto Rico | 72127 | 399 | |
159480 | 159480 | 2020-05-19 | San Juan | Puerto Rico | 72127 | 412 | |
162507 | 162507 | 2020-05-20 | San Juan | Puerto Rico | 72127 | 421 | |
165536 | 165536 | 2020-05-21 | San Juan | Puerto Rico | 72127 | 424 | |
168572 | 168572 | 2020-05-22 | San Juan | Puerto Rico | 72127 | 439 | |
171611 | 171611 | 2020-05-23 | San Juan | Puerto Rico | 72127 | 450 | |
174653 | 174653 | 2020-05-24 | San Juan | Puerto Rico | 72127 | 459 | |
177697 | 177697 | 2020-05-25 | San Juan | Puerto Rico | 72127 | 468 | |
180740 | 180740 | 2020-05-26 | San Juan | Puerto Rico | 72127 | 472 | |
183790 | 183790 | 2020-05-27 | San Juan | Puerto Rico | 72127 | 482 | |
186847 | 186847 | 2020-05-28 | San Juan | Puerto Rico | 72127 | 493 | |
189909 | 189909 | 2020-05-29 | San Juan | Puerto Rico | 72127 | 516 | |
192974 | 192974 | 2020-05-30 | San Juan | Puerto Rico | 72127 | 525 | |
196043 | 196043 | 2020-05-31 | San Juan | Puerto Rico | 72127 | 532 | |
199116 | 199116 | 2020-06-01 | San Juan | Puerto Rico | 72127 | 560 | |
202191 | 202191 | 2020-06-02 | San Juan | Puerto Rico | 72127 | 567 | |
205268 | 205268 | 2020-06-03 | San Juan | Puerto Rico | 72127 | 577 | |
208349 | 208349 | 2020-06-04 | San Juan | Puerto Rico | 72127 | 607 | |
211431 | 211431 | 2020-06-05 | San Juan | Puerto Rico | 72127 | 626 | |
214517 | 214517 | 2020-06-06 | San Juan | Puerto Rico | 72127 | 663 | |
217607 | 217607 | 2020-06-07 | San Juan | Puerto Rico | 72127 | 680 | |
220699 | 220699 | 2020-06-08 | San Juan | Puerto Rico | 72127 | 686 | |
223794 | 223794 | 2020-06-09 | San Juan | Puerto Rico | 72127 | 700 | |
226894 | 226894 | 2020-06-10 | San Juan | Puerto Rico | 72127 | 717 | |
229998 | 229998 | 2020-06-11 | San Juan | Puerto Rico | 72127 | 720 | |
233103 | 233103 | 2020-06-12 | San Juan | Puerto Rico | 72127 | 766 | |
236208 | 236208 | 2020-06-13 | San Juan | Puerto Rico | 72127 | 791 | |
239316 | 239316 | 2020-06-14 | San Juan | Puerto Rico | 72127 | 813 | |
242425 | 242425 | 2020-06-15 | San Juan | Puerto Rico | 72127 | 826 | |
245537 | 245537 | 2020-06-16 | San Juan | Puerto Rico | 72127 | 835 | |
248650 | 248650 | 2020-06-17 | San Juan | Puerto Rico | 72127 | 847 | |
251765 | 251765 | 2020-06-18 | San Juan | Puerto Rico | 72127 | 865 | |
254880 | 254880 | 2020-06-19 | San Juan | Puerto Rico | 72127 | 868 | |
258006 | 258006 | 2020-06-20 | San Juan | Puerto Rico | 72127 | 908 | |
261133 | 261133 | 2020-06-21 | San Juan | Puerto Rico | 72127 | 920 | |
264261 | 264261 | 2020-06-22 | San Juan | Puerto Rico | 72127 | 924 | |
267389 | 267389 | 2020-06-23 | San Juan | Puerto Rico | 72127 | 864 | |
270523 | 270523 | 2020-06-24 | San Juan | Puerto Rico | 72127 | 889 | |
273662 | 273662 | 2020-06-25 | San Juan | Puerto Rico | 72127 | 889 | |
276809 | 276809 | 2020-06-26 | San Juan | Puerto Rico | 72127 | 893 | |
279957 | 279957 | 2020-06-27 | San Juan | Puerto Rico | 72127 | 918 | |
283103 | 283103 | 2020-06-28 | San Juan | Puerto Rico | 72127 | 926 | |
286248 | 286248 | 2020-06-29 | San Juan | Puerto Rico | 72127 | 939 | |
289399 | 289399 | 2020-06-30 | San Juan | Puerto Rico | 72127 | 963 | |
292551 | 292551 | 2020-07-01 | San Juan | Puerto Rico | 72127 | 972 | |
295707 | 295707 | 2020-07-02 | San Juan | Puerto Rico | 72127 | 984 | |
298866 | 298866 | 2020-07-03 | San Juan | Puerto Rico | 72127 | 1002 | |
302030 | 302030 | 2020-07-04 | San Juan | Puerto Rico | 72127 | 1022 | |
305193 | 305193 | 2020-07-05 | San Juan | Puerto Rico | 72127 | 1050 | |
308360 | 308360 | 2020-07-06 | San Juan | Puerto Rico | 72127 | 1114 | |
311529 | 311529 | 2020-07-07 | San Juan | Puerto Rico | 72127 | 1122 | |
314701 | 314701 | 2020-07-08 | San Juan | Puerto Rico | 72127 | 1130 | |
317874 | 317874 | 2020-07-09 | San Juan | Puerto Rico | 72127 | 1150 | |
321052 | 321052 | 2020-07-10 | San Juan | Puerto Rico | 72127 | 1177 | |
324232 | 324232 | 2020-07-11 | San Juan | Puerto Rico | 72127 | 1207 | |
327417 | 327417 | 2020-07-12 | San Juan | Puerto Rico | 72127 | 1230 | |
330603 | 330603 | 2020-07-13 | San Juan | Puerto Rico | 72127 | 1317 | |
333795 | 333795 | 2020-07-14 | San Juan | Puerto Rico | 72127 | 1328 | |
336989 | 336989 | 2020-07-15 | San Juan | Puerto Rico | 72127 | 1358 | |
340186 | 340186 | 2020-07-16 | San Juan | Puerto Rico | 72127 | 1372 | |
343384 | 343384 | 2020-07-17 | San Juan | Puerto Rico | 72127 | 1427 | |
346584 | 346584 | 2020-07-18 | San Juan | Puerto Rico | 72127 | 1472 | |
349784 | 349784 | 2020-07-19 | San Juan | Puerto Rico | 72127 | 1569 | |
352987 | 352987 | 2020-07-20 | San Juan | Puerto Rico | 72127 | 1625 | |
356190 | 356190 | 2020-07-21 | San Juan | Puerto Rico | 72127 | 1701 | |
359394 | 359394 | 2020-07-22 | San Juan | Puerto Rico | 72127 | 1721 | |
362600 | 362600 | 2020-07-23 | San Juan | Puerto Rico | 72127 | 1801 | |
365806 | 365806 | 2020-07-24 | San Juan | Puerto Rico | 72127 | 1843 | |
369015 | 369015 | 2020-07-25 | San Juan | Puerto Rico | 72127 | 1923 | |
372227 | 372227 | 2020-07-26 | San Juan | Puerto Rico | 72127 | 2020 | |
375440 | 375440 | 2020-07-27 | San Juan | Puerto Rico | 72127 | 2062 | |
378656 | 378656 | 2020-07-28 | San Juan | Puerto Rico | 72127 | 2124 | |
381873 | 381873 | 2020-07-29 | San Juan | Puerto Rico | 72127 | 2170 | |
385091 | 385091 | 2020-07-30 | San Juan | Puerto Rico | 72127 | 2267 | |
388308 | 388308 | 2020-07-31 | San Juan | Puerto Rico | 72127 | 2291 | |
391525 | 391525 | 2020-08-01 | San Juan | Puerto Rico | 72127 | 2462 | |
394741 | 394741 | 2020-08-02 | San Juan | Puerto Rico | 72127 | 2547 | |
397958 | 397958 | 2020-08-03 | San Juan | Puerto Rico | 72127 | 2609 | |
401173 | 401173 | 2020-08-04 | San Juan | Puerto Rico | 72127 | 2752 | |
404391 | 404391 | 2020-08-05 | San Juan | Puerto Rico | 72127 | 2827 | |
407610 | 407610 | 2020-08-06 | San Juan | Puerto Rico | 72127 | 2888 | |
410830 | 410830 | 2020-08-07 | San Juan | Puerto Rico | 72127 | 3022 | |
414050 | 414050 | 2020-08-08 | San Juan | Puerto Rico | 72127 | 3133 | |
417271 | 417271 | 2020-08-09 | San Juan | Puerto Rico | 72127 | 3274 | |
420491 | 420491 | 2020-08-10 | San Juan | Puerto Rico | 72127 | 3361 | |
423714 | 423714 | 2020-08-11 | San Juan | Puerto Rico | 72127 | 3477 | |
426937 | 426937 | 2020-08-12 | San Juan | Puerto Rico | 72127 | 3657 |
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);