ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Cabo Rojo" 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 |
---|---|---|---|---|---|---|---|
117498 | 117498 | 2020-05-05 | Cabo Rojo | Puerto Rico | 72023 | 20 | |
120460 | 120460 | 2020-05-06 | Cabo Rojo | Puerto Rico | 72023 | 20 | |
123437 | 123437 | 2020-05-07 | Cabo Rojo | Puerto Rico | 72023 | 20 | |
126420 | 126420 | 2020-05-08 | Cabo Rojo | Puerto Rico | 72023 | 22 | |
129409 | 129409 | 2020-05-09 | Cabo Rojo | Puerto Rico | 72023 | 22 | |
132398 | 132398 | 2020-05-10 | Cabo Rojo | Puerto Rico | 72023 | 22 | |
135389 | 135389 | 2020-05-11 | Cabo Rojo | Puerto Rico | 72023 | 22 | |
138379 | 138379 | 2020-05-12 | Cabo Rojo | Puerto Rico | 72023 | 23 | |
141375 | 141375 | 2020-05-13 | Cabo Rojo | Puerto Rico | 72023 | 23 | |
144371 | 144371 | 2020-05-14 | Cabo Rojo | Puerto Rico | 72023 | 23 | |
147372 | 147372 | 2020-05-15 | Cabo Rojo | Puerto Rico | 72023 | 23 | |
150379 | 150379 | 2020-05-16 | Cabo Rojo | Puerto Rico | 72023 | 23 | |
153390 | 153390 | 2020-05-17 | Cabo Rojo | Puerto Rico | 72023 | 23 | |
156407 | 156407 | 2020-05-18 | Cabo Rojo | Puerto Rico | 72023 | 24 | |
159428 | 159428 | 2020-05-19 | Cabo Rojo | Puerto Rico | 72023 | 25 | |
162455 | 162455 | 2020-05-20 | Cabo Rojo | Puerto Rico | 72023 | 25 | |
165484 | 165484 | 2020-05-21 | Cabo Rojo | Puerto Rico | 72023 | 25 | |
168520 | 168520 | 2020-05-22 | Cabo Rojo | Puerto Rico | 72023 | 26 | |
171559 | 171559 | 2020-05-23 | Cabo Rojo | Puerto Rico | 72023 | 27 | |
174601 | 174601 | 2020-05-24 | Cabo Rojo | Puerto Rico | 72023 | 28 | |
177645 | 177645 | 2020-05-25 | Cabo Rojo | Puerto Rico | 72023 | 28 | |
180688 | 180688 | 2020-05-26 | Cabo Rojo | Puerto Rico | 72023 | 29 | |
183738 | 183738 | 2020-05-27 | Cabo Rojo | Puerto Rico | 72023 | 29 | |
186795 | 186795 | 2020-05-28 | Cabo Rojo | Puerto Rico | 72023 | 40 | |
189856 | 189856 | 2020-05-29 | Cabo Rojo | Puerto Rico | 72023 | 42 | |
192921 | 192921 | 2020-05-30 | Cabo Rojo | Puerto Rico | 72023 | 42 | |
195990 | 195990 | 2020-05-31 | Cabo Rojo | Puerto Rico | 72023 | 42 | |
199063 | 199063 | 2020-06-01 | Cabo Rojo | Puerto Rico | 72023 | 42 | |
202138 | 202138 | 2020-06-02 | Cabo Rojo | Puerto Rico | 72023 | 42 | |
205215 | 205215 | 2020-06-03 | Cabo Rojo | Puerto Rico | 72023 | 42 | |
208296 | 208296 | 2020-06-04 | Cabo Rojo | Puerto Rico | 72023 | 47 | |
211378 | 211378 | 2020-06-05 | Cabo Rojo | Puerto Rico | 72023 | 47 | |
214464 | 214464 | 2020-06-06 | Cabo Rojo | Puerto Rico | 72023 | 49 | |
217554 | 217554 | 2020-06-07 | Cabo Rojo | Puerto Rico | 72023 | 49 | |
220646 | 220646 | 2020-06-08 | Cabo Rojo | Puerto Rico | 72023 | 50 | |
223741 | 223741 | 2020-06-09 | Cabo Rojo | Puerto Rico | 72023 | 51 | |
226841 | 226841 | 2020-06-10 | Cabo Rojo | Puerto Rico | 72023 | 56 | |
229945 | 229945 | 2020-06-11 | Cabo Rojo | Puerto Rico | 72023 | 58 | |
233050 | 233050 | 2020-06-12 | Cabo Rojo | Puerto Rico | 72023 | 58 | |
236155 | 236155 | 2020-06-13 | Cabo Rojo | Puerto Rico | 72023 | 59 | |
239263 | 239263 | 2020-06-14 | Cabo Rojo | Puerto Rico | 72023 | 60 | |
242372 | 242372 | 2020-06-15 | Cabo Rojo | Puerto Rico | 72023 | 60 | |
245484 | 245484 | 2020-06-16 | Cabo Rojo | Puerto Rico | 72023 | 61 | |
248597 | 248597 | 2020-06-17 | Cabo Rojo | Puerto Rico | 72023 | 61 | |
251712 | 251712 | 2020-06-18 | Cabo Rojo | Puerto Rico | 72023 | 61 | |
254827 | 254827 | 2020-06-19 | Cabo Rojo | Puerto Rico | 72023 | 61 | |
257953 | 257953 | 2020-06-20 | Cabo Rojo | Puerto Rico | 72023 | 65 | |
261080 | 261080 | 2020-06-21 | Cabo Rojo | Puerto Rico | 72023 | 66 | |
264208 | 264208 | 2020-06-22 | Cabo Rojo | Puerto Rico | 72023 | 66 | |
267336 | 267336 | 2020-06-23 | Cabo Rojo | Puerto Rico | 72023 | 67 | |
270470 | 270470 | 2020-06-24 | Cabo Rojo | Puerto Rico | 72023 | 67 | |
273609 | 273609 | 2020-06-25 | Cabo Rojo | Puerto Rico | 72023 | 71 | |
276756 | 276756 | 2020-06-26 | Cabo Rojo | Puerto Rico | 72023 | 72 | |
279904 | 279904 | 2020-06-27 | Cabo Rojo | Puerto Rico | 72023 | 73 | |
283050 | 283050 | 2020-06-28 | Cabo Rojo | Puerto Rico | 72023 | 73 | |
286195 | 286195 | 2020-06-29 | Cabo Rojo | Puerto Rico | 72023 | 75 | |
289346 | 289346 | 2020-06-30 | Cabo Rojo | Puerto Rico | 72023 | 78 | |
292498 | 292498 | 2020-07-01 | Cabo Rojo | Puerto Rico | 72023 | 80 | |
295654 | 295654 | 2020-07-02 | Cabo Rojo | Puerto Rico | 72023 | 80 | |
298813 | 298813 | 2020-07-03 | Cabo Rojo | Puerto Rico | 72023 | 80 | |
301977 | 301977 | 2020-07-04 | Cabo Rojo | Puerto Rico | 72023 | 81 | |
305140 | 305140 | 2020-07-05 | Cabo Rojo | Puerto Rico | 72023 | 84 | |
308307 | 308307 | 2020-07-06 | Cabo Rojo | Puerto Rico | 72023 | 87 | |
311476 | 311476 | 2020-07-07 | Cabo Rojo | Puerto Rico | 72023 | 87 | |
314648 | 314648 | 2020-07-08 | Cabo Rojo | Puerto Rico | 72023 | 86 | |
317821 | 317821 | 2020-07-09 | Cabo Rojo | Puerto Rico | 72023 | 88 | |
320999 | 320999 | 2020-07-10 | Cabo Rojo | Puerto Rico | 72023 | 95 | |
324179 | 324179 | 2020-07-11 | Cabo Rojo | Puerto Rico | 72023 | 97 | |
327364 | 327364 | 2020-07-12 | Cabo Rojo | Puerto Rico | 72023 | 106 | |
330550 | 330550 | 2020-07-13 | Cabo Rojo | Puerto Rico | 72023 | 110 | |
333742 | 333742 | 2020-07-14 | Cabo Rojo | Puerto Rico | 72023 | 111 | |
336936 | 336936 | 2020-07-15 | Cabo Rojo | Puerto Rico | 72023 | 111 | |
340133 | 340133 | 2020-07-16 | Cabo Rojo | Puerto Rico | 72023 | 118 | |
343331 | 343331 | 2020-07-17 | Cabo Rojo | Puerto Rico | 72023 | 125 | |
346531 | 346531 | 2020-07-18 | Cabo Rojo | Puerto Rico | 72023 | 127 | |
349731 | 349731 | 2020-07-19 | Cabo Rojo | Puerto Rico | 72023 | 130 | |
352934 | 352934 | 2020-07-20 | Cabo Rojo | Puerto Rico | 72023 | 135 | |
356137 | 356137 | 2020-07-21 | Cabo Rojo | Puerto Rico | 72023 | 140 | |
359341 | 359341 | 2020-07-22 | Cabo Rojo | Puerto Rico | 72023 | 142 | |
362547 | 362547 | 2020-07-23 | Cabo Rojo | Puerto Rico | 72023 | 144 | |
365753 | 365753 | 2020-07-24 | Cabo Rojo | Puerto Rico | 72023 | 150 | |
368962 | 368962 | 2020-07-25 | Cabo Rojo | Puerto Rico | 72023 | 152 | |
372174 | 372174 | 2020-07-26 | Cabo Rojo | Puerto Rico | 72023 | 156 | |
375387 | 375387 | 2020-07-27 | Cabo Rojo | Puerto Rico | 72023 | 158 | |
378603 | 378603 | 2020-07-28 | Cabo Rojo | Puerto Rico | 72023 | 159 | |
381820 | 381820 | 2020-07-29 | Cabo Rojo | Puerto Rico | 72023 | 160 | |
385038 | 385038 | 2020-07-30 | Cabo Rojo | Puerto Rico | 72023 | 160 | |
388255 | 388255 | 2020-07-31 | Cabo Rojo | Puerto Rico | 72023 | 163 | |
391472 | 391472 | 2020-08-01 | Cabo Rojo | Puerto Rico | 72023 | 171 | |
394688 | 394688 | 2020-08-02 | Cabo Rojo | Puerto Rico | 72023 | 172 | |
397905 | 397905 | 2020-08-03 | Cabo Rojo | Puerto Rico | 72023 | 177 | |
401120 | 401120 | 2020-08-04 | Cabo Rojo | Puerto Rico | 72023 | 180 | |
404338 | 404338 | 2020-08-05 | Cabo Rojo | Puerto Rico | 72023 | 185 | |
407557 | 407557 | 2020-08-06 | Cabo Rojo | Puerto Rico | 72023 | 192 | |
410777 | 410777 | 2020-08-07 | Cabo Rojo | Puerto Rico | 72023 | 197 | |
413997 | 413997 | 2020-08-08 | Cabo Rojo | Puerto Rico | 72023 | 202 | |
417218 | 417218 | 2020-08-09 | Cabo Rojo | Puerto Rico | 72023 | 206 | |
420438 | 420438 | 2020-08-10 | Cabo Rojo | Puerto Rico | 72023 | 210 | |
423661 | 423661 | 2020-08-11 | Cabo Rojo | Puerto Rico | 72023 | 216 | |
426884 | 426884 | 2020-08-12 | Cabo Rojo | Puerto Rico | 72023 | 220 |
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);