ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "Fajardo" 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 |
---|---|---|---|---|---|---|---|
117512 | 117512 | 2020-05-05 | Fajardo | Puerto Rico | 72053 | 7 | |
120474 | 120474 | 2020-05-06 | Fajardo | Puerto Rico | 72053 | 8 | |
123451 | 123451 | 2020-05-07 | Fajardo | Puerto Rico | 72053 | 9 | |
126434 | 126434 | 2020-05-08 | Fajardo | Puerto Rico | 72053 | 9 | |
129423 | 129423 | 2020-05-09 | Fajardo | Puerto Rico | 72053 | 10 | |
135403 | 135403 | 2020-05-11 | Fajardo | Puerto Rico | 72053 | 11 | |
138393 | 138393 | 2020-05-12 | Fajardo | Puerto Rico | 72053 | 11 | |
141389 | 141389 | 2020-05-13 | Fajardo | Puerto Rico | 72053 | 11 | |
144385 | 144385 | 2020-05-14 | Fajardo | Puerto Rico | 72053 | 11 | |
132412 | 132412 | 2020-05-10 | Fajardo | Puerto Rico | 72053 | 12 | |
147386 | 147386 | 2020-05-15 | Fajardo | Puerto Rico | 72053 | 12 | |
150393 | 150393 | 2020-05-16 | Fajardo | Puerto Rico | 72053 | 14 | |
153404 | 153404 | 2020-05-17 | Fajardo | Puerto Rico | 72053 | 14 | |
156421 | 156421 | 2020-05-18 | Fajardo | Puerto Rico | 72053 | 14 | |
159442 | 159442 | 2020-05-19 | Fajardo | Puerto Rico | 72053 | 16 | |
165498 | 165498 | 2020-05-21 | Fajardo | Puerto Rico | 72053 | 16 | |
168534 | 168534 | 2020-05-22 | Fajardo | Puerto Rico | 72053 | 16 | |
171573 | 171573 | 2020-05-23 | Fajardo | Puerto Rico | 72053 | 16 | |
162469 | 162469 | 2020-05-20 | Fajardo | Puerto Rico | 72053 | 17 | |
174615 | 174615 | 2020-05-24 | Fajardo | Puerto Rico | 72053 | 17 | |
177659 | 177659 | 2020-05-25 | Fajardo | Puerto Rico | 72053 | 17 | |
180702 | 180702 | 2020-05-26 | Fajardo | Puerto Rico | 72053 | 18 | |
183752 | 183752 | 2020-05-27 | Fajardo | Puerto Rico | 72053 | 18 | |
186809 | 186809 | 2020-05-28 | Fajardo | Puerto Rico | 72053 | 21 | |
189871 | 189871 | 2020-05-29 | Fajardo | Puerto Rico | 72053 | 22 | |
192936 | 192936 | 2020-05-30 | Fajardo | Puerto Rico | 72053 | 22 | |
196005 | 196005 | 2020-05-31 | Fajardo | Puerto Rico | 72053 | 22 | |
199078 | 199078 | 2020-06-01 | Fajardo | Puerto Rico | 72053 | 28 | |
202153 | 202153 | 2020-06-02 | Fajardo | Puerto Rico | 72053 | 28 | |
205230 | 205230 | 2020-06-03 | Fajardo | Puerto Rico | 72053 | 28 | |
208311 | 208311 | 2020-06-04 | Fajardo | Puerto Rico | 72053 | 32 | |
211393 | 211393 | 2020-06-05 | Fajardo | Puerto Rico | 72053 | 33 | |
214479 | 214479 | 2020-06-06 | Fajardo | Puerto Rico | 72053 | 41 | |
217569 | 217569 | 2020-06-07 | Fajardo | Puerto Rico | 72053 | 44 | |
220661 | 220661 | 2020-06-08 | Fajardo | Puerto Rico | 72053 | 44 | |
223756 | 223756 | 2020-06-09 | Fajardo | Puerto Rico | 72053 | 45 | |
226856 | 226856 | 2020-06-10 | Fajardo | Puerto Rico | 72053 | 46 | |
229960 | 229960 | 2020-06-11 | Fajardo | Puerto Rico | 72053 | 46 | |
233065 | 233065 | 2020-06-12 | Fajardo | Puerto Rico | 72053 | 46 | |
236170 | 236170 | 2020-06-13 | Fajardo | Puerto Rico | 72053 | 49 | |
239278 | 239278 | 2020-06-14 | Fajardo | Puerto Rico | 72053 | 52 | |
242387 | 242387 | 2020-06-15 | Fajardo | Puerto Rico | 72053 | 52 | |
245499 | 245499 | 2020-06-16 | Fajardo | Puerto Rico | 72053 | 52 | |
248612 | 248612 | 2020-06-17 | Fajardo | Puerto Rico | 72053 | 52 | |
251727 | 251727 | 2020-06-18 | Fajardo | Puerto Rico | 72053 | 53 | |
254842 | 254842 | 2020-06-19 | Fajardo | Puerto Rico | 72053 | 53 | |
257968 | 257968 | 2020-06-20 | Fajardo | Puerto Rico | 72053 | 64 | |
261095 | 261095 | 2020-06-21 | Fajardo | Puerto Rico | 72053 | 67 | |
264223 | 264223 | 2020-06-22 | Fajardo | Puerto Rico | 72053 | 68 | |
267351 | 267351 | 2020-06-23 | Fajardo | Puerto Rico | 72053 | 68 | |
270485 | 270485 | 2020-06-24 | Fajardo | Puerto Rico | 72053 | 72 | |
273624 | 273624 | 2020-06-25 | Fajardo | Puerto Rico | 72053 | 74 | |
276771 | 276771 | 2020-06-26 | Fajardo | Puerto Rico | 72053 | 74 | |
279919 | 279919 | 2020-06-27 | Fajardo | Puerto Rico | 72053 | 75 | |
283065 | 283065 | 2020-06-28 | Fajardo | Puerto Rico | 72053 | 75 | |
286210 | 286210 | 2020-06-29 | Fajardo | Puerto Rico | 72053 | 76 | |
289361 | 289361 | 2020-06-30 | Fajardo | Puerto Rico | 72053 | 77 | |
292513 | 292513 | 2020-07-01 | Fajardo | Puerto Rico | 72053 | 80 | |
295669 | 295669 | 2020-07-02 | Fajardo | Puerto Rico | 72053 | 80 | |
298828 | 298828 | 2020-07-03 | Fajardo | Puerto Rico | 72053 | 82 | |
301992 | 301992 | 2020-07-04 | Fajardo | Puerto Rico | 72053 | 84 | |
305155 | 305155 | 2020-07-05 | Fajardo | Puerto Rico | 72053 | 84 | |
308322 | 308322 | 2020-07-06 | Fajardo | Puerto Rico | 72053 | 96 | |
314663 | 314663 | 2020-07-08 | Fajardo | Puerto Rico | 72053 | 97 | |
317836 | 317836 | 2020-07-09 | Fajardo | Puerto Rico | 72053 | 97 | |
311491 | 311491 | 2020-07-07 | Fajardo | Puerto Rico | 72053 | 98 | |
321014 | 321014 | 2020-07-10 | Fajardo | Puerto Rico | 72053 | 101 | |
324194 | 324194 | 2020-07-11 | Fajardo | Puerto Rico | 72053 | 101 | |
327379 | 327379 | 2020-07-12 | Fajardo | Puerto Rico | 72053 | 102 | |
330565 | 330565 | 2020-07-13 | Fajardo | Puerto Rico | 72053 | 105 | |
333757 | 333757 | 2020-07-14 | Fajardo | Puerto Rico | 72053 | 107 | |
336951 | 336951 | 2020-07-15 | Fajardo | Puerto Rico | 72053 | 110 | |
340148 | 340148 | 2020-07-16 | Fajardo | Puerto Rico | 72053 | 110 | |
343346 | 343346 | 2020-07-17 | Fajardo | Puerto Rico | 72053 | 115 | |
346546 | 346546 | 2020-07-18 | Fajardo | Puerto Rico | 72053 | 117 | |
349746 | 349746 | 2020-07-19 | Fajardo | Puerto Rico | 72053 | 124 | |
352949 | 352949 | 2020-07-20 | Fajardo | Puerto Rico | 72053 | 128 | |
356152 | 356152 | 2020-07-21 | Fajardo | Puerto Rico | 72053 | 133 | |
359356 | 359356 | 2020-07-22 | Fajardo | Puerto Rico | 72053 | 135 | |
362562 | 362562 | 2020-07-23 | Fajardo | Puerto Rico | 72053 | 144 | |
365768 | 365768 | 2020-07-24 | Fajardo | Puerto Rico | 72053 | 152 | |
368977 | 368977 | 2020-07-25 | Fajardo | Puerto Rico | 72053 | 154 | |
372189 | 372189 | 2020-07-26 | Fajardo | Puerto Rico | 72053 | 162 | |
375402 | 375402 | 2020-07-27 | Fajardo | Puerto Rico | 72053 | 165 | |
378618 | 378618 | 2020-07-28 | Fajardo | Puerto Rico | 72053 | 167 | |
381835 | 381835 | 2020-07-29 | Fajardo | Puerto Rico | 72053 | 168 | |
385053 | 385053 | 2020-07-30 | Fajardo | Puerto Rico | 72053 | 176 | |
388270 | 388270 | 2020-07-31 | Fajardo | Puerto Rico | 72053 | 180 | |
391487 | 391487 | 2020-08-01 | Fajardo | Puerto Rico | 72053 | 196 | |
394703 | 394703 | 2020-08-02 | Fajardo | Puerto Rico | 72053 | 201 | |
397920 | 397920 | 2020-08-03 | Fajardo | Puerto Rico | 72053 | 208 | |
401135 | 401135 | 2020-08-04 | Fajardo | Puerto Rico | 72053 | 209 | |
404353 | 404353 | 2020-08-05 | Fajardo | Puerto Rico | 72053 | 212 | |
407572 | 407572 | 2020-08-06 | Fajardo | Puerto Rico | 72053 | 213 | |
410792 | 410792 | 2020-08-07 | Fajardo | Puerto Rico | 72053 | 222 | |
414012 | 414012 | 2020-08-08 | Fajardo | Puerto Rico | 72053 | 232 | |
417233 | 417233 | 2020-08-09 | Fajardo | Puerto Rico | 72053 | 240 | |
420453 | 420453 | 2020-08-10 | Fajardo | Puerto Rico | 72053 | 256 | |
423676 | 423676 | 2020-08-11 | Fajardo | Puerto Rico | 72053 | 266 | |
426899 | 426899 | 2020-08-12 | Fajardo | Puerto Rico | 72053 | 276 |
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);