states_daily_4pm_et
Data source: Big Local News · About: big-local-datasette
64 rows where "dateChecked" is on date 2020-06-12 sorted by posNeg
This data as json, copyable, CSV (advanced)
Suggested facets: date, pending, inIcuCurrently, inIcuCumulative, onVentilatorCurrently, onVentilatorCumulative, dataQualityGrade, positiveTestsViral, negativeTestsViral, deathConfirmed, deathProbable, totalTestEncountersViral, totalTestsPeopleViral, totalTestsAntibody, positiveTestsAntibody, negativeTestsAntibody, totalTestsPeopleAntibody, positiveTestsPeopleAntibody, negativeTestsPeopleAntibody, totalTestsPeopleAntigen, positiveTestsPeopleAntigen, totalTestsAntigen, positiveTestsAntigen, totalTestResultsSource, deathIncrease, hospitalizedIncrease, dateModified (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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
5987 | 5987 | 20200612 | VI | 72 | 2221 | 6 | 2293 | 64 | C | 6/12/2020 15:30 | 2020-06-12T15:30:00Z | 06/12 11:30 | 6 | 2020-06-12T15:30:00Z | 2299 | 6 | 78 | 0 | 41 | 2299 | posNeg | 41 | 2293 | 0 | 0 | 02caa7538a01a6480a32df2a06b6acf49143334e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
5931 | 5931 | 20200613 | VI | 72 | 2284 | 7 | 2356 | 64 | C | 6/12/2020 19:53 | 2020-06-12T19:53:00Z | 06/12 15:53 | 6 | 2020-06-12T19:53:00Z | 2363 | 6 | 78 | 0 | 63 | 2363 | posNeg | 63 | 2356 | 0 | 0 | 81ad2f84ddfd4485a225af8fabc34810e1f2b5de | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
5964 | 5964 | 20200612 | MP | 30 | 7732 | 7762 | 19 | D | 6/12/2020 01:20 | 2020-06-12T01:20:00Z | 06/11 21:20 | 2 | 2020-06-12T01:20:00Z | 7762 | 30 | 69 | 0 | 181 | 7762 | posNeg | 181 | 7762 | 0 | 0 | c9587fc860a99e7ef0565054f0ac029158dcf206 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
5908 | 5908 | 20200613 | MP | 30 | 7906 | 7936 | 19 | D | 6/12/2020 18:18 | 2020-06-12T18:18:00Z | 06/12 14:18 | 2 | 2020-06-12T18:18:00Z | 7936 | 30 | 69 | 0 | 174 | 7936 | posNeg | 174 | 7936 | 0 | 0 | 6549cdd073de2d1b3fade1bb85e042f00457a624 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||||
5949 | 5949 | 20200612 | GU | 184 | 8343 | 8527 | 168 | B | 6/12/2020 05:00 | 2020-06-12T05:00:00Z | 06/12 01:00 | 5 | 2020-06-12T05:00:00Z | 8426 | 174 | 8249 | 174 | 8517 | 110 | 2 | 66 | 1 | 146 | 8527 | posNeg | 147 | 8527 | 0 | 0 | 29141bfeab6e233082f4866dfba68228235e34b0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
5992 | 5992 | 20200612 | WY | 1027 | 30873 | 31900 | 5 | 92 | 814 | C | 6/12/2020 18:00 | 2020-06-12T18:00:00Z | 06/12 14:00 | 18 | 92 | 2020-06-12T18:00:00Z | 31684 | 941 | 30446 | 811 | 56 | 18 | 264 | 31900 | posNeg | 282 | 31900 | 0 | 0 | 56e5f0b0a1d7e86803ae8c09229a3fdf39e48788 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
5966 | 5966 | 20200612 | MT | 573 | 56449 | 57022 | 7 | 77 | 489 | C | 6/12/2020 00:00 | 2020-06-12T00:00:00Z | 06/11 20:00 | 18 | 77 | 2020-06-12T00:00:00Z | 57022 | 573 | 30 | 10 | 1235 | 57022 | posNeg | 1245 | 57022 | 0 | 3 | 0eea763bc975da724424861a7def251d1a3d6a9b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5894 | 5894 | 20200613 | HI | 706 | 58632 | 59338 | 87 | 627 | D | 6/12/2020 18:00 | 2020-06-12T18:00:00Z | 06/12 14:00 | 17 | 87 | 2020-06-12T18:00:00Z | 68738 | 59338 | 15 | 14 | 745 | 59338 | posNeg | 759 | 59338 | 0 | 1 | 15607b397ab6c012c4352ac2a5f03c9b7f1d3463 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
5896 | 5896 | 20200613 | ID | 3353 | 59305 | 62328 | 24 | 265 | 5 | 98 | 2776 | A | 6/12/2020 19:00 | 2020-06-12T19:00:00Z | 06/12 15:00 | 87 | 265 | 2020-06-12T19:00:00Z | 62328 | 3023 | 67 | 20 | 16 | 51 | 1175 | 62658 | posNeg | 1214 | 62658 | 1 | 0 | 0c4b6dd841994dde96d4849c23d8923bacbcd6e7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5889 | 5889 | 20200613 | DC | 9709 | 53327 | 63036 | 197 | 78 | 52 | 1143 | A+ | 6/12/2020 00:00 | 2020-06-12T00:00:00Z | 06/11 20:00 | 511 | 2020-06-12T00:00:00Z | 63036 | 50032 | 11 | 55 | 1028 | 63036 | posNeg | 1083 | 63036 | 5 | 0 | 3831d0956b3e67c561d63768967ed01011df10cd | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5960 | 5960 | 20200612 | ME | 2721 | 64166 | 66887 | 32 | 308 | 11 | 5 | 2105 | B | 6/12/2020 12:15 | 2020-06-12T12:15:00Z | 06/12 08:15 | 100 | 308 | 2020-06-12T12:15:00Z | 67585 | 3311 | 64166 | 2420 | 100 | 5464 | 274 | 5182 | 23 | 54 | 1376 | 66887 | posNeg | 1430 | 66887 | 0 | 0 | f604b1d8d3bdb18f8de858ce7b58009e8544512c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||
5937 | 5937 | 20200612 | AK | 625 | 70255 | 70880 | 15 | 3 | 403 | A | 6/12/2020 00:00 | 2020-06-12T00:00:00Z | 06/11 20:00 | 12 | 2020-06-12T00:00:00Z | 70880 | 625 | 12 | 2 | 14 | 1855 | 70880 | posNeg | 1869 | 70880 | 1 | 0 | dbaa13ed6e9f5edca1e62f091a463c216ade97a9 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5890 | 5890 | 20200613 | DE | 10229 | 69870 | 80099 | 93 | 6116 | A | 6/12/2020 18:00 | 2020-06-12T18:00:00Z | 06/12 14:00 | 495 | 2020-06-12T18:00:00Z | 9278 | 437 | 58 | 80099 | 10 | 56 | 2349 | 80099 | posNeg | 2405 | 80099 | 1 | 0 | f2f8cec0bf6bc4faf1ca27be00a87e3b6ea05fc7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5968 | 5968 | 20200612 | ND | 3014 | 81148 | 123650 | 35 | 197 | 2573 | F | 6/12/2020 00:00 | 2020-06-12T00:00:00Z | 06/11 20:00 | 67 | 197 | 2020-06-12T00:00:00Z | 126443 | 3014 | 64 | 3 | 123650 | 81930 | 3816 | 124 | 3692 | 38 | 36 | 1340 | 84162 | totalTestEncountersViral | 3332 | 84162 | 0 | 4 | 1939c956b956a6928676d5e136062c6dc10acce2 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
5914 | 5914 | 20200613 | NH | 5251 | 88705 | 112141 | 76 | 503 | 149 | 3843 | B | 6/12/2020 09:00 | 2020-06-12T09:00:00Z | 06/12 05:00 | 315 | 503 | 2020-06-12T09:00:00Z | 112141 | 5251 | 93956 | 17720 | 15236 | 33 | 42 | 1997 | 93956 | posNeg | 2639 | 93956 | 7 | -1 | 33318d0d6238eb4b0018cacb589f7789c01dc357 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5979 | 5979 | 20200612 | PR | 5536 | 113280 | 118816 | 92 | 7 | 4 | C | 6/12/2020 06:30 | 2020-06-12T06:30:00Z | 06/12 02:30 | 146 | 2020-06-12T06:30:00Z | 114723 | 2326 | 112331 | 1443 | 56 | 90 | 4093 | 72 | 184 | 24595 | 118816 | posNeg | 24779 | 118816 | 2 | 0 | c6b80c753cc9c8d5595fbcb2dfad2e254591e6f5 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5991 | 5991 | 20200612 | WV | 2233 | 121806 | 124039 | 29 | 9 | 2 | 1553 | B | 6/12/2020 10:00 | 2020-06-12T10:00:00Z | 06/12 06:00 | 86 | 2020-06-12T10:00:00Z | 123963 | 2157 | 7354 | 54 | 21 | 2898 | 124039 | posNeg | 2919 | 124039 | 1 | 0 | 7aa80a0f274b8399dc5a30228023d1a79a7538fa | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
5843 | 5843 | 20200614 | KS | 11047 | 118105 | 129152 | 973 | 324 | 143 | 667 | A | 6/12/2020 13:30 | 2020-06-12T13:30:00Z | 06/12 09:30 | 243 | 973 | 2020-06-12T13:30:00Z | 128939 | 20 | 0 | 0 | 129152 | posNeg | 0 | 129152 | 0 | 0 | fcef10131c89146fc00f0d40c53c75d4fd087ab8 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5899 | 5899 | 20200613 | KS | 11047 | 118105 | 129152 | 973 | 324 | 143 | 667 | A | 6/12/2020 13:30 | 2020-06-12T13:30:00Z | 06/12 09:30 | 243 | 973 | 2020-06-12T13:30:00Z | 128939 | 20 | 0 | 0 | 129152 | posNeg | 0 | 129152 | 0 | 0 | 4c9879d93c59223a803c0b0bb988d824185340db | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5955 | 5955 | 20200612 | KS | 11047 | 118105 | 129152 | 973 | 324 | 143 | 667 | A | 6/12/2020 13:30 | 2020-06-12T13:30:00Z | 06/12 09:30 | 243 | 973 | 2020-06-12T13:30:00Z | 128939 | 20 | 235 | 5175 | 129152 | posNeg | 5410 | 129152 | 3 | 19 | 7da603739de3565658cf672c50ff9df97cad2622 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5969 | 5969 | 20200612 | NE | 16315 | 114458 | 130773 | 164 | 1029 | 9229 | D | 6/12/2020 21:07 | 2020-06-12T21:07:00Z | 06/12 17:07 | 212 | 1029 | 2020-06-12T21:07:00Z | 16315 | 130933 | 31 | 290 | 2821 | 130773 | posNeg | 3111 | 130773 | 17 | 29 | dfcf531354f519f217334e32626ec395db87f24a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5980 | 5980 | 20200612 | RI | 16023 | 115483 | 200175 | 141 | 1853 | 28 | 17 | 1435 | A+ | 6/12/2020 03:00 | 2020-06-12T03:00:00Z | 06/11 23:00 | 833 | 1853 | 2020-06-12T03:00:00Z | 202294 | 22336 | 179958 | 16023 | 200175 | 131506 | 44 | 81 | 2093 | 131506 | totalTestEncountersViral | 3687 | 131506 | 10 | 11 | 137bf134029a0872cba874c2c925ec4d021db28b | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
5913 | 5913 | 20200613 | NE | 16513 | 117864 | 134377 | 157 | 1067 | 9610 | D | 6/12/2020 19:00 | 2020-06-12T19:00:00Z | 06/12 15:00 | 216 | 1067 | 2020-06-12T19:00:00Z | 16513 | 134536 | 31 | 198 | 3406 | 134377 | posNeg | 3604 | 134377 | 4 | 38 | 3df81353410443cf5735c2cef8a85252ae83ff29 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5787 | 5787 | 20200615 | KS | 11419 | 125543 | 136962 | 988 | 327 | 143 | 676 | A | 6/12/2020 13:30 | 2020-06-12T13:30:00Z | 06/12 09:30 | 245 | 988 | 2020-06-12T13:30:00Z | 136741 | 20 | 372 | 7438 | 136962 | posNeg | 7810 | 136962 | 2 | 15 | c3e71f1fefe07875c3cb324779fcbd61c5015c66 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5921 | 5921 | 20200613 | OR | 5535 | 164944 | 170479 | 133 | 875 | 47 | 15 | 2396 | A+ | 6/12/2020 03:01 | 2020-06-12T03:01:00Z | 06/11 23:01 | 174 | 875 | 2020-06-12T03:01:00Z | 5207 | 166019 | 41 | 158 | 4132 | 170479 | posNeg | 4290 | 170479 | 1 | 0 | a4560ec7df3010355fbcc649305f7912fd8f64d2 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
5865 | 5865 | 20200614 | OR | 5636 | 168246 | 173882 | 133 | 875 | 47 | 15 | 2396 | A+ | 6/12/2020 03:01 | 2020-06-12T03:01:00Z | 06/11 23:01 | 176 | 875 | 2020-06-12T03:01:00Z | 5207 | 166019 | 41 | 101 | 3302 | 173882 | posNeg | 3403 | 173882 | 2 | 0 | 153106b091ae7da1ae589e95856b08ade09af858 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
5939 | 5939 | 20200612 | AR | 11547 | 169575 | 182645 | 203 | 961 | 49 | 157 | 7607 | A | 6/12/2020 15:10 | 2020-06-12T15:10:00Z | 06/12 11:10 | 176 | 961 | 2020-06-12T15:10:00Z | 182645 | 11547 | 5 | 731 | 3726 | 181122 | posNeg | 6428 | 181122 | 5 | 36 | c09d744843c10beb7aec4b079d86db72a60b3d43 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
5973 | 5973 | 20200612 | NV | 10676 | 188769 | 199445 | 328 | 77 | 36 | 604 | A+ | 6/12/2020 11:30 | 2020-06-12T11:30:00Z | 06/12 07:30 | 475 | 2020-06-12T11:30:00Z | 229273 | 10676 | 199356 | 32 | 277 | 5914 | 199445 | posNeg | 6191 | 199445 | 0 | 0 | f3d1a5b5cf0b9d45d5c40c50f230f13edd4e1559 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
5909 | 5909 | 20200613 | MS | 19348 | 194537 | 213885 | 684 | 2644 | 160 | 103 | 13356 | A | 6/12/2020 19:00 | 2020-06-12T19:00:00Z | 06/12 15:00 | 889 | 2644 | 2020-06-12T19:00:00Z | 213753 | 19216 | 873 | 16 | 9442 | 95 | 28 | 257 | -865 | 213885 | posNeg | -608 | 213885 | 8 | 1 | 33b1ad73de50ac2d698b714210e1ef62783f9c11 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
5951 | 5951 | 20200612 | IA | 23337 | 191207 | 214544 | 225 | 81 | 47 | 14227 | A+ | 6/12/2020 00:00 | 2020-06-12T00:00:00Z | 06/11 20:00 | 643 | 2020-06-12T00:00:00Z | 23337 | 214943 | 25697 | 2095 | 23575 | 19 | 399 | 5606 | 214544 | posNeg | 6005 | 214544 | 4 | 0 | d1af79a4fb50d17f070b750a3b2576e714910ece | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||
5943 | 5943 | 20200612 | CO | 28647 | 205723 | 272930 | 279 | 5057 | 4169 | A | 6/12/2020 00:00 | 2020-06-12T00:00:00Z | 06/11 20:00 | 1339 | 5057 | 2020-06-12T00:00:00Z | 26040 | 272930 | 231763 | 83345 | 5799 | 77546 | 8 | 148 | 3877 | 234370 | totalTestEncountersViral | 5401 | 234370 | 11 | 22 | 5d67484cb8b4331d35a92694c7b72dfc4bc1c062 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5981 | 5981 | 20200612 | SC | 17170 | 218889 | 236059 | 512 | 1988 | 8682 | A+ | 6/12/2020 16:00 | 2020-06-12T16:00:00Z | 06/12 12:00 | 593 | 1988 | 2020-06-12T16:00:00Z | 242543 | 23654 | 218889 | 17170 | 593 | 28298 | 1385 | 26913 | 45 | 729 | 5273 | 236059 | posNeg | 6002 | 236059 | 5 | 90 | f23280aa1d1704430e17f13ee5ab1936d58d6617 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
5887 | 5887 | 20200613 | CO | 28822 | 207639 | 278526 | 274 | 5234 | 4184 | A | 6/12/2020 00:00 | 2020-06-12T00:00:00Z | 06/11 20:00 | 1348 | 5234 | 2020-06-12T00:00:00Z | 26215 | 278526 | 236461 | 85027 | 5892 | 79135 | 8 | 175 | 1916 | 236461 | totalTestEncountersViral | 5596 | 236461 | 9 | 177 | a2ee4b750e70957b3281e73dc76dbe6b8f4ffdde | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5976 | 5976 | 20200612 | OK | 7848 | 238366 | 246214 | 154 | 1103 | 65 | 6391 | A+ | 6/12/2020 08:00 | 2020-06-12T08:00:00Z | 06/12 04:00 | 359 | 1103 | 2020-06-12T08:00:00Z | 248091 | 9156 | 238366 | 7848 | 27415 | 974 | 40 | 222 | 4547 | 246214 | posNeg | 4769 | 246214 | 2 | 11 | 8290b12d43f4dbe20d2f61a1b81a095e35d141b4 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
5920 | 5920 | 20200613 | OK | 8073 | 238366 | 246439 | 154 | 1111 | 67 | 6495 | A+ | 6/12/2020 08:00 | 2020-06-12T08:00:00Z | 06/12 04:00 | 359 | 1111 | 2020-06-12T08:00:00Z | 248091 | 9456 | 238366 | 8073 | 27415 | 974 | 40 | 225 | 0 | 246439 | posNeg | 225 | 246439 | 0 | 8 | 78a8370fc28f65ca83dfd0ac3c78f7375fc245c7 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
5916 | 5916 | 20200613 | NM | 9526 | 245758 | 255284 | 179 | 1625 | 3983 | C | 6/12/2020 17:30 | 2020-06-12T17:30:00Z | 06/12 13:30 | 426 | 1625 | 2020-06-12T17:30:00Z | 255284 | 9526 | 35 | 0 | 0 | 255284 | posNeg | 0 | 255284 | 0 | 0 | 13b0ffc6d8630111366c2ccd5229743c135e4c74 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5972 | 5972 | 20200612 | NM | 9526 | 245758 | 255284 | 179 | 1625 | 3983 | C | 6/12/2020 17:30 | 2020-06-12T17:30:00Z | 06/12 13:30 | 426 | 1625 | 2020-06-12T17:30:00Z | 255284 | 9526 | 35 | 276 | 9451 | 255284 | posNeg | 9727 | 255284 | 16 | 42 | 8da267ae431729625a1cc2a8cbb299abb6f49912 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5985 | 5985 | 20200612 | UT | 13577 | 245209 | 258786 | 197 | 988 | 294 | 130 | 7935 | B | 6/12/2020 10:20 | 2020-06-12T10:20:00Z | 06/12 06:20 | 139 | 988 | 2020-06-12T10:20:00Z | 13577 | 258786 | 5 | 5 | 5 | 5 | 49 | 325 | 3793 | 258786 | posNeg | 4118 | 258786 | 8 | 20 | ea16f63ce27da53e7f4594c5ac4ce9838f22e3dd | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
5963 | 5963 | 20200612 | MO | 15585 | 249550 | 265135 | 593 | 69 | B | 6/12/2020 15:00 | 2020-06-12T15:00:00Z | 06/12 11:00 | 872 | 2020-06-12T15:00:00Z | 270232 | 17275 | 252506 | 15585 | 265135 | 32452 | 1232 | 31220 | 29 | 195 | 5900 | 265135 | posNeg | 6095 | 265135 | 12 | 0 | b3e8e0a721cf0ea9e9aa2d35449e7931e62d4f77 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5938 | 5938 | 20200612 | AL | 23710 | 262675 | 286008 | 624 | 2202 | 658 | 384 | 13508 | B | 6/12/2020 11:00 | 2020-06-12T11:00:00Z | 06/12 07:00 | 769 | 2202 | 2020-06-12T11:00:00Z | 286008 | 23333 | 764 | 5 | 1 | 865 | 6694 | 286385 | posNeg | 7553 | 286385 | 14 | 37 | 6a5a79a6af199ad831660a0cfd2963490a1c1763 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5941 | 5941 | 20200612 | AZ | 32918 | 289861 | 320816 | 1336 | 4079 | 429 | 278 | 5980 | A+ | 6/12/2020 00:00 | 2020-06-12T00:00:00Z | 06/11 20:00 | 1144 | 4079 | 2020-06-12T00:00:00Z | 30955 | 1060 | 67 | 320816 | 122070 | 4 | 1654 | 11543 | 322779 | posNeg | 11543 | 322779 | 17 | 38 | a27b5097c1273b2334831209d5b4b32a03c35889 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
5898 | 5898 | 20200613 | IN | 39543 | 301094 | 340637 | 871 | 6349 | 316 | 1354 | 118 | 28241 | A+ | 6/12/2020 23:59 | 2020-06-12T23:59:00Z | 06/12 19:59 | 2413 | 6349 | 2020-06-12T23:59:00Z | 2231 | 182 | 340637 | 18 | 397 | 5060 | 340637 | posNeg | 5457 | 340637 | 17 | 0 | a43a1962c74a426f0331039c27b897af64efd15e | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5888 | 5888 | 20200613 | CT | 44994 | 305173 | 350167 | 233 | 9912 | 7611 | B | 6/12/2020 20:30 | 2020-06-12T20:30:00Z | 06/12 16:30 | 4186 | 9912 | 2020-06-12T20:30:00Z | 347190 | 42017 | 3342 | 844 | 9 | 305 | 4730 | 350167 | posNeg | 5035 | 350167 | 27 | 0 | 6af6cf90df49c7c408cac4b1002c066ec6c184df | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
5959 | 5959 | 20200612 | MD | 60613 | 339482 | 400095 | 836 | 9923 | 331 | 4474 | B | 6/12/2020 10:00 | 2020-06-12T10:00:00Z | 06/12 06:00 | 2900 | 9923 | 2020-06-12T10:00:00Z | 467564 | 69655 | 60613 | 2773 | 127 | 400095 | 24 | 416 | 7309 | 400095 | posNeg | 7725 | 400095 | 25 | 134 | 42835e64d82d6da89d601fbc0e7c516581f4f973 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
5990 | 5990 | 20200612 | WI | 24795 | 377362 | 172 | 402157 | 287 | 3003 | 104 | 670 | 15783 | A+ | 6/12/2020 16:00 | 2020-06-12T16:00:00Z | 06/12 12:00 | 689 | 3003 | 2020-06-12T16:00:00Z | 22246 | 689 | 399608 | 55 | 354 | 11308 | 402329 | posNeg | 11662 | 402157 | 7 | 27 | 328785725657b2f213b9f73c9c3ade2e62a52929 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5906 | 5906 | 20200613 | MN | 30465 | 387245 | 417710 | 390 | 3581 | 191 | 1104 | 25620 | A | 6/12/2020 17:00 | 2020-06-12T17:00:00Z | 06/12 13:00 | 1314 | 3581 | 2020-06-12T17:00:00Z | 30465 | 1283 | 31 | 417710 | 27 | 2 | 9656 | 417710 | posNeg | 9658 | 417710 | 9 | 24 | e262735da28d3abba7740d9ff2d3a7a53ec5af98 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5930 | 5930 | 20200613 | VA | 53869 | 406124 | 283 | 484215 | 959 | 8090 | 295 | 142 | 7131 | A+ | 6/12/2020 17:00 | 2020-06-12T17:00:00Z | 06/12 13:00 | 1541 | 8090 | 2020-06-12T17:00:00Z | 63856 | 51499 | 1435 | 106 | 484215 | 51 | 658 | 8805 | 460276 | posNeg | 10561 | 459993 | 7 | 62 | e3c49b4be54b38db01cd2e52e1c49b5ef8c462f0 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
5957 | 5957 | 20200612 | LA | 44995 | 434539 | 479534 | 549 | 74 | 33904 | B | 6/12/2020 13:00 | 2020-06-12T13:00:00Z | 06/12 09:00 | 2996 | 2020-06-12T13:00:00Z | 44995 | 2883 | 113 | 479534 | 22 | 523 | 9338 | 479534 | posNeg | 9861 | 479534 | 9 | 0 | f9f9f03ed3b9157dfcfce8004f2fc3c215e58c2b | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
5989 | 5989 | 20200612 | WA | 27155 | 459231 | 486386 | 226 | 3772 | 8 | B | 6/12/2020 02:59 | 2020-06-12T02:59:00Z | 06/11 22:59 | 1194 | 3772 | 2020-06-12T02:59:00Z | 27155 | 1194 | 486386 | 422770 | 53 | 388 | 9249 | 486386 | posNeg | 9637 | 486386 | 4 | -1 | fcc11d3b62382d36640a8bfe67b5111eb8a8797a | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
5933 | 5933 | 20200613 | WA | 27348 | 465461 | 492809 | 225 | 3817 | 43 | B | 6/12/2020 02:59 | 2020-06-12T02:59:00Z | 06/11 22:59 | 1204 | 3817 | 2020-06-12T02:59:00Z | 27348 | 1204 | 492809 | 428859 | 53 | 193 | 6230 | 492809 | posNeg | 6423 | 492809 | 10 | 45 | 8f2c5588de0a0d840ceef50f19e3f2b1ca880e37 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
5975 | 5975 | 20200612 | OH | 40424 | 483294 | 523718 | 547 | 6814 | 217 | 1745 | 144 | B | 6/12/2020 14:00 | 2020-06-12T14:00:00Z | 06/12 10:00 | 2508 | 6814 | 2020-06-12T14:00:00Z | 520813 | 37519 | 2280 | 228 | 39 | 420 | 10715 | 523718 | posNeg | 11135 | 523718 | 18 | 61 | 30cad72cb61e7ed0046a8f5e62d2766e234e3805 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5978 | 5978 | 20200612 | PA | 77999 | 488385 | 566384 | 899 | 202 | 56939 | A+ | 6/12/2020 00:00 | 2020-06-12T00:00:00Z | 06/11 20:00 | 6162 | 2020-06-12T00:00:00Z | 75800 | 564185 | 42 | 66 | 11946 | 566384 | posNeg | 12012 | 566384 | 49 | 0 | aa3d83fde5abab94a5aa21aeaa622502356a9024 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
5983 | 5983 | 20200612 | TN | 29126 | 561047 | 590173 | 608 | 2049 | 19425 | B | 6/12/2020 15:00 | 2020-06-12T15:00:00Z | 06/12 11:00 | 468 | 2049 | 2020-06-12T15:00:00Z | 594960 | 33913 | 561047 | 28942 | 447 | 21 | 47 | 588 | 54291 | 590173 | posNeg | 54879 | 590173 | 27 | 38 | aa8989d3b9f316f44e3e5f97a6ecbdd2beb55535 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5948 | 5948 | 20200612 | GA | 55783 | 536175 | 586426 | 836 | 9181 | 2021 | A | 6/12/2020 14:50 | 2020-06-12T14:50:00Z | 06/12 10:50 | 2418 | 9181 | 2020-06-12T14:50:00Z | 586426 | 50251 | 536175 | 55783 | 110825 | 6504 | 13 | 810 | 6907 | 591958 | posNeg | 7493 | 591958 | 43 | 108 | 081a6607d636cd6ccb3357203524dab02e04bdd6 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5967 | 5967 | 20200612 | NC | 41249 | 554448 | 595697 | 760 | 23653 | A | 6/12/2020 12:12 | 2020-06-12T12:12:00Z | 06/12 08:12 | 1092 | 2020-06-12T12:12:00Z | 595697 | 41249 | 1092 | 37 | 1768 | 21252 | 595697 | posNeg | 23020 | 595697 | 28 | 0 | 6dd1ba2ce5209548eab15d8f04e59b8dbc709b47 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||||
5958 | 5958 | 20200612 | MA | 105059 | 588300 | 891121 | 1143 | 10726 | 276 | 170 | 88725 | A+ | 6/12/2020 10:00 | 2020-06-12T10:00:00Z | 06/12 06:00 | 7538 | 10726 | 2020-06-12T10:00:00Z | 891121 | 132202 | 100811 | 7382 | 156 | 689111 | 55784 | 25 | 392 | 9879 | 693359 | totalTestsViral | 13004 | 693359 | 46 | 72 | 286c8ada6109ff7db59a142d2c95bf9167ed69fa | 0 | 0 | 0 | 0 | 0 | |||||||||||||||
5961 | 5961 | 20200612 | MI | 65672 | 720615 | 786287 | 636 | 253 | 139 | 42041 | A+ | 6/12/2020 00:00 | 2020-06-12T00:00:00Z | 06/11 20:00 | 5990 | 2020-06-12T00:00:00Z | 802036 | 81421 | 720615 | 59621 | 5745 | 245 | 122843 | 26 | 223 | 15544 | 786287 | posNeg | 15767 | 786287 | 5 | 0 | 81ed9807088938b5e06e65b3bb79215237b6206a | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||
5971 | 5971 | 20200612 | NJ | 166164 | 889232 | 1055396 | 1480 | 18607 | 415 | 300 | 28509 | A+ | 6/12/2020 13:00 | 2020-06-12T13:00:00Z | 06/12 09:00 | 14241 | 18607 | 2020-06-12T13:00:00Z | 1055396 | 166164 | 12489 | 1752 | 34 | 348 | 24255 | 1055396 | posNeg | 24603 | 1055396 | 49 | 115 | 052c0c6dbe187cab943349f67ce1a561f50277c7 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||
5953 | 5953 | 20200612 | IL | 132059 | 1015903 | 1147962 | 2209 | 648 | 375 | A | 6/12/2020 00:00 | 2020-06-12T00:00:00Z | 06/11 20:00 | 6441 | 2020-06-12T00:00:00Z | 1147101 | 131198 | 6260 | 181 | 17 | 732 | 24179 | 1147962 | posNeg | 24911 | 1147962 | 78 | 0 | 502214851a500c0f571455f67c62fa8a56d4e7c0 | 0 | 0 | 0 | 0 | 0 | |||||||||||||||||||||
5984 | 5984 | 20200612 | TX | 83680 | 1143277 | 1226957 | 2166 | 55258 | B | 6/12/2020 16:40 | 2020-06-12T16:40:00Z | 06/12 12:40 | 1939 | 2020-06-12T16:40:00Z | 1226957 | 83680 | 143174 | 5925 | 48 | 2097 | 18540 | 1226957 | posNeg | 20637 | 1226957 | 19 | 0 | 1a881e71e264ee690bae39e560b0ee401170f452 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||
5947 | 5947 | 20200612 | FL | 70971 | 1264928 | 1242 | 1335899 | 11986 | A | 6/12/2020 10:00 | 2020-06-12T10:00:00Z | 06/12 06:00 | 2967 | 11986 | 2020-06-12T10:00:00Z | 1571222 | 96007 | 1472224 | 70971 | 2967 | 1336895 | 179109 | 7717 | 171364 | 12 | 1902 | 27249 | 1337141 | posNeg | 29151 | 1335899 | 29 | 136 | 2a715dada79dac4f9958603eb41676fd74b13b8c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||
5942 | 5942 | 20200612 | CA | 141983 | 2520275 | 2662258 | 4480 | 1310 | B | 6/12/2020 00:00 | 2020-06-12T00:00:00Z | 06/11 20:00 | 4943 | 2020-06-12T00:00:00Z | 2662258 | 141983 | 6 | 2702 | 61909 | 2662258 | posNeg | 64611 | 2662258 | 62 | 0 | 3f918dd092abfb315b81ae2180d10a987ce7d75c | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||||||
5974 | 5974 | 20200612 | NY | 381714 | 2419686 | 2801400 | 1898 | 89995 | 552 | 387 | 68399 | A | 6/12/2020 00:00 | 2020-06-12T00:00:00Z | 06/11 20:00 | 24495 | 89995 | 2020-06-12T00:00:00Z | 381714 | 2801400 | 36 | 822 | 71573 | 2801400 | posNeg | 72395 | 2801400 | 53 | 0 | eb41611a881d6ea5556bdd88ba2ef8347658d216 | 0 | 0 | 0 | 0 | 0 | ||||||||||||||||||||
5918 | 5918 | 20200613 | NY | 382630 | 2489610 | 2872240 | 1734 | 89995 | 517 | 360 | 68584 | A | 6/12/2020 00:00 | 2020-06-12T00:00:00Z | 06/11 20:00 | 24527 | 89995 | 2020-06-12T00:00:00Z | 382630 | 2872240 | 36 | 916 | 69924 | 2872240 | posNeg | 70840 | 2872240 | 32 | 0 | da7a04666d7c6d0bf9c62bb2fae5c1204c22f550 | 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 );