ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where fips = 72039 and state = "Puerto Rico" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
117506 | 117506 | 2020-05-05 | Ciales | Puerto Rico | 72039 | 7 | |
120468 | 120468 | 2020-05-06 | Ciales | Puerto Rico | 72039 | 7 | |
123445 | 123445 | 2020-05-07 | Ciales | Puerto Rico | 72039 | 7 | |
126428 | 126428 | 2020-05-08 | Ciales | Puerto Rico | 72039 | 8 | |
129417 | 129417 | 2020-05-09 | Ciales | Puerto Rico | 72039 | 8 | |
132406 | 132406 | 2020-05-10 | Ciales | Puerto Rico | 72039 | 9 | |
135397 | 135397 | 2020-05-11 | Ciales | Puerto Rico | 72039 | 11 | |
138387 | 138387 | 2020-05-12 | Ciales | Puerto Rico | 72039 | 11 | |
141383 | 141383 | 2020-05-13 | Ciales | Puerto Rico | 72039 | 11 | |
144379 | 144379 | 2020-05-14 | Ciales | Puerto Rico | 72039 | 11 | |
147380 | 147380 | 2020-05-15 | Ciales | Puerto Rico | 72039 | 13 | |
150387 | 150387 | 2020-05-16 | Ciales | Puerto Rico | 72039 | 13 | |
153398 | 153398 | 2020-05-17 | Ciales | Puerto Rico | 72039 | 13 | |
156415 | 156415 | 2020-05-18 | Ciales | Puerto Rico | 72039 | 13 | |
159436 | 159436 | 2020-05-19 | Ciales | Puerto Rico | 72039 | 14 | |
162463 | 162463 | 2020-05-20 | Ciales | Puerto Rico | 72039 | 15 | |
165492 | 165492 | 2020-05-21 | Ciales | Puerto Rico | 72039 | 15 | |
168528 | 168528 | 2020-05-22 | Ciales | Puerto Rico | 72039 | 17 | |
171567 | 171567 | 2020-05-23 | Ciales | Puerto Rico | 72039 | 17 | |
174609 | 174609 | 2020-05-24 | Ciales | Puerto Rico | 72039 | 17 | |
177653 | 177653 | 2020-05-25 | Ciales | Puerto Rico | 72039 | 17 | |
180696 | 180696 | 2020-05-26 | Ciales | Puerto Rico | 72039 | 17 | |
183746 | 183746 | 2020-05-27 | Ciales | Puerto Rico | 72039 | 17 | |
186803 | 186803 | 2020-05-28 | Ciales | Puerto Rico | 72039 | 18 | |
189864 | 189864 | 2020-05-29 | Ciales | Puerto Rico | 72039 | 19 | |
192929 | 192929 | 2020-05-30 | Ciales | Puerto Rico | 72039 | 19 | |
195998 | 195998 | 2020-05-31 | Ciales | Puerto Rico | 72039 | 20 | |
199071 | 199071 | 2020-06-01 | Ciales | Puerto Rico | 72039 | 20 | |
202146 | 202146 | 2020-06-02 | Ciales | Puerto Rico | 72039 | 20 | |
205223 | 205223 | 2020-06-03 | Ciales | Puerto Rico | 72039 | 20 | |
208304 | 208304 | 2020-06-04 | Ciales | Puerto Rico | 72039 | 27 | |
211386 | 211386 | 2020-06-05 | Ciales | Puerto Rico | 72039 | 27 | |
214472 | 214472 | 2020-06-06 | Ciales | Puerto Rico | 72039 | 34 | |
217562 | 217562 | 2020-06-07 | Ciales | Puerto Rico | 72039 | 34 | |
220654 | 220654 | 2020-06-08 | Ciales | Puerto Rico | 72039 | 37 | |
223749 | 223749 | 2020-06-09 | Ciales | Puerto Rico | 72039 | 42 | |
226849 | 226849 | 2020-06-10 | Ciales | Puerto Rico | 72039 | 42 | |
229953 | 229953 | 2020-06-11 | Ciales | Puerto Rico | 72039 | 42 | |
233058 | 233058 | 2020-06-12 | Ciales | Puerto Rico | 72039 | 43 | |
236163 | 236163 | 2020-06-13 | Ciales | Puerto Rico | 72039 | 44 | |
239271 | 239271 | 2020-06-14 | Ciales | Puerto Rico | 72039 | 45 | |
242380 | 242380 | 2020-06-15 | Ciales | Puerto Rico | 72039 | 46 | |
245492 | 245492 | 2020-06-16 | Ciales | Puerto Rico | 72039 | 46 | |
248605 | 248605 | 2020-06-17 | Ciales | Puerto Rico | 72039 | 46 | |
251720 | 251720 | 2020-06-18 | Ciales | Puerto Rico | 72039 | 47 | |
254835 | 254835 | 2020-06-19 | Ciales | Puerto Rico | 72039 | 47 | |
257961 | 257961 | 2020-06-20 | Ciales | Puerto Rico | 72039 | 50 | |
261088 | 261088 | 2020-06-21 | Ciales | Puerto Rico | 72039 | 52 | |
264216 | 264216 | 2020-06-22 | Ciales | Puerto Rico | 72039 | 52 | |
267344 | 267344 | 2020-06-23 | Ciales | Puerto Rico | 72039 | 52 | |
270478 | 270478 | 2020-06-24 | Ciales | Puerto Rico | 72039 | 55 | |
273617 | 273617 | 2020-06-25 | Ciales | Puerto Rico | 72039 | 55 | |
276764 | 276764 | 2020-06-26 | Ciales | Puerto Rico | 72039 | 55 | |
279912 | 279912 | 2020-06-27 | Ciales | Puerto Rico | 72039 | 58 | |
283058 | 283058 | 2020-06-28 | Ciales | Puerto Rico | 72039 | 61 | |
286203 | 286203 | 2020-06-29 | Ciales | Puerto Rico | 72039 | 61 | |
289354 | 289354 | 2020-06-30 | Ciales | Puerto Rico | 72039 | 62 | |
292506 | 292506 | 2020-07-01 | Ciales | Puerto Rico | 72039 | 62 | |
295662 | 295662 | 2020-07-02 | Ciales | Puerto Rico | 72039 | 62 | |
298821 | 298821 | 2020-07-03 | Ciales | Puerto Rico | 72039 | 62 | |
301985 | 301985 | 2020-07-04 | Ciales | Puerto Rico | 72039 | 62 | |
305148 | 305148 | 2020-07-05 | Ciales | Puerto Rico | 72039 | 62 | |
308315 | 308315 | 2020-07-06 | Ciales | Puerto Rico | 72039 | 63 | |
311484 | 311484 | 2020-07-07 | Ciales | Puerto Rico | 72039 | 64 | |
314656 | 314656 | 2020-07-08 | Ciales | Puerto Rico | 72039 | 64 | |
317829 | 317829 | 2020-07-09 | Ciales | Puerto Rico | 72039 | 64 | |
321007 | 321007 | 2020-07-10 | Ciales | Puerto Rico | 72039 | 65 | |
324187 | 324187 | 2020-07-11 | Ciales | Puerto Rico | 72039 | 65 | |
327372 | 327372 | 2020-07-12 | Ciales | Puerto Rico | 72039 | 65 | |
330558 | 330558 | 2020-07-13 | Ciales | Puerto Rico | 72039 | 66 | |
333750 | 333750 | 2020-07-14 | Ciales | Puerto Rico | 72039 | 69 | |
336944 | 336944 | 2020-07-15 | Ciales | Puerto Rico | 72039 | 72 | |
340141 | 340141 | 2020-07-16 | Ciales | Puerto Rico | 72039 | 73 | |
343339 | 343339 | 2020-07-17 | Ciales | Puerto Rico | 72039 | 75 | |
346539 | 346539 | 2020-07-18 | Ciales | Puerto Rico | 72039 | 76 | |
349739 | 349739 | 2020-07-19 | Ciales | Puerto Rico | 72039 | 78 | |
352942 | 352942 | 2020-07-20 | Ciales | Puerto Rico | 72039 | 81 | |
356145 | 356145 | 2020-07-21 | Ciales | Puerto Rico | 72039 | 82 | |
359349 | 359349 | 2020-07-22 | Ciales | Puerto Rico | 72039 | 83 | |
362555 | 362555 | 2020-07-23 | Ciales | Puerto Rico | 72039 | 89 | |
365761 | 365761 | 2020-07-24 | Ciales | Puerto Rico | 72039 | 96 | |
368970 | 368970 | 2020-07-25 | Ciales | Puerto Rico | 72039 | 102 | |
372182 | 372182 | 2020-07-26 | Ciales | Puerto Rico | 72039 | 105 | |
375395 | 375395 | 2020-07-27 | Ciales | Puerto Rico | 72039 | 105 | |
378611 | 378611 | 2020-07-28 | Ciales | Puerto Rico | 72039 | 108 | |
381828 | 381828 | 2020-07-29 | Ciales | Puerto Rico | 72039 | 111 | |
385046 | 385046 | 2020-07-30 | Ciales | Puerto Rico | 72039 | 115 | |
388263 | 388263 | 2020-07-31 | Ciales | Puerto Rico | 72039 | 115 | |
391480 | 391480 | 2020-08-01 | Ciales | Puerto Rico | 72039 | 120 | |
394696 | 394696 | 2020-08-02 | Ciales | Puerto Rico | 72039 | 122 | |
397913 | 397913 | 2020-08-03 | Ciales | Puerto Rico | 72039 | 122 | |
401128 | 401128 | 2020-08-04 | Ciales | Puerto Rico | 72039 | 125 | |
404346 | 404346 | 2020-08-05 | Ciales | Puerto Rico | 72039 | 125 | |
407565 | 407565 | 2020-08-06 | Ciales | Puerto Rico | 72039 | 128 | |
410785 | 410785 | 2020-08-07 | Ciales | Puerto Rico | 72039 | 135 | |
414005 | 414005 | 2020-08-08 | Ciales | Puerto Rico | 72039 | 139 | |
417226 | 417226 | 2020-08-09 | Ciales | Puerto Rico | 72039 | 149 | |
420446 | 420446 | 2020-08-10 | Ciales | Puerto Rico | 72039 | 155 | |
423669 | 423669 | 2020-08-11 | Ciales | Puerto Rico | 72039 | 158 | |
426892 | 426892 | 2020-08-12 | Ciales | Puerto Rico | 72039 | 161 |
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);