johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
14,215 rows where country_or_region = "US" and province_or_state = "Massachusetts" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754503 | 2754503 | 2022-12-29 | US | Massachusetts | Barnstable | 25001 | 47448 | 722 | 0 | 41.72980578 | -70.28854339 | 2022-12-30 04:21:04 | Barnstable, Massachusetts, US | |
2754504 | 2754504 | 2022-12-29 | US | Massachusetts | Berkshire | 25003 | 34037 | 443 | 0 | 42.37428441 | -73.20524838 | 2022-12-30 04:21:04 | Berkshire, Massachusetts, US | |
2754505 | 2754505 | 2022-12-29 | US | Massachusetts | Bristol | 25005 | 177503 | 2413 | 0 | 41.79228404 | -71.10872211 | 2022-12-30 04:21:04 | Bristol, Massachusetts, US | |
2754506 | 2754506 | 2022-12-29 | US | Massachusetts | Dukes and Nantucket | 8167 | 24 | 0 | 41.40674725 | -70.68763497 | 2022-12-30 04:21:04 | Dukes and Nantucket, Massachusetts, US | ||
2754507 | 2754507 | 2022-12-29 | US | Massachusetts | Essex | 25009 | 250310 | 3070 | 0 | 42.6687626 | -70.94687179 | 2022-12-30 04:21:04 | Essex, Massachusetts, US | |
2754508 | 2754508 | 2022-12-29 | US | Massachusetts | Franklin | 25011 | 14352 | 177 | 0 | 42.58119713 | -72.58602547 | 2022-12-30 04:21:04 | Franklin, Massachusetts, US | |
2754509 | 2754509 | 2022-12-29 | US | Massachusetts | Hampden | 25013 | 166819 | 2033 | 0 | 42.13440424 | -72.63235561 | 2022-12-30 04:21:04 | Hampden, Massachusetts, US | |
2754510 | 2754510 | 2022-12-29 | US | Massachusetts | Hampshire | 25015 | 38592 | 423 | 0 | 42.33997957 | -72.65898478 | 2022-12-30 04:21:04 | Hampshire, Massachusetts, US | |
2754511 | 2754511 | 2022-12-29 | US | Massachusetts | Middlesex | 25017 | 425257 | 4526 | 0 | 42.48607732 | -71.39049229 | 2022-12-30 04:21:04 | Middlesex, Massachusetts, US | |
2754512 | 2754512 | 2022-12-29 | US | Massachusetts | Norfolk | 25021 | 168799 | 2172 | 0 | 42.16073095 | -71.20530408 | 2022-12-30 04:21:04 | Norfolk, Massachusetts, US | |
2754513 | 2754513 | 2022-12-29 | US | Massachusetts | Plymouth | 25023 | 139314 | 1858 | 0 | 41.94070556 | -70.80802823 | 2022-12-30 04:21:04 | Plymouth, Massachusetts, US | |
2754514 | 2754514 | 2022-12-29 | US | Massachusetts | Suffolk | 25025 | 261865 | 2149 | 0 | 42.3279514 | -71.07850442 | 2022-12-30 04:21:04 | Suffolk, Massachusetts, US | |
2754515 | 2754515 | 2022-12-29 | US | Massachusetts | Unassigned | 90025 | 188257 | 5 | 0 | 42.6687626 | 0.0 | 2022-12-30 04:21:04 | Unassigned, Massachusetts, US | |
2754516 | 2754516 | 2022-12-29 | US | Massachusetts | Worcester | 25027 | 234166 | 2925 | 0 | 42.35026951 | -71.90493363 | 2022-12-30 04:21:04 | Worcester, Massachusetts, US | |
1075509 | 1075509 | 2022-12-28 | US | Massachusetts | Barnstable | 25001 | 47159 | 717 | 0 | 41.72980578 | -70.28854339 | 2022-12-29 04:21:01 | Barnstable, Massachusetts, US | |
1075510 | 1075510 | 2022-12-28 | US | Massachusetts | Berkshire | 25003 | 33857 | 440 | 0 | 42.37428441 | -73.20524838 | 2022-12-29 04:21:01 | Berkshire, Massachusetts, US | |
1075511 | 1075511 | 2022-12-28 | US | Massachusetts | Bristol | 25005 | 176824 | 2393 | 0 | 41.79228404 | -71.10872211 | 2022-12-29 04:21:01 | Bristol, Massachusetts, US | |
1075512 | 1075512 | 2022-12-28 | US | Massachusetts | Dukes and Nantucket | 8141 | 24 | 0 | 41.40674725 | -70.68763497 | 2022-12-29 04:21:01 | Dukes and Nantucket, Massachusetts, US | ||
1075513 | 1075513 | 2022-12-28 | US | Massachusetts | Essex | 25009 | 249144 | 3047 | 0 | 42.6687626 | -70.94687179 | 2022-12-29 04:21:01 | Essex, Massachusetts, US | |
1075514 | 1075514 | 2022-12-28 | US | Massachusetts | Franklin | 25011 | 14281 | 176 | 0 | 42.58119713 | -72.58602547 | 2022-12-29 04:21:01 | Franklin, Massachusetts, US | |
1075515 | 1075515 | 2022-12-28 | US | Massachusetts | Hampden | 25013 | 166000 | 2018 | 0 | 42.13440424 | -72.63235561 | 2022-12-29 04:21:01 | Hampden, Massachusetts, US | |
1075516 | 1075516 | 2022-12-28 | US | Massachusetts | Hampshire | 25015 | 38415 | 419 | 0 | 42.33997957 | -72.65898478 | 2022-12-29 04:21:01 | Hampshire, Massachusetts, US | |
1075517 | 1075517 | 2022-12-28 | US | Massachusetts | Middlesex | 25017 | 423323 | 4498 | 0 | 42.48607732 | -71.39049229 | 2022-12-29 04:21:01 | Middlesex, Massachusetts, US | |
1075518 | 1075518 | 2022-12-28 | US | Massachusetts | Norfolk | 25021 | 168159 | 2162 | 0 | 42.16073095 | -71.20530408 | 2022-12-29 04:21:01 | Norfolk, Massachusetts, US | |
1075519 | 1075519 | 2022-12-28 | US | Massachusetts | Plymouth | 25023 | 138779 | 1848 | 0 | 41.94070556 | -70.80802823 | 2022-12-29 04:21:01 | Plymouth, Massachusetts, US | |
1075520 | 1075520 | 2022-12-28 | US | Massachusetts | Suffolk | 25025 | 260969 | 2142 | 0 | 42.3279514 | -71.07850442 | 2022-12-29 04:21:01 | Suffolk, Massachusetts, US | |
1075521 | 1075521 | 2022-12-28 | US | Massachusetts | Unassigned | 90025 | 186646 | 5 | 0 | 42.6687626 | 0.0 | 2022-12-29 04:21:01 | Unassigned, Massachusetts, US | |
1075522 | 1075522 | 2022-12-28 | US | Massachusetts | Worcester | 25027 | 233270 | 2904 | 0 | 42.35026951 | -71.90493363 | 2022-12-29 04:21:01 | Worcester, Massachusetts, US | |
329506 | 329506 | 2022-12-27 | US | Massachusetts | Barnstable | 25001 | 47159 | 717 | 0 | 41.72980578 | -70.28854339 | 2022-12-28 04:21:04 | Barnstable, Massachusetts, US | |
329507 | 329507 | 2022-12-27 | US | Massachusetts | Berkshire | 25003 | 33857 | 440 | 0 | 42.37428441 | -73.20524838 | 2022-12-28 04:21:04 | Berkshire, Massachusetts, US | |
329508 | 329508 | 2022-12-27 | US | Massachusetts | Bristol | 25005 | 176824 | 2393 | 0 | 41.79228404 | -71.10872211 | 2022-12-28 04:21:04 | Bristol, Massachusetts, US | |
329509 | 329509 | 2022-12-27 | US | Massachusetts | Dukes and Nantucket | 8141 | 24 | 0 | 41.40674725 | -70.68763497 | 2022-12-28 04:21:04 | Dukes and Nantucket, Massachusetts, US | ||
329510 | 329510 | 2022-12-27 | US | Massachusetts | Essex | 25009 | 249144 | 3047 | 0 | 42.6687626 | -70.94687179 | 2022-12-28 04:21:04 | Essex, Massachusetts, US | |
329511 | 329511 | 2022-12-27 | US | Massachusetts | Franklin | 25011 | 14281 | 176 | 0 | 42.58119713 | -72.58602547 | 2022-12-28 04:21:04 | Franklin, Massachusetts, US | |
329512 | 329512 | 2022-12-27 | US | Massachusetts | Hampden | 25013 | 166000 | 2018 | 0 | 42.13440424 | -72.63235561 | 2022-12-28 04:21:04 | Hampden, Massachusetts, US | |
329513 | 329513 | 2022-12-27 | US | Massachusetts | Hampshire | 25015 | 38415 | 419 | 0 | 42.33997957 | -72.65898478 | 2022-12-28 04:21:04 | Hampshire, Massachusetts, US | |
329514 | 329514 | 2022-12-27 | US | Massachusetts | Middlesex | 25017 | 423323 | 4498 | 0 | 42.48607732 | -71.39049229 | 2022-12-28 04:21:04 | Middlesex, Massachusetts, US | |
329515 | 329515 | 2022-12-27 | US | Massachusetts | Norfolk | 25021 | 168159 | 2162 | 0 | 42.16073095 | -71.20530408 | 2022-12-28 04:21:04 | Norfolk, Massachusetts, US | |
329516 | 329516 | 2022-12-27 | US | Massachusetts | Plymouth | 25023 | 138779 | 1848 | 0 | 41.94070556 | -70.80802823 | 2022-12-28 04:21:04 | Plymouth, Massachusetts, US | |
329517 | 329517 | 2022-12-27 | US | Massachusetts | Suffolk | 25025 | 260969 | 2142 | 0 | 42.3279514 | -71.07850442 | 2022-12-28 04:21:04 | Suffolk, Massachusetts, US | |
329518 | 329518 | 2022-12-27 | US | Massachusetts | Unassigned | 90025 | 186646 | 5 | 0 | 42.6687626 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Massachusetts, US | |
329519 | 329519 | 2022-12-27 | US | Massachusetts | Worcester | 25027 | 233270 | 2904 | 0 | 42.35026951 | -71.90493363 | 2022-12-28 04:21:04 | Worcester, Massachusetts, US | |
219579 | 219579 | 2022-12-26 | US | Massachusetts | Barnstable | 25001 | 47159 | 717 | 0 | 41.72980578 | -70.28854339 | 2022-12-27 04:21:07 | Barnstable, Massachusetts, US | |
219580 | 219580 | 2022-12-26 | US | Massachusetts | Berkshire | 25003 | 33857 | 440 | 0 | 42.37428441 | -73.20524838 | 2022-12-27 04:21:07 | Berkshire, Massachusetts, US | |
219581 | 219581 | 2022-12-26 | US | Massachusetts | Bristol | 25005 | 176824 | 2393 | 0 | 41.79228404 | -71.10872211 | 2022-12-27 04:21:07 | Bristol, Massachusetts, US | |
219582 | 219582 | 2022-12-26 | US | Massachusetts | Dukes and Nantucket | 8141 | 24 | 0 | 41.40674725 | -70.68763497 | 2022-12-27 04:21:07 | Dukes and Nantucket, Massachusetts, US | ||
219583 | 219583 | 2022-12-26 | US | Massachusetts | Essex | 25009 | 249144 | 3047 | 0 | 42.6687626 | -70.94687179 | 2022-12-27 04:21:07 | Essex, Massachusetts, US | |
219584 | 219584 | 2022-12-26 | US | Massachusetts | Franklin | 25011 | 14281 | 176 | 0 | 42.58119713 | -72.58602547 | 2022-12-27 04:21:07 | Franklin, Massachusetts, US | |
219585 | 219585 | 2022-12-26 | US | Massachusetts | Hampden | 25013 | 166000 | 2018 | 0 | 42.13440424 | -72.63235561 | 2022-12-27 04:21:07 | Hampden, Massachusetts, US | |
219586 | 219586 | 2022-12-26 | US | Massachusetts | Hampshire | 25015 | 38415 | 419 | 0 | 42.33997957 | -72.65898478 | 2022-12-27 04:21:07 | Hampshire, Massachusetts, US | |
219587 | 219587 | 2022-12-26 | US | Massachusetts | Middlesex | 25017 | 423323 | 4498 | 0 | 42.48607732 | -71.39049229 | 2022-12-27 04:21:07 | Middlesex, Massachusetts, US | |
219588 | 219588 | 2022-12-26 | US | Massachusetts | Norfolk | 25021 | 168159 | 2162 | 0 | 42.16073095 | -71.20530408 | 2022-12-27 04:21:07 | Norfolk, Massachusetts, US | |
219589 | 219589 | 2022-12-26 | US | Massachusetts | Plymouth | 25023 | 138779 | 1848 | 0 | 41.94070556 | -70.80802823 | 2022-12-27 04:21:07 | Plymouth, Massachusetts, US | |
219590 | 219590 | 2022-12-26 | US | Massachusetts | Suffolk | 25025 | 260969 | 2142 | 0 | 42.3279514 | -71.07850442 | 2022-12-27 04:21:07 | Suffolk, Massachusetts, US | |
219591 | 219591 | 2022-12-26 | US | Massachusetts | Unassigned | 90025 | 186646 | 5 | 0 | 42.6687626 | 0.0 | 2022-12-27 04:21:07 | Unassigned, Massachusetts, US | |
219592 | 219592 | 2022-12-26 | US | Massachusetts | Worcester | 25027 | 233270 | 2904 | 0 | 42.35026951 | -71.90493363 | 2022-12-27 04:21:07 | Worcester, Massachusetts, US | |
3224036 | 3224036 | 2022-12-25 | US | Massachusetts | Barnstable | 25001 | 47159 | 717 | 0 | 41.72980578 | -70.28854339 | 2022-12-26 04:21:06 | Barnstable, Massachusetts, US | |
3224037 | 3224037 | 2022-12-25 | US | Massachusetts | Berkshire | 25003 | 33857 | 440 | 0 | 42.37428441 | -73.20524838 | 2022-12-26 04:21:06 | Berkshire, Massachusetts, US | |
3224038 | 3224038 | 2022-12-25 | US | Massachusetts | Bristol | 25005 | 176824 | 2393 | 0 | 41.79228404 | -71.10872211 | 2022-12-26 04:21:06 | Bristol, Massachusetts, US | |
3224039 | 3224039 | 2022-12-25 | US | Massachusetts | Dukes and Nantucket | 8141 | 24 | 0 | 41.40674725 | -70.68763497 | 2022-12-26 04:21:06 | Dukes and Nantucket, Massachusetts, US | ||
3224040 | 3224040 | 2022-12-25 | US | Massachusetts | Essex | 25009 | 249144 | 3047 | 0 | 42.6687626 | -70.94687179 | 2022-12-26 04:21:06 | Essex, Massachusetts, US | |
3224041 | 3224041 | 2022-12-25 | US | Massachusetts | Franklin | 25011 | 14281 | 176 | 0 | 42.58119713 | -72.58602547 | 2022-12-26 04:21:06 | Franklin, Massachusetts, US | |
3224042 | 3224042 | 2022-12-25 | US | Massachusetts | Hampden | 25013 | 166000 | 2018 | 0 | 42.13440424 | -72.63235561 | 2022-12-26 04:21:06 | Hampden, Massachusetts, US | |
3224043 | 3224043 | 2022-12-25 | US | Massachusetts | Hampshire | 25015 | 38415 | 419 | 0 | 42.33997957 | -72.65898478 | 2022-12-26 04:21:06 | Hampshire, Massachusetts, US | |
3224044 | 3224044 | 2022-12-25 | US | Massachusetts | Middlesex | 25017 | 423323 | 4498 | 0 | 42.48607732 | -71.39049229 | 2022-12-26 04:21:06 | Middlesex, Massachusetts, US | |
3224045 | 3224045 | 2022-12-25 | US | Massachusetts | Norfolk | 25021 | 168159 | 2162 | 0 | 42.16073095 | -71.20530408 | 2022-12-26 04:21:06 | Norfolk, Massachusetts, US | |
3224046 | 3224046 | 2022-12-25 | US | Massachusetts | Plymouth | 25023 | 138779 | 1848 | 0 | 41.94070556 | -70.80802823 | 2022-12-26 04:21:06 | Plymouth, Massachusetts, US | |
3224047 | 3224047 | 2022-12-25 | US | Massachusetts | Suffolk | 25025 | 260969 | 2142 | 0 | 42.3279514 | -71.07850442 | 2022-12-26 04:21:06 | Suffolk, Massachusetts, US | |
3224048 | 3224048 | 2022-12-25 | US | Massachusetts | Unassigned | 90025 | 186646 | 5 | 0 | 42.6687626 | 0.0 | 2022-12-26 04:21:06 | Unassigned, Massachusetts, US | |
3224049 | 3224049 | 2022-12-25 | US | Massachusetts | Worcester | 25027 | 233270 | 2904 | 0 | 42.35026951 | -71.90493363 | 2022-12-26 04:21:06 | Worcester, Massachusetts, US | |
1019950 | 1019950 | 2022-12-24 | US | Massachusetts | Barnstable | 25001 | 47159 | 717 | 0 | 41.72980578 | -70.28854339 | 2022-12-25 04:21:04 | Barnstable, Massachusetts, US | |
1019951 | 1019951 | 2022-12-24 | US | Massachusetts | Berkshire | 25003 | 33857 | 440 | 0 | 42.37428441 | -73.20524838 | 2022-12-25 04:21:04 | Berkshire, Massachusetts, US | |
1019952 | 1019952 | 2022-12-24 | US | Massachusetts | Bristol | 25005 | 176824 | 2393 | 0 | 41.79228404 | -71.10872211 | 2022-12-25 04:21:04 | Bristol, Massachusetts, US | |
1019953 | 1019953 | 2022-12-24 | US | Massachusetts | Dukes and Nantucket | 8141 | 24 | 0 | 41.40674725 | -70.68763497 | 2022-12-25 04:21:04 | Dukes and Nantucket, Massachusetts, US | ||
1019954 | 1019954 | 2022-12-24 | US | Massachusetts | Essex | 25009 | 249144 | 3047 | 0 | 42.6687626 | -70.94687179 | 2022-12-25 04:21:04 | Essex, Massachusetts, US | |
1019955 | 1019955 | 2022-12-24 | US | Massachusetts | Franklin | 25011 | 14281 | 176 | 0 | 42.58119713 | -72.58602547 | 2022-12-25 04:21:04 | Franklin, Massachusetts, US | |
1019956 | 1019956 | 2022-12-24 | US | Massachusetts | Hampden | 25013 | 166000 | 2018 | 0 | 42.13440424 | -72.63235561 | 2022-12-25 04:21:04 | Hampden, Massachusetts, US | |
1019957 | 1019957 | 2022-12-24 | US | Massachusetts | Hampshire | 25015 | 38415 | 419 | 0 | 42.33997957 | -72.65898478 | 2022-12-25 04:21:04 | Hampshire, Massachusetts, US | |
1019958 | 1019958 | 2022-12-24 | US | Massachusetts | Middlesex | 25017 | 423323 | 4498 | 0 | 42.48607732 | -71.39049229 | 2022-12-25 04:21:04 | Middlesex, Massachusetts, US | |
1019959 | 1019959 | 2022-12-24 | US | Massachusetts | Norfolk | 25021 | 168159 | 2162 | 0 | 42.16073095 | -71.20530408 | 2022-12-25 04:21:04 | Norfolk, Massachusetts, US | |
1019960 | 1019960 | 2022-12-24 | US | Massachusetts | Plymouth | 25023 | 138779 | 1848 | 0 | 41.94070556 | -70.80802823 | 2022-12-25 04:21:04 | Plymouth, Massachusetts, US | |
1019961 | 1019961 | 2022-12-24 | US | Massachusetts | Suffolk | 25025 | 260969 | 2142 | 0 | 42.3279514 | -71.07850442 | 2022-12-25 04:21:04 | Suffolk, Massachusetts, US | |
1019962 | 1019962 | 2022-12-24 | US | Massachusetts | Unassigned | 90025 | 186646 | 5 | 0 | 42.6687626 | 0.0 | 2022-12-25 04:21:04 | Unassigned, Massachusetts, US | |
1019963 | 1019963 | 2022-12-24 | US | Massachusetts | Worcester | 25027 | 233270 | 2904 | 0 | 42.35026951 | -71.90493363 | 2022-12-25 04:21:04 | Worcester, Massachusetts, US | |
691973 | 691973 | 2022-12-23 | US | Massachusetts | Barnstable | 25001 | 47159 | 717 | 0 | 41.72980578 | -70.28854339 | 2022-12-24 04:21:02 | Barnstable, Massachusetts, US | |
691974 | 691974 | 2022-12-23 | US | Massachusetts | Berkshire | 25003 | 33857 | 440 | 0 | 42.37428441 | -73.20524838 | 2022-12-24 04:21:02 | Berkshire, Massachusetts, US | |
691975 | 691975 | 2022-12-23 | US | Massachusetts | Bristol | 25005 | 176824 | 2393 | 0 | 41.79228404 | -71.10872211 | 2022-12-24 04:21:02 | Bristol, Massachusetts, US | |
691976 | 691976 | 2022-12-23 | US | Massachusetts | Dukes and Nantucket | 8141 | 24 | 0 | 41.40674725 | -70.68763497 | 2022-12-24 04:21:02 | Dukes and Nantucket, Massachusetts, US | ||
691977 | 691977 | 2022-12-23 | US | Massachusetts | Essex | 25009 | 249144 | 3047 | 0 | 42.6687626 | -70.94687179 | 2022-12-24 04:21:02 | Essex, Massachusetts, US | |
691978 | 691978 | 2022-12-23 | US | Massachusetts | Franklin | 25011 | 14281 | 176 | 0 | 42.58119713 | -72.58602547 | 2022-12-24 04:21:02 | Franklin, Massachusetts, US | |
691979 | 691979 | 2022-12-23 | US | Massachusetts | Hampden | 25013 | 166000 | 2018 | 0 | 42.13440424 | -72.63235561 | 2022-12-24 04:21:02 | Hampden, Massachusetts, US | |
691980 | 691980 | 2022-12-23 | US | Massachusetts | Hampshire | 25015 | 38415 | 419 | 0 | 42.33997957 | -72.65898478 | 2022-12-24 04:21:02 | Hampshire, Massachusetts, US | |
691981 | 691981 | 2022-12-23 | US | Massachusetts | Middlesex | 25017 | 423323 | 4498 | 0 | 42.48607732 | -71.39049229 | 2022-12-24 04:21:02 | Middlesex, Massachusetts, US | |
691982 | 691982 | 2022-12-23 | US | Massachusetts | Norfolk | 25021 | 168159 | 2162 | 0 | 42.16073095 | -71.20530408 | 2022-12-24 04:21:02 | Norfolk, Massachusetts, US | |
691983 | 691983 | 2022-12-23 | US | Massachusetts | Plymouth | 25023 | 138779 | 1848 | 0 | 41.94070556 | -70.80802823 | 2022-12-24 04:21:02 | Plymouth, Massachusetts, US | |
691984 | 691984 | 2022-12-23 | US | Massachusetts | Suffolk | 25025 | 260969 | 2142 | 0 | 42.3279514 | -71.07850442 | 2022-12-24 04:21:02 | Suffolk, Massachusetts, US | |
691985 | 691985 | 2022-12-23 | US | Massachusetts | Unassigned | 90025 | 186646 | 5 | 0 | 42.6687626 | 0.0 | 2022-12-24 04:21:02 | Unassigned, Massachusetts, US | |
691986 | 691986 | 2022-12-23 | US | Massachusetts | Worcester | 25027 | 233270 | 2904 | 0 | 42.35026951 | -71.90493363 | 2022-12-24 04:21:02 | Worcester, Massachusetts, US | |
2181183 | 2181183 | 2022-12-22 | US | Massachusetts | Barnstable | 25001 | 47159 | 717 | 0 | 41.72980578 | -70.28854339 | 2022-12-23 04:21:04 | Barnstable, Massachusetts, US | |
2181184 | 2181184 | 2022-12-22 | US | Massachusetts | Berkshire | 25003 | 33857 | 440 | 0 | 42.37428441 | -73.20524838 | 2022-12-23 04:21:04 | Berkshire, Massachusetts, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);