ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 45019 sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
239346 | 239346 | 2020-06-14 | Charleston | South Carolina | 45019 | 1092 | 15 |
242455 | 242455 | 2020-06-15 | Charleston | South Carolina | 45019 | 1165 | 16 |
245567 | 245567 | 2020-06-16 | Charleston | South Carolina | 45019 | 1230 | 16 |
248680 | 248680 | 2020-06-17 | Charleston | South Carolina | 45019 | 1264 | 17 |
251795 | 251795 | 2020-06-18 | Charleston | South Carolina | 45019 | 1403 | 17 |
254910 | 254910 | 2020-06-19 | Charleston | South Carolina | 45019 | 1554 | 19 |
258036 | 258036 | 2020-06-20 | Charleston | South Carolina | 45019 | 1728 | 19 |
261163 | 261163 | 2020-06-21 | Charleston | South Carolina | 45019 | 1836 | 19 |
264291 | 264291 | 2020-06-22 | Charleston | South Carolina | 45019 | 2044 | 19 |
267419 | 267419 | 2020-06-23 | Charleston | South Carolina | 45019 | 2252 | 20 |
270553 | 270553 | 2020-06-24 | Charleston | South Carolina | 45019 | 2417 | 21 |
273692 | 273692 | 2020-06-25 | Charleston | South Carolina | 45019 | 2629 | 22 |
276839 | 276839 | 2020-06-26 | Charleston | South Carolina | 45019 | 2861 | 22 |
279987 | 279987 | 2020-06-27 | Charleston | South Carolina | 45019 | 3142 | 22 |
283133 | 283133 | 2020-06-28 | Charleston | South Carolina | 45019 | 3381 | 23 |
286278 | 286278 | 2020-06-29 | Charleston | South Carolina | 45019 | 3654 | 23 |
289429 | 289429 | 2020-06-30 | Charleston | South Carolina | 45019 | 4027 | 26 |
292581 | 292581 | 2020-07-01 | Charleston | South Carolina | 45019 | 4289 | 33 |
295737 | 295737 | 2020-07-02 | Charleston | South Carolina | 45019 | 4615 | 34 |
298896 | 298896 | 2020-07-03 | Charleston | South Carolina | 45019 | 5033 | 34 |
302060 | 302060 | 2020-07-04 | Charleston | South Carolina | 45019 | 5376 | 35 |
305223 | 305223 | 2020-07-05 | Charleston | South Carolina | 45019 | 5651 | 36 |
308390 | 308390 | 2020-07-06 | Charleston | South Carolina | 45019 | 5979 | 36 |
311559 | 311559 | 2020-07-07 | Charleston | South Carolina | 45019 | 6073 | 41 |
314731 | 314731 | 2020-07-08 | Charleston | South Carolina | 45019 | 6337 | 47 |
317904 | 317904 | 2020-07-09 | Charleston | South Carolina | 45019 | 6699 | 51 |
321082 | 321082 | 2020-07-10 | Charleston | South Carolina | 45019 | 6961 | 52 |
324262 | 324262 | 2020-07-11 | Charleston | South Carolina | 45019 | 7272 | 59 |
327447 | 327447 | 2020-07-12 | Charleston | South Carolina | 45019 | 7555 | 60 |
330633 | 330633 | 2020-07-13 | Charleston | South Carolina | 45019 | 7835 | 61 |
333825 | 333825 | 2020-07-14 | Charleston | South Carolina | 45019 | 8250 | 67 |
337019 | 337019 | 2020-07-15 | Charleston | South Carolina | 45019 | 8466 | 69 |
340216 | 340216 | 2020-07-16 | Charleston | South Carolina | 45019 | 8677 | 81 |
343414 | 343414 | 2020-07-17 | Charleston | South Carolina | 45019 | 8971 | 80 |
346614 | 346614 | 2020-07-18 | Charleston | South Carolina | 45019 | 9098 | 86 |
349814 | 349814 | 2020-07-19 | Charleston | South Carolina | 45019 | 9437 | 87 |
353017 | 353017 | 2020-07-20 | Charleston | South Carolina | 45019 | 9623 | 88 |
356220 | 356220 | 2020-07-21 | Charleston | South Carolina | 45019 | 9785 | 103 |
359424 | 359424 | 2020-07-22 | Charleston | South Carolina | 45019 | 9968 | 117 |
362630 | 362630 | 2020-07-23 | Charleston | South Carolina | 45019 | 10134 | 120 |
365836 | 365836 | 2020-07-24 | Charleston | South Carolina | 45019 | 10355 | 120 |
369045 | 369045 | 2020-07-25 | Charleston | South Carolina | 45019 | 10503 | 132 |
372257 | 372257 | 2020-07-26 | Charleston | South Carolina | 45019 | 10625 | 135 |
375470 | 375470 | 2020-07-27 | Charleston | South Carolina | 45019 | 10740 | 135 |
378686 | 378686 | 2020-07-28 | Charleston | South Carolina | 45019 | 10920 | 144 |
381903 | 381903 | 2020-07-29 | Charleston | South Carolina | 45019 | 11125 | 154 |
385121 | 385121 | 2020-07-30 | Charleston | South Carolina | 45019 | 11260 | 158 |
388338 | 388338 | 2020-07-31 | Charleston | South Carolina | 45019 | 11345 | 162 |
391555 | 391555 | 2020-08-01 | Charleston | South Carolina | 45019 | 11471 | 165 |
394771 | 394771 | 2020-08-02 | Charleston | South Carolina | 45019 | 11594 | 168 |
397988 | 397988 | 2020-08-03 | Charleston | South Carolina | 45019 | 11714 | 171 |
401203 | 401203 | 2020-08-04 | Charleston | South Carolina | 45019 | 11814 | 178 |
404421 | 404421 | 2020-08-05 | Charleston | South Carolina | 45019 | 11926 | 182 |
407640 | 407640 | 2020-08-06 | Charleston | South Carolina | 45019 | 12019 | 190 |
410860 | 410860 | 2020-08-07 | Charleston | South Carolina | 45019 | 12118 | 189 |
414080 | 414080 | 2020-08-08 | Charleston | South Carolina | 45019 | 12213 | 194 |
417301 | 417301 | 2020-08-09 | Charleston | South Carolina | 45019 | 12324 | 194 |
420521 | 420521 | 2020-08-10 | Charleston | South Carolina | 45019 | 12377 | 196 |
423744 | 423744 | 2020-08-11 | Charleston | South Carolina | 45019 | 12454 | 203 |
426967 | 426967 | 2020-08-12 | Charleston | South Carolina | 45019 | 12555 | 206 |
430192 | 430192 | 2020-08-13 | Charleston | South Carolina | 45019 | 12631 | 209 |
433418 | 433418 | 2020-08-14 | Charleston | South Carolina | 45019 | 12726 | 210 |
436645 | 436645 | 2020-08-15 | Charleston | South Carolina | 45019 | 12821 | 213 |
439870 | 439870 | 2020-08-16 | Charleston | South Carolina | 45019 | 12879 | 214 |
443097 | 443097 | 2020-08-17 | Charleston | South Carolina | 45019 | 12911 | 214 |
446323 | 446323 | 2020-08-18 | Charleston | South Carolina | 45019 | 12956 | 217 |
449551 | 449551 | 2020-08-19 | Charleston | South Carolina | 45019 | 13062 | 217 |
452779 | 452779 | 2020-08-20 | Charleston | South Carolina | 45019 | 13111 | 217 |
456007 | 456007 | 2020-08-21 | Charleston | South Carolina | 45019 | 13156 | 221 |
459235 | 459235 | 2020-08-22 | Charleston | South Carolina | 45019 | 13257 | 226 |
462463 | 462463 | 2020-08-23 | Charleston | South Carolina | 45019 | 13320 | 226 |
465692 | 465692 | 2020-08-24 | Charleston | South Carolina | 45019 | 13405 | 226 |
468920 | 468920 | 2020-08-25 | Charleston | South Carolina | 45019 | 13440 | 228 |
472152 | 472152 | 2020-08-26 | Charleston | South Carolina | 45019 | 13478 | 230 |
475386 | 475386 | 2020-08-27 | Charleston | South Carolina | 45019 | 13503 | 231 |
478619 | 478619 | 2020-08-28 | Charleston | South Carolina | 45019 | 13679 | 232 |
481853 | 481853 | 2020-08-29 | Charleston | South Carolina | 45019 | 13897 | 235 |
485088 | 485088 | 2020-08-30 | Charleston | South Carolina | 45019 | 14000 | 236 |
488321 | 488321 | 2020-08-31 | Charleston | South Carolina | 45019 | 14053 | 238 |
491554 | 491554 | 2020-09-01 | Charleston | South Carolina | 45019 | 14105 | 239 |
494788 | 494788 | 2020-09-02 | Charleston | South Carolina | 45019 | 14151 | 242 |
498021 | 498021 | 2020-09-03 | Charleston | South Carolina | 45019 | 14232 | 242 |
501255 | 501255 | 2020-09-04 | Charleston | South Carolina | 45019 | 14325 | 244 |
504489 | 504489 | 2020-09-05 | Charleston | South Carolina | 45019 | 14391 | 246 |
507721 | 507721 | 2020-09-06 | Charleston | South Carolina | 45019 | 14440 | 246 |
510954 | 510954 | 2020-09-07 | Charleston | South Carolina | 45019 | 14485 | 247 |
514187 | 514187 | 2020-09-08 | Charleston | South Carolina | 45019 | 14509 | 249 |
517422 | 517422 | 2020-09-09 | Charleston | South Carolina | 45019 | 14529 | 249 |
520658 | 520658 | 2020-09-10 | Charleston | South Carolina | 45019 | 14550 | 249 |
523894 | 523894 | 2020-09-11 | Charleston | South Carolina | 45019 | 14661 | 252 |
527130 | 527130 | 2020-09-12 | Charleston | South Carolina | 45019 | 14699 | 252 |
530367 | 530367 | 2020-09-13 | Charleston | South Carolina | 45019 | 15124 | 253 |
533602 | 533602 | 2020-09-14 | Charleston | South Carolina | 45019 | 15167 | 253 |
536838 | 536838 | 2020-09-15 | Charleston | South Carolina | 45019 | 15191 | 254 |
540075 | 540075 | 2020-09-16 | Charleston | South Carolina | 45019 | 15230 | 255 |
543311 | 543311 | 2020-09-17 | Charleston | South Carolina | 45019 | 15332 | 255 |
546548 | 546548 | 2020-09-18 | Charleston | South Carolina | 45019 | 15378 | 255 |
549787 | 549787 | 2020-09-19 | Charleston | South Carolina | 45019 | 15455 | 256 |
553026 | 553026 | 2020-09-20 | Charleston | South Carolina | 45019 | 15489 | 256 |
556263 | 556263 | 2020-09-21 | Charleston | South Carolina | 45019 | 15500 | 257 |
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);