ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72073 and state = "Puerto Rico" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
117523 | 117523 | 2020-05-05 | Jayuya | Puerto Rico | 72073 | 2 | |
120485 | 120485 | 2020-05-06 | Jayuya | Puerto Rico | 72073 | 2 | |
123462 | 123462 | 2020-05-07 | Jayuya | Puerto Rico | 72073 | 2 | |
126445 | 126445 | 2020-05-08 | Jayuya | Puerto Rico | 72073 | 2 | |
129434 | 129434 | 2020-05-09 | Jayuya | Puerto Rico | 72073 | 2 | |
132423 | 132423 | 2020-05-10 | Jayuya | Puerto Rico | 72073 | 2 | |
135414 | 135414 | 2020-05-11 | Jayuya | Puerto Rico | 72073 | 2 | |
138404 | 138404 | 2020-05-12 | Jayuya | Puerto Rico | 72073 | 2 | |
141400 | 141400 | 2020-05-13 | Jayuya | Puerto Rico | 72073 | 2 | |
144396 | 144396 | 2020-05-14 | Jayuya | Puerto Rico | 72073 | 2 | |
147397 | 147397 | 2020-05-15 | Jayuya | Puerto Rico | 72073 | 2 | |
150404 | 150404 | 2020-05-16 | Jayuya | Puerto Rico | 72073 | 2 | |
153415 | 153415 | 2020-05-17 | Jayuya | Puerto Rico | 72073 | 2 | |
156432 | 156432 | 2020-05-18 | Jayuya | Puerto Rico | 72073 | 2 | |
159453 | 159453 | 2020-05-19 | Jayuya | Puerto Rico | 72073 | 2 | |
162480 | 162480 | 2020-05-20 | Jayuya | Puerto Rico | 72073 | 2 | |
165509 | 165509 | 2020-05-21 | Jayuya | Puerto Rico | 72073 | 2 | |
168545 | 168545 | 2020-05-22 | Jayuya | Puerto Rico | 72073 | 5 | |
171584 | 171584 | 2020-05-23 | Jayuya | Puerto Rico | 72073 | 6 | |
174626 | 174626 | 2020-05-24 | Jayuya | Puerto Rico | 72073 | 6 | |
177670 | 177670 | 2020-05-25 | Jayuya | Puerto Rico | 72073 | 6 | |
180713 | 180713 | 2020-05-26 | Jayuya | Puerto Rico | 72073 | 6 | |
183763 | 183763 | 2020-05-27 | Jayuya | Puerto Rico | 72073 | 6 | |
186820 | 186820 | 2020-05-28 | Jayuya | Puerto Rico | 72073 | 7 | |
189882 | 189882 | 2020-05-29 | Jayuya | Puerto Rico | 72073 | 7 | |
192947 | 192947 | 2020-05-30 | Jayuya | Puerto Rico | 72073 | 8 | |
196016 | 196016 | 2020-05-31 | Jayuya | Puerto Rico | 72073 | 9 | |
199089 | 199089 | 2020-06-01 | Jayuya | Puerto Rico | 72073 | 9 | |
202164 | 202164 | 2020-06-02 | Jayuya | Puerto Rico | 72073 | 10 | |
205241 | 205241 | 2020-06-03 | Jayuya | Puerto Rico | 72073 | 10 | |
208322 | 208322 | 2020-06-04 | Jayuya | Puerto Rico | 72073 | 11 | |
211404 | 211404 | 2020-06-05 | Jayuya | Puerto Rico | 72073 | 11 | |
214490 | 214490 | 2020-06-06 | Jayuya | Puerto Rico | 72073 | 11 | |
217580 | 217580 | 2020-06-07 | Jayuya | Puerto Rico | 72073 | 11 | |
220672 | 220672 | 2020-06-08 | Jayuya | Puerto Rico | 72073 | 11 | |
223767 | 223767 | 2020-06-09 | Jayuya | Puerto Rico | 72073 | 12 | |
226867 | 226867 | 2020-06-10 | Jayuya | Puerto Rico | 72073 | 14 | |
229971 | 229971 | 2020-06-11 | Jayuya | Puerto Rico | 72073 | 15 | |
233076 | 233076 | 2020-06-12 | Jayuya | Puerto Rico | 72073 | 15 | |
236181 | 236181 | 2020-06-13 | Jayuya | Puerto Rico | 72073 | 17 | |
239289 | 239289 | 2020-06-14 | Jayuya | Puerto Rico | 72073 | 17 | |
242398 | 242398 | 2020-06-15 | Jayuya | Puerto Rico | 72073 | 17 | |
245510 | 245510 | 2020-06-16 | Jayuya | Puerto Rico | 72073 | 21 | |
248623 | 248623 | 2020-06-17 | Jayuya | Puerto Rico | 72073 | 21 | |
251738 | 251738 | 2020-06-18 | Jayuya | Puerto Rico | 72073 | 26 | |
254853 | 254853 | 2020-06-19 | Jayuya | Puerto Rico | 72073 | 26 | |
257979 | 257979 | 2020-06-20 | Jayuya | Puerto Rico | 72073 | 34 | |
261106 | 261106 | 2020-06-21 | Jayuya | Puerto Rico | 72073 | 41 | |
264234 | 264234 | 2020-06-22 | Jayuya | Puerto Rico | 72073 | 41 | |
267362 | 267362 | 2020-06-23 | Jayuya | Puerto Rico | 72073 | 56 | |
270496 | 270496 | 2020-06-24 | Jayuya | Puerto Rico | 72073 | 62 | |
273635 | 273635 | 2020-06-25 | Jayuya | Puerto Rico | 72073 | 66 | |
276782 | 276782 | 2020-06-26 | Jayuya | Puerto Rico | 72073 | 70 | |
279930 | 279930 | 2020-06-27 | Jayuya | Puerto Rico | 72073 | 71 | |
283076 | 283076 | 2020-06-28 | Jayuya | Puerto Rico | 72073 | 73 | |
286221 | 286221 | 2020-06-29 | Jayuya | Puerto Rico | 72073 | 72 | |
289372 | 289372 | 2020-06-30 | Jayuya | Puerto Rico | 72073 | 72 | |
292524 | 292524 | 2020-07-01 | Jayuya | Puerto Rico | 72073 | 73 | |
295680 | 295680 | 2020-07-02 | Jayuya | Puerto Rico | 72073 | 129 | |
298839 | 298839 | 2020-07-03 | Jayuya | Puerto Rico | 72073 | 146 | |
302003 | 302003 | 2020-07-04 | Jayuya | Puerto Rico | 72073 | 146 | |
305166 | 305166 | 2020-07-05 | Jayuya | Puerto Rico | 72073 | 147 | |
308333 | 308333 | 2020-07-06 | Jayuya | Puerto Rico | 72073 | 153 | |
311502 | 311502 | 2020-07-07 | Jayuya | Puerto Rico | 72073 | 153 | |
314674 | 314674 | 2020-07-08 | Jayuya | Puerto Rico | 72073 | 153 | |
317847 | 317847 | 2020-07-09 | Jayuya | Puerto Rico | 72073 | 153 | |
321025 | 321025 | 2020-07-10 | Jayuya | Puerto Rico | 72073 | 154 | |
324205 | 324205 | 2020-07-11 | Jayuya | Puerto Rico | 72073 | 154 | |
327390 | 327390 | 2020-07-12 | Jayuya | Puerto Rico | 72073 | 155 | |
330576 | 330576 | 2020-07-13 | Jayuya | Puerto Rico | 72073 | 155 | |
333768 | 333768 | 2020-07-14 | Jayuya | Puerto Rico | 72073 | 155 | |
336962 | 336962 | 2020-07-15 | Jayuya | Puerto Rico | 72073 | 155 | |
340159 | 340159 | 2020-07-16 | Jayuya | Puerto Rico | 72073 | 157 | |
343357 | 343357 | 2020-07-17 | Jayuya | Puerto Rico | 72073 | 160 | |
346557 | 346557 | 2020-07-18 | Jayuya | Puerto Rico | 72073 | 161 | |
349757 | 349757 | 2020-07-19 | Jayuya | Puerto Rico | 72073 | 164 | |
352960 | 352960 | 2020-07-20 | Jayuya | Puerto Rico | 72073 | 168 | |
356163 | 356163 | 2020-07-21 | Jayuya | Puerto Rico | 72073 | 169 | |
359367 | 359367 | 2020-07-22 | Jayuya | Puerto Rico | 72073 | 169 | |
362573 | 362573 | 2020-07-23 | Jayuya | Puerto Rico | 72073 | 171 | |
365779 | 365779 | 2020-07-24 | Jayuya | Puerto Rico | 72073 | 172 | |
368988 | 368988 | 2020-07-25 | Jayuya | Puerto Rico | 72073 | 172 | |
372200 | 372200 | 2020-07-26 | Jayuya | Puerto Rico | 72073 | 173 | |
375413 | 375413 | 2020-07-27 | Jayuya | Puerto Rico | 72073 | 174 | |
378629 | 378629 | 2020-07-28 | Jayuya | Puerto Rico | 72073 | 175 | |
381846 | 381846 | 2020-07-29 | Jayuya | Puerto Rico | 72073 | 175 | |
385064 | 385064 | 2020-07-30 | Jayuya | Puerto Rico | 72073 | 176 | |
388281 | 388281 | 2020-07-31 | Jayuya | Puerto Rico | 72073 | 177 | |
391498 | 391498 | 2020-08-01 | Jayuya | Puerto Rico | 72073 | 177 | |
394714 | 394714 | 2020-08-02 | Jayuya | Puerto Rico | 72073 | 178 | |
397931 | 397931 | 2020-08-03 | Jayuya | Puerto Rico | 72073 | 179 | |
401146 | 401146 | 2020-08-04 | Jayuya | Puerto Rico | 72073 | 179 | |
404364 | 404364 | 2020-08-05 | Jayuya | Puerto Rico | 72073 | 179 | |
407583 | 407583 | 2020-08-06 | Jayuya | Puerto Rico | 72073 | 179 | |
410803 | 410803 | 2020-08-07 | Jayuya | Puerto Rico | 72073 | 179 | |
414023 | 414023 | 2020-08-08 | Jayuya | Puerto Rico | 72073 | 179 | |
417244 | 417244 | 2020-08-09 | Jayuya | Puerto Rico | 72073 | 179 | |
420464 | 420464 | 2020-08-10 | Jayuya | Puerto Rico | 72073 | 179 | |
423687 | 423687 | 2020-08-11 | Jayuya | Puerto Rico | 72073 | 180 | |
426910 | 426910 | 2020-08-12 | Jayuya | Puerto Rico | 72073 | 180 |
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);