ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Guanica" and state = "Puerto Rico" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
117514 | 117514 | 2020-05-05 | Guanica | Puerto Rico | 72055 | 16 | |
120476 | 120476 | 2020-05-06 | Guanica | Puerto Rico | 72055 | 16 | |
123453 | 123453 | 2020-05-07 | Guanica | Puerto Rico | 72055 | 16 | |
126436 | 126436 | 2020-05-08 | Guanica | Puerto Rico | 72055 | 16 | |
129425 | 129425 | 2020-05-09 | Guanica | Puerto Rico | 72055 | 16 | |
132414 | 132414 | 2020-05-10 | Guanica | Puerto Rico | 72055 | 16 | |
135405 | 135405 | 2020-05-11 | Guanica | Puerto Rico | 72055 | 16 | |
138395 | 138395 | 2020-05-12 | Guanica | Puerto Rico | 72055 | 16 | |
141391 | 141391 | 2020-05-13 | Guanica | Puerto Rico | 72055 | 16 | |
144387 | 144387 | 2020-05-14 | Guanica | Puerto Rico | 72055 | 16 | |
147388 | 147388 | 2020-05-15 | Guanica | Puerto Rico | 72055 | 16 | |
150395 | 150395 | 2020-05-16 | Guanica | Puerto Rico | 72055 | 16 | |
153406 | 153406 | 2020-05-17 | Guanica | Puerto Rico | 72055 | 16 | |
156423 | 156423 | 2020-05-18 | Guanica | Puerto Rico | 72055 | 17 | |
159444 | 159444 | 2020-05-19 | Guanica | Puerto Rico | 72055 | 17 | |
162471 | 162471 | 2020-05-20 | Guanica | Puerto Rico | 72055 | 18 | |
165500 | 165500 | 2020-05-21 | Guanica | Puerto Rico | 72055 | 18 | |
168536 | 168536 | 2020-05-22 | Guanica | Puerto Rico | 72055 | 18 | |
171575 | 171575 | 2020-05-23 | Guanica | Puerto Rico | 72055 | 18 | |
174617 | 174617 | 2020-05-24 | Guanica | Puerto Rico | 72055 | 18 | |
177661 | 177661 | 2020-05-25 | Guanica | Puerto Rico | 72055 | 18 | |
180704 | 180704 | 2020-05-26 | Guanica | Puerto Rico | 72055 | 18 | |
183754 | 183754 | 2020-05-27 | Guanica | Puerto Rico | 72055 | 19 | |
186811 | 186811 | 2020-05-28 | Guanica | Puerto Rico | 72055 | 21 | |
189873 | 189873 | 2020-05-29 | Guanica | Puerto Rico | 72055 | 22 | |
192938 | 192938 | 2020-05-30 | Guanica | Puerto Rico | 72055 | 22 | |
196007 | 196007 | 2020-05-31 | Guanica | Puerto Rico | 72055 | 22 | |
199080 | 199080 | 2020-06-01 | Guanica | Puerto Rico | 72055 | 22 | |
202155 | 202155 | 2020-06-02 | Guanica | Puerto Rico | 72055 | 22 | |
205232 | 205232 | 2020-06-03 | Guanica | Puerto Rico | 72055 | 23 | |
208313 | 208313 | 2020-06-04 | Guanica | Puerto Rico | 72055 | 28 | |
211395 | 211395 | 2020-06-05 | Guanica | Puerto Rico | 72055 | 28 | |
214481 | 214481 | 2020-06-06 | Guanica | Puerto Rico | 72055 | 29 | |
217571 | 217571 | 2020-06-07 | Guanica | Puerto Rico | 72055 | 28 | |
220663 | 220663 | 2020-06-08 | Guanica | Puerto Rico | 72055 | 29 | |
223758 | 223758 | 2020-06-09 | Guanica | Puerto Rico | 72055 | 29 | |
226858 | 226858 | 2020-06-10 | Guanica | Puerto Rico | 72055 | 30 | |
229962 | 229962 | 2020-06-11 | Guanica | Puerto Rico | 72055 | 30 | |
233067 | 233067 | 2020-06-12 | Guanica | Puerto Rico | 72055 | 30 | |
236172 | 236172 | 2020-06-13 | Guanica | Puerto Rico | 72055 | 30 | |
239280 | 239280 | 2020-06-14 | Guanica | Puerto Rico | 72055 | 30 | |
242389 | 242389 | 2020-06-15 | Guanica | Puerto Rico | 72055 | 30 | |
245501 | 245501 | 2020-06-16 | Guanica | Puerto Rico | 72055 | 30 | |
248614 | 248614 | 2020-06-17 | Guanica | Puerto Rico | 72055 | 30 | |
251729 | 251729 | 2020-06-18 | Guanica | Puerto Rico | 72055 | 30 | |
254844 | 254844 | 2020-06-19 | Guanica | Puerto Rico | 72055 | 30 | |
257970 | 257970 | 2020-06-20 | Guanica | Puerto Rico | 72055 | 30 | |
261097 | 261097 | 2020-06-21 | Guanica | Puerto Rico | 72055 | 30 | |
264225 | 264225 | 2020-06-22 | Guanica | Puerto Rico | 72055 | 30 | |
267353 | 267353 | 2020-06-23 | Guanica | Puerto Rico | 72055 | 30 | |
270487 | 270487 | 2020-06-24 | Guanica | Puerto Rico | 72055 | 30 | |
273626 | 273626 | 2020-06-25 | Guanica | Puerto Rico | 72055 | 34 | |
276773 | 276773 | 2020-06-26 | Guanica | Puerto Rico | 72055 | 33 | |
279921 | 279921 | 2020-06-27 | Guanica | Puerto Rico | 72055 | 34 | |
283067 | 283067 | 2020-06-28 | Guanica | Puerto Rico | 72055 | 34 | |
286212 | 286212 | 2020-06-29 | Guanica | Puerto Rico | 72055 | 34 | |
289363 | 289363 | 2020-06-30 | Guanica | Puerto Rico | 72055 | 36 | |
292515 | 292515 | 2020-07-01 | Guanica | Puerto Rico | 72055 | 36 | |
295671 | 295671 | 2020-07-02 | Guanica | Puerto Rico | 72055 | 36 | |
298830 | 298830 | 2020-07-03 | Guanica | Puerto Rico | 72055 | 35 | |
301994 | 301994 | 2020-07-04 | Guanica | Puerto Rico | 72055 | 35 | |
305157 | 305157 | 2020-07-05 | Guanica | Puerto Rico | 72055 | 36 | |
308324 | 308324 | 2020-07-06 | Guanica | Puerto Rico | 72055 | 36 | |
311493 | 311493 | 2020-07-07 | Guanica | Puerto Rico | 72055 | 36 | |
314665 | 314665 | 2020-07-08 | Guanica | Puerto Rico | 72055 | 37 | |
317838 | 317838 | 2020-07-09 | Guanica | Puerto Rico | 72055 | 38 | |
321016 | 321016 | 2020-07-10 | Guanica | Puerto Rico | 72055 | 43 | |
324196 | 324196 | 2020-07-11 | Guanica | Puerto Rico | 72055 | 43 | |
327381 | 327381 | 2020-07-12 | Guanica | Puerto Rico | 72055 | 44 | |
330567 | 330567 | 2020-07-13 | Guanica | Puerto Rico | 72055 | 47 | |
333759 | 333759 | 2020-07-14 | Guanica | Puerto Rico | 72055 | 47 | |
336953 | 336953 | 2020-07-15 | Guanica | Puerto Rico | 72055 | 47 | |
340150 | 340150 | 2020-07-16 | Guanica | Puerto Rico | 72055 | 48 | |
343348 | 343348 | 2020-07-17 | Guanica | Puerto Rico | 72055 | 48 | |
346548 | 346548 | 2020-07-18 | Guanica | Puerto Rico | 72055 | 48 | |
349748 | 349748 | 2020-07-19 | Guanica | Puerto Rico | 72055 | 49 | |
352951 | 352951 | 2020-07-20 | Guanica | Puerto Rico | 72055 | 50 | |
356154 | 356154 | 2020-07-21 | Guanica | Puerto Rico | 72055 | 51 | |
359358 | 359358 | 2020-07-22 | Guanica | Puerto Rico | 72055 | 51 | |
362564 | 362564 | 2020-07-23 | Guanica | Puerto Rico | 72055 | 51 | |
365770 | 365770 | 2020-07-24 | Guanica | Puerto Rico | 72055 | 52 | |
368979 | 368979 | 2020-07-25 | Guanica | Puerto Rico | 72055 | 52 | |
372191 | 372191 | 2020-07-26 | Guanica | Puerto Rico | 72055 | 52 | |
375404 | 375404 | 2020-07-27 | Guanica | Puerto Rico | 72055 | 52 | |
378620 | 378620 | 2020-07-28 | Guanica | Puerto Rico | 72055 | 52 | |
381837 | 381837 | 2020-07-29 | Guanica | Puerto Rico | 72055 | 52 | |
385055 | 385055 | 2020-07-30 | Guanica | Puerto Rico | 72055 | 52 | |
388272 | 388272 | 2020-07-31 | Guanica | Puerto Rico | 72055 | 52 | |
391489 | 391489 | 2020-08-01 | Guanica | Puerto Rico | 72055 | 52 | |
394705 | 394705 | 2020-08-02 | Guanica | Puerto Rico | 72055 | 53 | |
397922 | 397922 | 2020-08-03 | Guanica | Puerto Rico | 72055 | 53 | |
401137 | 401137 | 2020-08-04 | Guanica | Puerto Rico | 72055 | 54 | |
404355 | 404355 | 2020-08-05 | Guanica | Puerto Rico | 72055 | 54 | |
407574 | 407574 | 2020-08-06 | Guanica | Puerto Rico | 72055 | 55 | |
410794 | 410794 | 2020-08-07 | Guanica | Puerto Rico | 72055 | 56 | |
414014 | 414014 | 2020-08-08 | Guanica | Puerto Rico | 72055 | 56 | |
417235 | 417235 | 2020-08-09 | Guanica | Puerto Rico | 72055 | 58 | |
420455 | 420455 | 2020-08-10 | Guanica | Puerto Rico | 72055 | 59 | |
423678 | 423678 | 2020-08-11 | Guanica | Puerto Rico | 72055 | 61 | |
426901 | 426901 | 2020-08-12 | Guanica | Puerto Rico | 72055 | 62 |
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);