ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
739 rows where county = "San Sebastian" and state = "Puerto Rico" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
117551 | 117551 | 2020-05-05 | San Sebastian | Puerto Rico | 72131 | 29 | |
120513 | 120513 | 2020-05-06 | San Sebastian | Puerto Rico | 72131 | 29 | |
123490 | 123490 | 2020-05-07 | San Sebastian | Puerto Rico | 72131 | 29 | |
126473 | 126473 | 2020-05-08 | San Sebastian | Puerto Rico | 72131 | 29 | |
129462 | 129462 | 2020-05-09 | San Sebastian | Puerto Rico | 72131 | 30 | |
132451 | 132451 | 2020-05-10 | San Sebastian | Puerto Rico | 72131 | 31 | |
135442 | 135442 | 2020-05-11 | San Sebastian | Puerto Rico | 72131 | 31 | |
138432 | 138432 | 2020-05-12 | San Sebastian | Puerto Rico | 72131 | 31 | |
141428 | 141428 | 2020-05-13 | San Sebastian | Puerto Rico | 72131 | 31 | |
144424 | 144424 | 2020-05-14 | San Sebastian | Puerto Rico | 72131 | 31 | |
147425 | 147425 | 2020-05-15 | San Sebastian | Puerto Rico | 72131 | 31 | |
150433 | 150433 | 2020-05-16 | San Sebastian | Puerto Rico | 72131 | 32 | |
153444 | 153444 | 2020-05-17 | San Sebastian | Puerto Rico | 72131 | 33 | |
156461 | 156461 | 2020-05-18 | San Sebastian | Puerto Rico | 72131 | 34 | |
159482 | 159482 | 2020-05-19 | San Sebastian | Puerto Rico | 72131 | 35 | |
162509 | 162509 | 2020-05-20 | San Sebastian | Puerto Rico | 72131 | 35 | |
165538 | 165538 | 2020-05-21 | San Sebastian | Puerto Rico | 72131 | 35 | |
168574 | 168574 | 2020-05-22 | San Sebastian | Puerto Rico | 72131 | 35 | |
171613 | 171613 | 2020-05-23 | San Sebastian | Puerto Rico | 72131 | 35 | |
174655 | 174655 | 2020-05-24 | San Sebastian | Puerto Rico | 72131 | 35 | |
177699 | 177699 | 2020-05-25 | San Sebastian | Puerto Rico | 72131 | 36 | |
180742 | 180742 | 2020-05-26 | San Sebastian | Puerto Rico | 72131 | 38 | |
183792 | 183792 | 2020-05-27 | San Sebastian | Puerto Rico | 72131 | 40 | |
186849 | 186849 | 2020-05-28 | San Sebastian | Puerto Rico | 72131 | 40 | |
189911 | 189911 | 2020-05-29 | San Sebastian | Puerto Rico | 72131 | 40 | |
192976 | 192976 | 2020-05-30 | San Sebastian | Puerto Rico | 72131 | 47 | |
196045 | 196045 | 2020-05-31 | San Sebastian | Puerto Rico | 72131 | 47 | |
199118 | 199118 | 2020-06-01 | San Sebastian | Puerto Rico | 72131 | 47 | |
202193 | 202193 | 2020-06-02 | San Sebastian | Puerto Rico | 72131 | 47 | |
205270 | 205270 | 2020-06-03 | San Sebastian | Puerto Rico | 72131 | 47 | |
208351 | 208351 | 2020-06-04 | San Sebastian | Puerto Rico | 72131 | 68 | |
211433 | 211433 | 2020-06-05 | San Sebastian | Puerto Rico | 72131 | 69 | |
214519 | 214519 | 2020-06-06 | San Sebastian | Puerto Rico | 72131 | 74 | |
217609 | 217609 | 2020-06-07 | San Sebastian | Puerto Rico | 72131 | 76 | |
220701 | 220701 | 2020-06-08 | San Sebastian | Puerto Rico | 72131 | 77 | |
223796 | 223796 | 2020-06-09 | San Sebastian | Puerto Rico | 72131 | 77 | |
226896 | 226896 | 2020-06-10 | San Sebastian | Puerto Rico | 72131 | 78 | |
230000 | 230000 | 2020-06-11 | San Sebastian | Puerto Rico | 72131 | 78 | |
233105 | 233105 | 2020-06-12 | San Sebastian | Puerto Rico | 72131 | 78 | |
236210 | 236210 | 2020-06-13 | San Sebastian | Puerto Rico | 72131 | 78 | |
239318 | 239318 | 2020-06-14 | San Sebastian | Puerto Rico | 72131 | 78 | |
242427 | 242427 | 2020-06-15 | San Sebastian | Puerto Rico | 72131 | 78 | |
245539 | 245539 | 2020-06-16 | San Sebastian | Puerto Rico | 72131 | 78 | |
248652 | 248652 | 2020-06-17 | San Sebastian | Puerto Rico | 72131 | 78 | |
251767 | 251767 | 2020-06-18 | San Sebastian | Puerto Rico | 72131 | 78 | |
254882 | 254882 | 2020-06-19 | San Sebastian | Puerto Rico | 72131 | 78 | |
258008 | 258008 | 2020-06-20 | San Sebastian | Puerto Rico | 72131 | 78 | |
261135 | 261135 | 2020-06-21 | San Sebastian | Puerto Rico | 72131 | 78 | |
264263 | 264263 | 2020-06-22 | San Sebastian | Puerto Rico | 72131 | 78 | |
267391 | 267391 | 2020-06-23 | San Sebastian | Puerto Rico | 72131 | 78 | |
270525 | 270525 | 2020-06-24 | San Sebastian | Puerto Rico | 72131 | 78 | |
273664 | 273664 | 2020-06-25 | San Sebastian | Puerto Rico | 72131 | 93 | |
276811 | 276811 | 2020-06-26 | San Sebastian | Puerto Rico | 72131 | 94 | |
279959 | 279959 | 2020-06-27 | San Sebastian | Puerto Rico | 72131 | 96 | |
283105 | 283105 | 2020-06-28 | San Sebastian | Puerto Rico | 72131 | 96 | |
286250 | 286250 | 2020-06-29 | San Sebastian | Puerto Rico | 72131 | 96 | |
289401 | 289401 | 2020-06-30 | San Sebastian | Puerto Rico | 72131 | 98 | |
292553 | 292553 | 2020-07-01 | San Sebastian | Puerto Rico | 72131 | 98 | |
295709 | 295709 | 2020-07-02 | San Sebastian | Puerto Rico | 72131 | 98 | |
298868 | 298868 | 2020-07-03 | San Sebastian | Puerto Rico | 72131 | 99 | |
302032 | 302032 | 2020-07-04 | San Sebastian | Puerto Rico | 72131 | 100 | |
305195 | 305195 | 2020-07-05 | San Sebastian | Puerto Rico | 72131 | 100 | |
308362 | 308362 | 2020-07-06 | San Sebastian | Puerto Rico | 72131 | 101 | |
311531 | 311531 | 2020-07-07 | San Sebastian | Puerto Rico | 72131 | 103 | |
314703 | 314703 | 2020-07-08 | San Sebastian | Puerto Rico | 72131 | 104 | |
317876 | 317876 | 2020-07-09 | San Sebastian | Puerto Rico | 72131 | 104 | |
321054 | 321054 | 2020-07-10 | San Sebastian | Puerto Rico | 72131 | 105 | |
324234 | 324234 | 2020-07-11 | San Sebastian | Puerto Rico | 72131 | 109 | |
327419 | 327419 | 2020-07-12 | San Sebastian | Puerto Rico | 72131 | 111 | |
330605 | 330605 | 2020-07-13 | San Sebastian | Puerto Rico | 72131 | 112 | |
333797 | 333797 | 2020-07-14 | San Sebastian | Puerto Rico | 72131 | 113 | |
336991 | 336991 | 2020-07-15 | San Sebastian | Puerto Rico | 72131 | 115 | |
340188 | 340188 | 2020-07-16 | San Sebastian | Puerto Rico | 72131 | 117 | |
343386 | 343386 | 2020-07-17 | San Sebastian | Puerto Rico | 72131 | 122 | |
346586 | 346586 | 2020-07-18 | San Sebastian | Puerto Rico | 72131 | 123 | |
349786 | 349786 | 2020-07-19 | San Sebastian | Puerto Rico | 72131 | 129 | |
352989 | 352989 | 2020-07-20 | San Sebastian | Puerto Rico | 72131 | 135 | |
356192 | 356192 | 2020-07-21 | San Sebastian | Puerto Rico | 72131 | 139 | |
359396 | 359396 | 2020-07-22 | San Sebastian | Puerto Rico | 72131 | 141 | |
362602 | 362602 | 2020-07-23 | San Sebastian | Puerto Rico | 72131 | 142 | |
365808 | 365808 | 2020-07-24 | San Sebastian | Puerto Rico | 72131 | 144 | |
369017 | 369017 | 2020-07-25 | San Sebastian | Puerto Rico | 72131 | 151 | |
372229 | 372229 | 2020-07-26 | San Sebastian | Puerto Rico | 72131 | 154 | |
375442 | 375442 | 2020-07-27 | San Sebastian | Puerto Rico | 72131 | 156 | |
378658 | 378658 | 2020-07-28 | San Sebastian | Puerto Rico | 72131 | 158 | |
381875 | 381875 | 2020-07-29 | San Sebastian | Puerto Rico | 72131 | 158 | |
385093 | 385093 | 2020-07-30 | San Sebastian | Puerto Rico | 72131 | 166 | |
388310 | 388310 | 2020-07-31 | San Sebastian | Puerto Rico | 72131 | 170 | |
391527 | 391527 | 2020-08-01 | San Sebastian | Puerto Rico | 72131 | 173 | |
394743 | 394743 | 2020-08-02 | San Sebastian | Puerto Rico | 72131 | 184 | |
397960 | 397960 | 2020-08-03 | San Sebastian | Puerto Rico | 72131 | 185 | |
401175 | 401175 | 2020-08-04 | San Sebastian | Puerto Rico | 72131 | 191 | |
404393 | 404393 | 2020-08-05 | San Sebastian | Puerto Rico | 72131 | 196 | |
407612 | 407612 | 2020-08-06 | San Sebastian | Puerto Rico | 72131 | 212 | |
410832 | 410832 | 2020-08-07 | San Sebastian | Puerto Rico | 72131 | 217 | |
414052 | 414052 | 2020-08-08 | San Sebastian | Puerto Rico | 72131 | 220 | |
417273 | 417273 | 2020-08-09 | San Sebastian | Puerto Rico | 72131 | 231 | |
420493 | 420493 | 2020-08-10 | San Sebastian | Puerto Rico | 72131 | 236 | |
423716 | 423716 | 2020-08-11 | San Sebastian | Puerto Rico | 72131 | 241 | |
426939 | 426939 | 2020-08-12 | San Sebastian | Puerto Rico | 72131 | 245 |
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);