states_current
Data source: Big Local News · About: big-local-datasette
12 rows where deathIncrease = 0
This data as json, copyable, CSV (advanced)
Suggested facets: pending, hospitalizedCurrently, hospitalizedCumulative, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, lastUpdateEt, dateModified, checkTimeEt, hospitalized, dateChecked, totalTestsViral, positiveTestsViral, negativeTestsViral, positiveCasesViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, totalTestsPeopleAntigen, positiveTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, positiveIncrease, negativeIncrease, totalTestResultsSource, totalTestResultsIncrease, hospitalizedIncrease, dateModified (date), dateChecked (date)
Link | rowid ▼ | date | state | positive | negative | pending | totalTestResults | hospitalizedCurrently | hospitalizedCumulative | inIcuCurrently | inIcuCumulative | onVentilatorCurrently | onVentilatorCumulative | recovered | dataQualityGrade | lastUpdateEt | dateModified | checkTimeEt | death | hospitalized | dateChecked | totalTestsViral | positiveTestsViral | negativeTestsViral | positiveCasesViral | deathConfirmed | deathProbable | totalTestEncountersViral | totalTestsPeopleViral | totalTestsAntibody | positiveTestsAntibody | negativeTestsAntibody | totalTestsPeopleAntibody | positiveTestsPeopleAntibody | negativeTestsPeopleAntibody | totalTestsPeopleAntigen | positiveTestsPeopleAntigen | totalTestsAntigen | positiveTestsAntigen | fips | positiveIncrease | negativeIncrease | total | totalTestResultsSource | totalTestResultsIncrease | posNeg | deathIncrease | hospitalizedIncrease | hash | commercialScore | negativeRegularScore | negativeScore | positiveScore | score | grade |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
4 | 4 | 20200926 | AS | 0 | 1571 | 1571 | D | 9/1/2020 00:00 | 2020-09-01T00:00:00Z | 08/31 20:00 | 0 | 2020-09-01T00:00:00Z | 1571 | 0 | 60 | 0 | 0 | 1571 | posNeg | 0 | 1571 | 0 | 0 | b9eccb7369bdc4ee75708c7a892c5437ab915d83 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
8 | 8 | 20200926 | CT | 56587 | 1462564 | 1519151 | 76 | 11560 | 9310 | B | 9/24/2020 20:30 | 2020-09-24T20:30:00Z | 09/24 16:30 | 4501 | 11560 | 2020-09-24T20:30:00Z | 1516780 | 54216 | 3604 | 897 | 9 | 0 | 0 | 1519151 | posNeg | 0 | 1519151 | 0 | 0 | 597a6f3bd03d5e8297830e769c3da2cb90e767e7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
19 | 19 | 20200926 | KS | 56592 | 446178 | 502770 | 343 | 2816 | 121 | 768 | 34 | 250 | 2039 | A+ | 9/25/2020 10:00 | 2020-09-25T10:00:00Z | 09/25 06:00 | 632 | 2816 | 2020-09-25T10:00:00Z | 502770 | 20 | 0 | 0 | 502770 | posNeg | 0 | 502770 | 0 | 0 | 1468f023cf5cebe6e0d2f0752a5b054eecc06b87 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
21 | 21 | 20200926 | LA | 165152 | 2090913 | 2256065 | 570 | 86 | 149640 | A | 9/25/2020 13:00 | 2020-09-25T13:00:00Z | 09/25 09:00 | 5444 | 2020-09-25T13:00:00Z | 163928 | 5262 | 182 | 2254841 | 22 | 0 | 0 | 2256065 | posNeg | 0 | 2256065 | 0 | 0 | bda77e8fe6fd07aa1abd19dfbcfc5e00573b8f1f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
24 | 24 | 20200926 | ME | 5260 | 401159 | 406419 | 8 | 443 | 1 | 0 | 4538 | A+ | 9/25/2020 23:59 | 2020-09-25T23:59:00Z | 09/25 19:59 | 140 | 443 | 2020-09-25T23:59:00Z | 405850 | 6490 | 399070 | 4713 | 139 | 1 | 10270 | 516 | 9740 | 23 | 25 | 0 | 406419 | posNeg | 25 | 406419 | 0 | 1 | 7ed34c8487da7bfb9b9473f129d8e5a25a1c0056 | 0 | 0 | 0 | 0 | 0 | |||||||||||||
28 | 28 | 20200926 | MP | 69 | 14776 | 14845 | 4 | 29 | D | 9/25/2020 00:00 | 2020-09-25T00:00:00Z | 09/24 20:00 | 2 | 4 | 2020-09-25T00:00:00Z | 19835 | 69 | 2 | 14845 | 69 | 0 | 0 | 14845 | posNeg | 0 | 14845 | 0 | 0 | 6fdb4898ec2dbbb6eafe41b19ae56eff50411718 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
32 | 32 | 20200926 | ND | 20380 | 215849 | 594628 | 104 | 809 | 22 | 201 | 16481 | B | 9/26/2020 01:59 | 2020-09-26T01:59:00Z | 09/25 21:59 | 156 | 809 | 2020-09-26T01:59:00Z | 616642 | 20380 | 153 | 3 | 594628 | 236229 | 9344 | 421 | 8923 | 38 | 495 | 1100 | 236229 | totalTestEncountersViral | 7064 | 236229 | 0 | 20 | 774fda32838bbbdd408f7f2df9a95d38e10e2829 | 0 | 0 | 0 | 0 | 0 | |||||||||||||
44 | 44 | 20200926 | RI | 24181 | 305853 | 727469 | 94 | 2725 | 8 | 4 | 2278 | A+ | 9/25/2020 12:00 | 2020-09-25T12:00:00Z | 09/25 08:00 | 1107 | 2725 | 2020-09-25T12:00:00Z | 34299 | 693170 | 24181 | 727469 | 330034 | 44 | 0 | 0 | 330034 | totalTestEncountersViral | 0 | 330034 | 0 | 0 | e5a147d241db0ad3830218c1038dc29b79d42bcc | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
49 | 49 | 20200926 | UT | 69547 | 735532 | 805079 | 191 | 3702 | 77 | 890 | 358 | 53806 | A+ | 9/26/2020 11:02 | 2020-09-26T11:02:00Z | 09/26 07:02 | 448 | 3702 | 2020-09-26T11:02:00Z | 1037414 | 69547 | 805079 | 13698 | 1793 | 23618 | 1900 | 49 | 1017 | 8845 | 805079 | posNeg | 9862 | 805079 | 0 | 34 | 3670fa0d15d16f24a5287b6b4adede4295b71342 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||
51 | 51 | 20200926 | VI | 1296 | 18676 | 8 | 19972 | 1209 | D | 9/25/2020 09:30 | 2020-09-25T09:30:00Z | 09/25 05:30 | 19 | 2020-09-25T09:30:00Z | 19980 | 19 | 78 | 0 | 0 | 19980 | posNeg | 0 | 19972 | 0 | 0 | 61739fb2efab7827062ca9cc633984208f34bc24 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
52 | 52 | 20200926 | VT | 1739 | 158537 | 160276 | 1 | 1580 | B | 9/25/2020 23:59 | 2020-09-25T23:59:00Z | 09/25 19:59 | 58 | 2020-09-25T23:59:00Z | 1739 | 58 | 160276 | 50 | 8 | 989 | 160276 | posNeg | 997 | 160276 | 0 | 0 | 21dc4138bae65a1c22e9f7756f9fd545cb820bea | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
56 | 56 | 20200926 | WY | 5465 | 92406 | 97871 | 22 | 258 | 4479 | B | 9/26/2020 11:55 | 2020-09-26T11:55:00Z | 09/26 07:55 | 50 | 258 | 2020-09-26T11:55:00Z | 155082 | 4497 | 150584 | 4618 | 96991 | 56 | 45 | 0 | 97871 | posNeg | 45 | 97871 | 0 | 2 | 9c1be43cf5db286c8a903c0b3ed654e3d5b588c2 | 0 | 0 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [states_current] ( [date] INTEGER, [state] TEXT, [positive] INTEGER, [negative] INTEGER, [pending] TEXT, [totalTestResults] INTEGER, [hospitalizedCurrently] TEXT, [hospitalizedCumulative] TEXT, [inIcuCurrently] TEXT, [inIcuCumulative] TEXT, [onVentilatorCurrently] TEXT, [onVentilatorCumulative] TEXT, [recovered] TEXT, [dataQualityGrade] TEXT, [lastUpdateEt] TEXT, [dateModified] TEXT, [checkTimeEt] TEXT, [death] INTEGER, [hospitalized] TEXT, [dateChecked] TEXT, [totalTestsViral] TEXT, [positiveTestsViral] TEXT, [negativeTestsViral] TEXT, [positiveCasesViral] TEXT, [deathConfirmed] TEXT, [deathProbable] TEXT, [totalTestEncountersViral] TEXT, [totalTestsPeopleViral] TEXT, [totalTestsAntibody] TEXT, [positiveTestsAntibody] TEXT, [negativeTestsAntibody] TEXT, [totalTestsPeopleAntibody] TEXT, [positiveTestsPeopleAntibody] TEXT, [negativeTestsPeopleAntibody] TEXT, [totalTestsPeopleAntigen] TEXT, [positiveTestsPeopleAntigen] TEXT, [totalTestsAntigen] TEXT, [positiveTestsAntigen] TEXT, [fips] INTEGER, [positiveIncrease] INTEGER, [negativeIncrease] INTEGER, [total] INTEGER, [totalTestResultsSource] TEXT, [totalTestResultsIncrease] INTEGER, [posNeg] INTEGER, [deathIncrease] INTEGER, [hospitalizedIncrease] INTEGER, [hash] TEXT, [commercialScore] INTEGER, [negativeRegularScore] INTEGER, [negativeScore] INTEGER, [positiveScore] INTEGER, [score] INTEGER, [grade] TEXT );