states_current
Data source: Big Local News · About: big-local-datasette
3 rows where totalTestResultsSource = "totalTestsPeopleViral"
This data as json, copyable, CSV (advanced)
Suggested facets: deathIncrease, dateModified (date), dateChecked (date)
| Link | rowid ▼ | date | state | positive | probableCases | negative | pending | totalTestResultsSource | totalTestResults | hospitalizedCurrently | hospitalizedCumulative | inIcuCurrently | inIcuCumulative | onVentilatorCurrently | onVentilatorCumulative | recovered | lastUpdateEt | dateModified | checkTimeEt | death | hospitalized | hospitalizedDischarged | dateChecked | totalTestsViral | positiveTestsViral | negativeTestsViral | positiveCasesViral | deathConfirmed | deathProbable | totalTestEncountersViral | totalTestsPeopleViral | totalTestsAntibody | positiveTestsAntibody | negativeTestsAntibody | totalTestsPeopleAntibody | positiveTestsPeopleAntibody | negativeTestsPeopleAntibody | totalTestsPeopleAntigen | positiveTestsPeopleAntigen | totalTestsAntigen | positiveTestsAntigen | fips | positiveIncrease | negativeIncrease | total | totalTestResultsIncrease | posNeg | dataQualityGrade | deathIncrease | hospitalizedIncrease | hash | commercialScore | negativeRegularScore | negativeScore | positiveScore | score | grade |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 2 | 20210301 | AL | 493769 | 106836 | 1905141 | totalTestsPeopleViral | 2292074 | 651 | 45648 | 2651 | 1508 | 285130 | 3/1/2021 11:00 | 2021-03-01T11:00:00Z | 03/01 06:00 | 9931 | 45648 | 2021-03-01T11:00:00Z | 386933 | 7789 | 2142 | 2292074 | 117746 | 1 | 517 | 1450 | 2398910 | 1858 | 2398910 | 2.0 | 220.0 | 3476d5a26b6a3586ec04d598083a69d5cdda14ba | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
| 16 | 16 | 20210301 | ID | 171140 | 32317 | 500096 | totalTestsPeopleViral | 638919 | 162 | 7076 | 35 | 1231 | 94230 | 2/27/2021 19:06 | 2021-02-27T19:06:00Z | 02/27 14:06 | 1860 | 7076 | 2021-02-27T19:06:00Z | 1083384 | 138823 | 1634 | 226 | 638919 | 123809 | 16 | 0 | 0 | 671236 | 0 | 671236 | 0.0 | 0.0 | ed541174e3aaa95276628cfa039c6a4182164f3a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
| 46 | 46 | 20210301 | SD | 112470 | 12597 | 310347 | totalTestsPeopleViral | 422817 | 92 | 6632 | 15 | 7 | 108664 | 2/28/2021 14:00 | 2021-02-28T14:00:00Z | 02/28 09:00 | 1888 | 6632 | 2021-02-28T14:00:00Z | 972040 | 99873 | 422817 | 46 | 43 | 225 | 422817 | 268 | 422817 | 0.0 | 6.0 | 1342c6377a961f305bb02a78f18edb57369fff0a | 0 | 0 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [states_current] ( [date] INTEGER, [state] TEXT, [positive] INTEGER, [probableCases] INTEGER, [negative] INTEGER, [pending] INTEGER, [totalTestResultsSource] TEXT, [totalTestResults] INTEGER, [hospitalizedCurrently] INTEGER, [hospitalizedCumulative] INTEGER, [inIcuCurrently] INTEGER, [inIcuCumulative] INTEGER, [onVentilatorCurrently] INTEGER, [onVentilatorCumulative] INTEGER, [recovered] INTEGER, [lastUpdateEt] TEXT, [dateModified] TEXT, [checkTimeEt] TEXT, [death] INTEGER, [hospitalized] INTEGER, [hospitalizedDischarged] INTEGER, [dateChecked] TEXT, [totalTestsViral] INTEGER, [positiveTestsViral] INTEGER, [negativeTestsViral] INTEGER, [positiveCasesViral] INTEGER, [deathConfirmed] INTEGER, [deathProbable] INTEGER, [totalTestEncountersViral] INTEGER, [totalTestsPeopleViral] INTEGER, [totalTestsAntibody] INTEGER, [positiveTestsAntibody] INTEGER, [negativeTestsAntibody] INTEGER, [totalTestsPeopleAntibody] INTEGER, [positiveTestsPeopleAntibody] INTEGER, [negativeTestsPeopleAntibody] INTEGER, [totalTestsPeopleAntigen] INTEGER, [positiveTestsPeopleAntigen] INTEGER, [totalTestsAntigen] INTEGER, [positiveTestsAntigen] INTEGER, [fips] INTEGER, [positiveIncrease] INTEGER, [negativeIncrease] INTEGER, [total] INTEGER, [totalTestResultsIncrease] INTEGER, [posNeg] INTEGER, [dataQualityGrade] TEXT, [deathIncrease] FLOAT, [hospitalizedIncrease] FLOAT, [hash] TEXT, [commercialScore] INTEGER, [negativeRegularScore] INTEGER, [negativeScore] INTEGER, [positiveScore] INTEGER, [score] INTEGER, [grade] TEXT );