states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
11,578 rows sorted by total
This data as json, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
10983 | 10983 | 20200314 | HI | 2 | 2 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 15 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 105086157d7987b9e53ef719f5d160541fc58600 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11022 | 11022 | 20200314 | WY | 2 | 2 | 3/13/2020 00:00 | 2020-03-13T00:00:00Z | 03/12 20:00 | 2020-03-13T00:00:00Z | 2 | 56 | 1 | 0 | 2 | posNeg | 1 | 2 | 0 | 0 | 8d9d3ca4720cc8639b78c55ddcf27eb1b3337f3e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11034 | 11034 | 20200313 | HI | 2 | 2 | 3/12/2020 00:00 | 2020-03-12T00:00:00Z | 03/11 20:00 | 2020-03-12T00:00:00Z | 15 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | fc90a073776bbb2fb0909ca8ded9cf41bc51e98c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11085 | 11085 | 20200312 | HI | 2 | 2 | 3/11/2020 00:00 | 2020-03-11T00:00:00Z | 03/10 20:00 | 2020-03-11T00:00:00Z | 15 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 356b68f539ad15e806c6936b6be3c58aef9da8d1 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11136 | 11136 | 20200311 | HI | 2 | 2 | 15 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 1090e54dad5c1669a493d5d9c73d1ad665b753ac | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11169 | 11169 | 20200311 | UT | 2 | 2 | 2 | 49 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 653cf8d22908dc9f4a924f5d8c626b0802666ff7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11187 | 11187 | 20200310 | HI | 2 | 2 | 15 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | dc4c46fcfaa7c3964ed0d96500d7b867d9335a7e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11220 | 11220 | 20200310 | UT | 2 | 2 | 2 | 49 | 1 | 0 | 2 | posNeg | 1 | 2 | 0 | 0 | 54d3a125fe6d0bc8002f0ed7e2261af5084b6b69 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11238 | 11238 | 20200309 | HI | 2 | 2 | 15 | 1 | 0 | 2 | posNeg | 1 | 2 | 0 | 0 | 8ee289ff9078e8033d2c7d9c46923f9418b544a5 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11242 | 11242 | 20200309 | IN | 2 | 2 | 18 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | d8eecf48ba3c86aafcc5a09a39ccb3f2dc81f9b2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11254 | 11254 | 20200309 | NC | 2 | 2 | 37 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 024fa80c3564c92b1a1c9bd6fde8eedbb6ca12ab | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11293 | 11293 | 20200308 | IN | 2 | 2 | 18 | 1 | 0 | 2 | posNeg | 1 | 2 | 0 | 0 | f1a024c9493ca5c13fa1400447fdc64cb4fa13c8 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11305 | 11305 | 20200308 | NC | 2 | 2 | 37 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 2db7cf8e77c62d6f4dd1ec027d8a60e26f50323f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11356 | 11356 | 20200307 | NC | 2 | 2 | 37 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | ded978542c169d9580bff5dc4cc649ec22a30f43 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11388 | 11388 | 20200306 | GA | 2 | 2 | 2 | 13 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | cec1802d5dfc5229646abf26fec428e1481db1e3 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11398 | 11398 | 20200306 | NC | 2 | 2 | 37 | 1 | 0 | 2 | posNeg | 1 | 2 | 0 | 0 | a4aed27dbdb2f9ff71c0f348fc90c564f2210717 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11407 | 11407 | 20200306 | PA | 2 | 2 | 42 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | e74dee4abf0f448eb5615b7c32b274c90d5cf773 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11422 | 11422 | 20200305 | GA | 2 | 2 | 2 | 13 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | d4d80e64fc6aaa79af0a071cf69fca98219493f5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11445 | 11445 | 20200304 | GA | 2 | 2 | 2 | 13 | 0 | 0 | 2 | posNeg | 0 | 2 | 0 | 0 | 05981c7c64c1a7574528bd621b73ca93c88c3a53 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
9300 | 9300 | 20200413 | AS | 0 | 3 | 3 | 4/6/2020 00:00 | 2020-04-06T00:00:00Z | 04/05 20:00 | 2020-04-06T00:00:00Z | 3 | 0 | 60 | 0 | 0 | 3 | posNeg | 0 | 3 | 0 | 0 | c6b06661f3819320dd6c55a3bd69ed8d000abbb4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
10691 | 10691 | 20200320 | VI | 3 | 3 | 3/19/2020 17:30 | 2020-03-19T17:30:00Z | 03/19 13:30 | 2020-03-19T17:30:00Z | 78 | 0 | 0 | 3 | posNeg | 0 | 3 | 0 | 0 | 2150999f5784b00971a0f42301b75de1faeda9ce | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10747 | 10747 | 20200319 | VI | 3 | 3 | 3/18/2020 07:30 | 2020-03-18T07:30:00Z | 03/18 03:30 | 2020-03-18T07:30:00Z | 78 | 1 | 0 | 3 | posNeg | 1 | 3 | 0 | 0 | 42d5262802dd8d90bebd4940712c571bb4c782c5 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10920 | 10920 | 20200316 | WY | 3 | 3 | 3/16/2020 15:04 | 2020-03-16T15:04:00Z | 03/16 11:04 | 2020-03-16T15:04:00Z | 3 | 56 | 0 | 0 | 3 | posNeg | 0 | 3 | 0 | 0 | 1cde4691ad1dce52a1e6d88c98616f0f1e58e019 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
10971 | 10971 | 20200315 | WY | 3 | 3 | 3/14/2020 00:00 | 2020-03-14T00:00:00Z | 03/13 20:00 | 2020-03-14T00:00:00Z | 2 | 56 | 1 | 0 | 3 | posNeg | 1 | 3 | 0 | 0 | 3efc0c35fd5b11255cc0db412b0aa8cc735c9d33 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11269 | 11269 | 20200309 | TN | 3 | 3 | 47 | 0 | 0 | 3 | posNeg | 0 | 3 | 0 | 0 | 1611da9ace942c73343f7d59a9d088c604e3cb6a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11320 | 11320 | 20200308 | TN | 3 | 3 | 47 | 2 | 0 | 3 | posNeg | 2 | 3 | 0 | 0 | 4617ccbe70ea4376d978c1530ca256efb32e9c88 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11367 | 11367 | 20200307 | PA | 4 | 4 | 42 | 2 | 0 | 4 | posNeg | 2 | 4 | 0 | 0 | ebca1dfee58b8491f516851b03c3460ea02a3e48 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11392 | 11392 | 20200306 | KS | 0 | 4 | 0 | 4 | 20 | 0 | 0 | 4 | posNeg | 0 | 4 | 0 | 0 | 869916ef064b6274b1c4d30feee19fe80e419f3c | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11475 | 11475 | 20200301 | RI | 2 | 2 | 3/1/2020 03:00 | 2020-03-01T03:00:00Z | 02/29 22:00 | 2020-03-01T03:00:00Z | 4 | 2 | 2 | 2 | 4 | 44 | 0 | 0 | 4 | totalTestEncountersViral | 0 | 4 | 0 | 0 | 008b0080959373e1f9483cf91a55ae015b5b31af | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9356 | 9356 | 20200412 | AS | 0 | 3 | 2 | 3 | 3/31/2020 19:16 | 2020-03-31T19:16:00Z | 03/31 15:16 | 2020-03-31T19:16:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | 147c1fce41443f82aadf764929d63cf93573241d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
9412 | 9412 | 20200411 | AS | 0 | 3 | 2 | 3 | 3/31/2020 19:16 | 2020-03-31T19:16:00Z | 03/31 15:16 | 2020-03-31T19:16:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | bab88ce6e3fdd121ed14f0e87c9366e396382477 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||
9468 | 9468 | 20200410 | AS | 0 | 3 | 2 | 3 | 4/6/2020 16:00 | 2020-04-06T16:00:00Z | 04/06 12:00 | 0 | 2020-04-06T16:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | 4179f6ea0485f707e82fe3b47b570f690b034e24 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9524 | 9524 | 20200409 | AS | 0 | 3 | 2 | 3 | 4/6/2020 16:00 | 2020-04-06T16:00:00Z | 04/06 12:00 | 0 | 2020-04-06T16:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | b5d66885a54804cb22be1a11efc44efcc3095644 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9580 | 9580 | 20200408 | AS | 0 | 3 | 2 | 3 | 4/6/2020 16:00 | 2020-04-06T16:00:00Z | 04/06 12:00 | 0 | 2020-04-06T16:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | 94df3e7e7c82359763e0c807d9f719611d845e93 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9636 | 9636 | 20200407 | AS | 0 | 3 | 2 | 3 | 4/6/2020 16:00 | 2020-04-06T16:00:00Z | 04/06 12:00 | 0 | 2020-04-06T16:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | 74dc82a8afe625724b7b3b3b6c65d1d023544269 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9692 | 9692 | 20200406 | AS | 0 | 3 | 2 | 3 | 4/6/2020 16:00 | 2020-04-06T16:00:00Z | 04/06 12:00 | 0 | 2020-04-06T16:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | f27aaf8008b12ddd3f887f9c1fd4f69f706d9881 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9748 | 9748 | 20200405 | AS | 0 | 3 | 2 | 3 | 3/30/2020 23:00 | 2020-03-30T23:00:00Z | 03/30 19:00 | 0 | 2020-03-30T23:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | 50b0bf581bf52acb2f058136f521846cd6d93af2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9804 | 9804 | 20200404 | AS | 0 | 3 | 2 | 3 | 3/30/2020 23:00 | 2020-03-30T23:00:00Z | 03/30 19:00 | 0 | 2020-03-30T23:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | 45297872049fc2bc64ae664b1ffcd484db810b9f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9860 | 9860 | 20200403 | AS | 0 | 3 | 2 | 3 | 3/30/2020 23:00 | 2020-03-30T23:00:00Z | 03/30 19:00 | 0 | 2020-03-30T23:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | d0ff9647302f774881b902572c312f142af3e56f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9916 | 9916 | 20200402 | AS | 0 | 3 | 2 | 3 | 3/30/2020 23:00 | 2020-03-30T23:00:00Z | 03/30 19:00 | 0 | 2020-03-30T23:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | cccc2f8f22906b58a34ea2dacde38a8d2a318c96 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
9972 | 9972 | 20200401 | AS | 0 | 3 | 2 | 3 | 3/30/2020 23:00 | 2020-03-30T23:00:00Z | 03/30 19:00 | 0 | 2020-03-30T23:00:00Z | 3 | 0 | 60 | 0 | 0 | 5 | posNeg | 0 | 3 | 0 | 0 | d3e447c2aa5e4107ee614da8de801a5d0a3105a9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
10028 | 10028 | 20200331 | AS | 0 | 3 | 2 | 3 | 3/30/2020 00:00 | 2020-03-30T00:00:00Z | 03/29 20:00 | 0 | 2020-03-30T00:00:00Z | 3 | 0 | 60 | 0 | 3 | 5 | posNeg | 3 | 3 | 0 | 0 | 1aa73b4235d97ea1e7c69f21a3cce6807b07fb59 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||
11174 | 11174 | 20200311 | WV | 0 | 3 | 2 | 3 | 0 | 54 | 0 | 1 | 5 | posNeg | 1 | 3 | 0 | 0 | add6e2eeafdb29275118506c96f9149c58be0b40 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11225 | 11225 | 20200310 | WV | 0 | 2 | 3 | 2 | 0 | 54 | 0 | 0 | 5 | posNeg | 0 | 2 | 0 | 0 | 33a85c29696e8c58f9eebd1d7a43e440e762cf2b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11268 | 11268 | 20200309 | SD | 0 | 5 | 0 | 5 | 5 | 46 | 0 | 0 | 5 | posNeg | 0 | 5 | 0 | 0 | fd69eda5746c616093059afe31b23b3f20293319 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11276 | 11276 | 20200309 | WV | 0 | 2 | 3 | 2 | 0 | 54 | 0 | 0 | 5 | posNeg | 0 | 2 | 0 | 0 | a621da63913b2294614db788f9ffaa61cea7dce9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11296 | 11296 | 20200308 | LA | 0 | 5 | 5 | 0 | 22 | 0 | 5 | 5 | posNeg | 5 | 5 | 0 | 0 | b2f8598087a737fc9a845252abe3223ffee9ba51 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11319 | 11319 | 20200308 | SD | 0 | 5 | 0 | 5 | 5 | 46 | 0 | 0 | 5 | posNeg | 0 | 5 | 0 | 0 | 41976be1e052bda9301ee0e94670725da3ea87eb | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11327 | 11327 | 20200308 | WV | 0 | 2 | 3 | 2 | 0 | 54 | 0 | 0 | 5 | posNeg | 0 | 2 | 0 | 0 | a88a2c3fac00ba8ad7b58dcdac4ef6e995725c07 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11360 | 11360 | 20200307 | NJ | 4 | 1 | 4 | 0 | 4 | 0 | 4 | 34 | 3 | 0 | 5 | posNeg | 3 | 4 | 0 | 0 | 02cce3725fade67240b8f6e6cc9a4ccac5c500f0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11370 | 11370 | 20200307 | SD | 0 | 5 | 0 | 5 | 5 | 46 | 0 | 0 | 5 | posNeg | 0 | 5 | 0 | 0 | ce0dea081cda6a54b84abe98d7b02b1d4aa7bb8a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11378 | 11378 | 20200307 | WV | 0 | 2 | 3 | 2 | 0 | 54 | 0 | 1 | 5 | posNeg | 1 | 2 | 0 | 0 | 449fa27717fa512952dc566da7ea1b434afb3836 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11409 | 11409 | 20200306 | SC | 0 | 5 | 5 | 0 | 45 | 0 | 0 | 5 | posNeg | 0 | 5 | 0 | 0 | 3de143faa1d246d3569a4d73c92ce18796435321 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11411 | 11411 | 20200306 | TX | 5 | 5 | 5 | 48 | 4 | 0 | 5 | posNeg | 4 | 5 | 0 | 0 | 2e9ea0bb353851b7cc519c04dfb73aaa9b780b2e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11416 | 11416 | 20200306 | WV | 0 | 1 | 4 | 1 | 0 | 54 | 0 | 0 | 5 | posNeg | 0 | 1 | 0 | 0 | 72a7abd8de92bd9baf3046acd3ea566699d21e31 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11436 | 11436 | 20200305 | SC | 0 | 5 | 5 | 0 | 45 | 0 | 0 | 5 | posNeg | 0 | 5 | 0 | 0 | d1b9c8d019f752b3382e9e77b37ca59d1446c88a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11455 | 11455 | 20200304 | SC | 0 | 5 | 5 | 0 | 45 | 0 | 0 | 5 | posNeg | 0 | 5 | 0 | 0 | cebf83dff216f187b0b9d36b2b7859294acd9e75 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11469 | 11469 | 20200302 | RI | 2 | 3 | 4 | 3/2/2020 03:00 | 2020-03-02T03:00:00Z | 03/01 22:00 | 2020-03-02T03:00:00Z | 5 | 2 | 3 | 2 | 4 | 5 | 44 | 0 | 1 | 5 | totalTestEncountersViral | 4 | 5 | 0 | 0 | b5b45c6219dace9942c021bc2c7b0114fff7eb3f | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
9996 | 9996 | 20200401 | MP | 6 | 6 | 3/31/2020 21:50 | 2020-03-31T21:50:00Z | 03/31 17:50 | 2020-03-31T21:50:00Z | 69 | 4 | 0 | 6 | posNeg | 4 | 6 | 0 | 0 | bd8aeb9eb37bcc9caaf1f27773bb957d7f925968 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10579 | 10579 | 20200322 | VI | 6 | 6 | 3/21/2020 20:30 | 2020-03-21T20:30:00Z | 03/21 16:30 | 2020-03-21T20:30:00Z | 78 | 0 | 0 | 6 | posNeg | 0 | 6 | 0 | 0 | b70c96abc83090c55d6a00268b7278fda0aee532 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10635 | 10635 | 20200321 | VI | 6 | 6 | 3/20/2020 20:30 | 2020-03-20T20:30:00Z | 03/20 16:30 | 2020-03-20T20:30:00Z | 78 | 3 | 0 | 6 | posNeg | 3 | 6 | 0 | 0 | 74deacd22056ad300bc35e9009f3091f29eea219 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11245 | 11245 | 20200309 | LA | 1 | 5 | 6 | 1 | 22 | 1 | 0 | 6 | posNeg | 1 | 6 | 0 | 0 | be423464762f6e54b8e900805a923bdb76f313e5 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11280 | 11280 | 20200308 | AR | 0 | 6 | 0 | 6 | 6 | 0 | 5 | 0 | 0 | 6 | posNeg | 0 | 6 | 0 | 0 | f279c3c9df7df0e71ad32775ff46df28a5524a4a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11316 | 11316 | 20200308 | PA | 6 | 6 | 42 | 2 | 0 | 6 | posNeg | 2 | 6 | 0 | 0 | c06d9371ae937eeaa1d3ded4fc30ec96b45a173b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11331 | 11331 | 20200307 | AR | 0 | 6 | 0 | 6 | 6 | 0 | 5 | 0 | 0 | 6 | posNeg | 0 | 6 | 0 | 0 | 1ece7893cfeed3ae7d761db447cb080f14977c61 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11339 | 11339 | 20200307 | GA | 6 | 6 | 6 | 13 | 4 | 0 | 6 | posNeg | 4 | 6 | 0 | 0 | 56dbc5fb276f6b87116ad0dc2459f2ba9d4bdc20 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11381 | 11381 | 20200306 | AR | 0 | 6 | 0 | 6 | 6 | 0 | 5 | 0 | 0 | 6 | posNeg | 0 | 6 | 0 | 0 | d2ee5fcc83ed0c711dcd518c7cc9cdf86ba7acc7 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
10878 | 10878 | 20200316 | HI | 7 | 7 | 3/16/2020 15:39 | 2020-03-16T15:39:00Z | 03/16 11:39 | 2020-03-16T15:39:00Z | 15 | 5 | 0 | 7 | posNeg | 5 | 7 | 0 | 0 | fe247926163e19c6b5dcb3137e6fb2e5f534a19f | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11152 | 11152 | 20200311 | NC | 7 | 7 | 37 | 0 | 0 | 7 | posNeg | 0 | 7 | 0 | 0 | f08f3575b2389f5750a6482b9e396fff8e5b77e8 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11203 | 11203 | 20200310 | NC | 7 | 7 | 37 | 5 | 0 | 7 | posNeg | 5 | 7 | 0 | 0 | 5ca8052a4e856770ed70c15e9958fc5f3d3fbdac | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11218 | 11218 | 20200310 | TN | 7 | 7 | 47 | 4 | 0 | 7 | posNeg | 4 | 7 | 0 | 0 | 832ea8e2093dbc3ddbebcd241580dfd3ac10ed7b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11288 | 11288 | 20200308 | GA | 7 | 7 | 7 | 13 | 1 | 0 | 7 | posNeg | 1 | 7 | 0 | 0 | ba0e1de92ee7d7a3ba88b7eb0aa563feb3dcbe97 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11463 | 11463 | 20200303 | RI | 2 | 5 | 5 | 3/3/2020 03:00 | 2020-03-03T03:00:00Z | 03/02 22:00 | 2020-03-03T03:00:00Z | 7 | 2 | 5 | 2 | 5 | 7 | 44 | 0 | 2 | 7 | totalTestEncountersViral | 1 | 7 | 0 | 0 | 4f5646cf6f957ccf8cc678537a1f9034095dd5bb | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
11093 | 11093 | 20200312 | MA | 8 | 1116 | 3/11/2020 00:00 | 2020-03-11T00:00:00Z | 03/10 20:00 | 2020-03-11T00:00:00Z | 1116 | 170 | 25 | 8 | 0 | 8 | totalTestsViral | 432 | 8 | 0 | 0 | e1aec5853d616b5b50cc8939867e4dc78b498a4e | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||
11123 | 11123 | 20200312 | WV | 0 | 7 | 1 | 7 | 3/12/2020 00:00 | 2020-03-12T00:00:00Z | 03/11 20:00 | 2020-03-12T00:00:00Z | 0 | 54 | 0 | 4 | 8 | posNeg | 4 | 7 | 0 | 0 | c0ba7d8efebb919740bdc8420c52d528fb4b46f9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
11204 | 11204 | 20200310 | ND | 0 | 6 | 2 | 7 | 12 | 7 | 7 | 38 | 0 | 6 | 8 | totalTestEncountersViral | 7 | 6 | 0 | 0 | b253186b79d4e92b4a350b6f287a2f85990d5afe | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11321 | 11321 | 20200308 | TX | 8 | 8 | 8 | 48 | 0 | 0 | 8 | posNeg | 0 | 8 | 0 | 0 | f94e478683fbfcc8099c8c30041dbacebf8d9550 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11372 | 11372 | 20200307 | TX | 8 | 8 | 8 | 48 | 3 | 0 | 8 | posNeg | 3 | 8 | 0 | 0 | 8879e97aec342418e578906886082ae70c76bed1 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11420 | 11420 | 20200305 | DC | 0 | 6 | 2 | 6 | 6 | 11 | 0 | 0 | 8 | posNeg | 0 | 6 | 0 | 0 | 511da9e0387d34eaf2f0ab354f6de9ce58caff3b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11336 | 11336 | 20200307 | DC | 0 | 8 | 1 | 8 | 8 | 11 | 0 | 0 | 9 | posNeg | 0 | 8 | 0 | 0 | 6ca390a3a8d83a1af1c763d44042115aa85d1175 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11380 | 11380 | 20200306 | AK | 0 | 8 | 1 | 8 | 0 | 8 | 0 | 2 | 0 | 0 | 9 | posNeg | 0 | 8 | 0 | 0 | 21a9fd54bd38e461fd39885bfa77c8aaf7559737 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11385 | 11385 | 20200306 | DC | 0 | 8 | 1 | 8 | 8 | 11 | 0 | 2 | 9 | posNeg | 2 | 8 | 0 | 0 | 49d91289f6bdaf15b3933057e6330a0a91a5cf25 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
10822 | 10822 | 20200317 | HI | 10 | 10 | 3/16/2020 18:00 | 2020-03-16T18:00:00Z | 03/16 14:00 | 2020-03-16T18:00:00Z | 15 | 3 | 0 | 10 | posNeg | 3 | 10 | 0 | 0 | 685cc8a7fd357cc2b366c74d93a09e0be310e15a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||
11075 | 11075 | 20200312 | AL | 0 | 10 | 10 | 3/9/2020 00:00 | 2020-03-09T00:00:00Z | 03/08 20:00 | 2020-03-09T00:00:00Z | 10 | 0 | 1 | 0 | 0 | 10 | posNeg | 0 | 10 | 0 | 0 | 46aff5f401d30c27bc995bb19128dcf07fcce327 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
11126 | 11126 | 20200311 | AL | 0 | 10 | 10 | 3/9/2020 00:00 | 2020-03-09T00:00:00Z | 03/08 20:00 | 2020-03-09T00:00:00Z | 10 | 0 | 1 | 0 | 10 | 10 | posNeg | 10 | 10 | 0 | 0 | 2db05e22076fc4a470968b84dc3ad2179c19ea24 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||
11265 | 11265 | 20200309 | PA | 10 | 10 | 42 | 4 | 0 | 10 | posNeg | 4 | 10 | 0 | 0 | 3c5d003242603efee2879b691f1c3bf469e35d0a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||||
11286 | 11286 | 20200308 | DE | 0 | 10 | 0 | 10 | 0 | 0 | 0 | 10 | 0 | 0 | 10 | posNeg | 0 | 10 | 0 | 0 | 418a26a20050481e80ea0e97a282e9b6e0df42a0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||
11318 | 11318 | 20200308 | SC | 2 | 8 | 10 | 2 | 45 | 0 | 0 | 10 | posNeg | 0 | 10 | 0 | 0 | 06efb7f0d09fd6085072c864a041b228f6f02046 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11337 | 11337 | 20200307 | DE | 0 | 10 | 0 | 10 | 10 | 0 | 0 | 10 | posNeg | 0 | 10 | 0 | 0 | c083cd6ee50c6645888f0bdf9e7b778d226d66a0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11346 | 11346 | 20200307 | KY | 1 | 9 | 10 | 10 | 21 | 1 | 2 | 10 | posNeg | 3 | 10 | 0 | 0 | 0161229e319e4864b690d42e53f8361c74e76143 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11369 | 11369 | 20200307 | SC | 2 | 8 | 10 | 2 | 45 | 2 | 3 | 10 | posNeg | 5 | 10 | 0 | 0 | fdaa38e1f63fc290f7194d07505e9222d960189d | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11386 | 11386 | 20200306 | DE | 0 | 10 | 0 | 10 | 10 | 0 | 0 | 10 | posNeg | 0 | 10 | 0 | 0 | 791a5103c9735e64919ff50aea2f9b8fb1150c0a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||||||||||
11393 | 11393 | 20200306 | KY | 0 | 7 | 3 | 7 | 7 | 21 | 0 | 0 | 10 | posNeg | 0 | 7 | 0 | 0 | 95f887923437832032211bf91cff3cbd10741796 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11405 | 11405 | 20200306 | OH | 0 | 8 | 2 | 8 | 0 | 39 | 0 | 1 | 10 | posNeg | 1 | 8 | 0 | 0 | 668ec08d6188e1b95f66e01cfa4da7b5e159f9f4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11433 | 11433 | 20200305 | OH | 0 | 7 | 3 | 7 | 0 | 39 | 0 | 0 | 10 | posNeg | 0 | 7 | 0 | 0 | 459bc305b63235074b9f4ea5633d9719bd1fc8ff | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11217 | 11217 | 20200310 | SD | 0 | 11 | 0 | 11 | 11 | 46 | 0 | 6 | 11 | posNeg | 6 | 11 | 0 | 0 | 2aab686e4b10fe976e7c5f37e9634b5f4064e464 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11253 | 11253 | 20200309 | MT | 0 | 11 | 11 | 30 | 0 | 0 | 11 | posNeg | 0 | 11 | 0 | 0 | 7389a58a4096673a163b6abf629c9c0a397e9da9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11285 | 11285 | 20200308 | DC | 1 | 10 | 0 | 11 | 11 | 11 | 1 | 2 | 11 | posNeg | 3 | 11 | 0 | 0 | 688541968c5c91129f3cac155fa3788425f4287d | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||
11304 | 11304 | 20200308 | MT | 0 | 11 | 11 | 30 | 0 | 0 | 11 | posNeg | 0 | 11 | 0 | 0 | e8b2489a8e1a4aad59ecc05469bbc5f735ba53d4 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||||||||||||
11314 | 11314 | 20200308 | OK | 1 | 8 | 2 | 9 | 40 | 0 | 8 | 11 | posNeg | 8 | 9 | 0 | 0 | ad27cf7d0a09050ea38a384e59f4748614f2daaf | 0 | 0 | 0 | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [states_daily_4pm_et] ( [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 );