us_daily

Table actions

Data source: Big Local News · About: big-local-datasette

249 rows sorted by negative

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Link rowid date states positive negative ▼ pending hospitalizedCurrently hospitalizedCumulative inIcuCurrently inIcuCumulative onVentilatorCurrently onVentilatorCumulative recovered dateChecked death hospitalized totalTestResults lastModified total posNeg deathIncrease hospitalizedIncrease negativeIncrease positiveIncrease totalTestResultsIncrease hash
49 49 20200809 56 5021433 56965015 3871 48899 332693 9307 15081 2507 1578 1656888 2020-08-09T00:00:00Z 154453 332693 63293095 2020-08-09T00:00:00Z 0 0 616 855 666939 50627 726152 64c9fb3844d9241f8f24c8c42ade7a8abab5ea2c
48 48 20200810 56 5063522 57658417 3966 48635 334347 9216 15158 2533 1592 1670755 2020-08-10T00:00:00Z 154879 334347 64046250 2020-08-10T00:00:00Z 0 0 426 1654 693402 42089 753155 35d44ddf3eb5a96ff7190ecef48077d2c6ad16cf
47 47 20200811 56 5119223 58357174 4118 48498 337062 9136 15331 2415 1612 1714960 2020-08-11T00:00:00Z 156205 337062 64802366 2020-08-11T00:00:00Z 0 0 1326 2715 698757 55701 756116 725adca4a2d2d7050dcba4e28961ea145bf34ad9
46 46 20200812 56 5175357 58796198 4174 47991 340117 9555 15524 2604 1629 1755225 2020-08-12T00:00:00Z 157724 340117 65289850 2020-08-12T00:00:00Z 0 0 1519 3055 439024 56134 487484 7576f0285a8fd08632685961ffb3637c9bee3a87
45 45 20200813 56 5227116 59639733 4239 47218 342802 9487 15629 2579 1649 1774648 2020-08-13T00:00:00Z 158887 342802 66215047 2020-08-13T00:00:00Z 0 0 1163 2685 843535 51759 925197 3335d8cdc79f7296c9c242062f9012cc02581764
44 44 20200814 56 5282752 60438637 4415 45776 345014 9277 15764 2549 1665 1796326 2020-08-14T00:00:00Z 160103 345014 67100533 2020-08-14T00:00:00Z 0 0 1216 2212 798904 55636 885486 9fad47379c9ec1cf404176d271a87c3fa69360d9
43 43 20200815 56 5338901 61131947 4452 44795 347045 9087 15891 2526 1663 1818546 2020-08-15T00:00:00Z 161324 347045 67880152 2020-08-15T00:00:00Z 0 0 1221 2031 693310 56149 779619 1259e5b66fa34706a2084ab3a8eb9fbab61453ef
42 42 20200816 56 5381388 61872546 4302 44046 347694 8958 15924 2481 1665 1833096 2020-08-16T00:00:00Z 161943 347694 68688209 2020-08-16T00:00:00Z 0 0 619 649 740599 42487 808057 a1703641cd5e29a17ed501305e73a8d19680618d
41 41 20200817 56 5419268 62498392 4298 43485 348961 8871 15985 2447 1678 1865580 2020-08-17T00:00:00Z 162350 348961 69374016 2020-08-17T00:00:00Z 0 0 407 1267 625846 37880 685807 f0dc8fd1a247f57771b9822c232a978217d12c48
40 40 20200818 56 5460063 63115251 4412 43758 351234 8866 16123 2468 1695 1889170 2020-08-18T00:00:00Z 163546 351234 70047753 2020-08-18T00:00:00Z 0 0 1196 2273 616859 40795 673737 ef063c3af36e174c22f104f6e4f109767aeea79b
39 39 20200819 56 5505018 63760074 4374 43330 353266 8744 16377 2371 1705 1924875 2020-08-19T00:00:00Z 164966 353266 70751670 2020-08-19T00:00:00Z 0 0 1420 2032 644823 44955 703917 a9067c53ea343be6cf8f910be44d9862c70744d1
38 38 20200820 56 5548776 64394152 4170 41988 355276 8483 16487 2335 1716 1946866 2020-08-20T00:00:00Z 166100 355276 71477960 2020-08-20T00:00:00Z 0 0 1134 2010 634078 43758 726290 88dbf68a505567d95c8480635ea4fae416e8ebbe
37 37 20200821 56 5595337 65091206 4199 40951 357093 8357 16563 2286 1730 1965056 2020-08-21T00:00:00Z 167223 357093 72263009 2020-08-21T00:00:00Z 0 0 1123 1817 697054 46561 785049 db14b58e43f34735e73655b8f9885e3c746d8758
36 36 20200822 56 5641573 65801499 4154 39894 358630 8207 16657 2204 1736 1985493 2020-08-22T00:00:00Z 168252 358630 73057263 2020-08-22T00:00:00Z 0 0 1029 1537 710293 46236 794254 602a36fac87fc308d789abc76165df52845770f8
35 35 20200823 56 5679139 66379446 4149 39017 359404 7949 16697 2131 1737 1997782 2020-08-23T00:00:00Z 168824 359404 73702587 2020-08-23T00:00:00Z 0 0 572 774 577947 37566 645324 cbd9c63f8e61ddaa593a95344d703b824581043c
34 34 20200824 56 5713782 67027456 4143 38673 360453 7851 16787 2118 1764 2020774 2020-08-24T00:00:00Z 169167 360453 74416058 2020-08-24T00:00:00Z 0 0 343 1049 648010 34643 713471 78940931b76a8a2c8396d6b2b2f0cdaa7ca27c17
33 33 20200825 56 5750161 67625238 4091 38779 362452 7863 16920 2163 1789 2053699 2020-08-25T00:00:00Z 170314 362452 75080062 2020-08-25T00:00:00Z 0 0 1147 1999 597782 36379 664004 8ba2ed742b0becd1df56a12052f31ead343c3e61
32 32 20200826 56 5794214 68256910 4081 38401 364325 7737 17046 2142 1809 2084465 2020-08-26T00:00:00Z 171612 364325 75760643 2020-08-26T00:00:00Z 0 0 1298 1873 631672 44053 680581 47bb041a4b7c7a4c5fd0fa922a8e2c1bc55359b5
31 31 20200827 56 5838198 68954986 11168 37464 365993 7717 17181 2125 1831 2101326 2020-08-27T00:00:00Z 172741 365993 76552264 2020-08-27T00:00:00Z 0 0 1129 1668 698076 43984 791621 d1319c6319ca4860583d47e8d6b0b210de25f19b
30 30 20200828 56 5884746 69680696 10428 37239 367588 7558 17304 2086 1856 2118367 2020-08-28T00:00:00Z 173764 367588 77370963 2020-08-28T00:00:00Z 0 0 1023 1595 725710 46548 818699 007e236f8e44a17dce383616ccee5d299c7519fe
29 29 20200829 56 5929247 70400432 11151 36428 368884 7413 17401 2062 1864 2140631 2020-08-29T00:00:00Z 174779 368884 78186385 2020-08-29T00:00:00Z 0 0 1015 1296 719736 44501 815422 55a70a7d6b531ac9251d690972ffe2f09f51fdc9
28 28 20200830 56 5968748 71100440 11148 35726 369564 7268 17439 2055 1870 2153963 2020-08-30T00:00:00Z 175254 369564 78960720 2020-08-30T00:00:00Z 0 0 475 680 700008 39501 774335 6330911a8689924efb2b8542ce4b75de2a67bc29
27 27 20200831 56 6000154 71749439 11128 35352 370380 7043 17537 2077 1877 2184825 2020-08-31T00:00:00Z 175620 370380 79665850 2020-08-31T00:00:00Z 0 0 366 816 648999 31406 705130 c17681a87a3f302565eeac721137a3776dd72496
26 26 20200901 56 6042587 72405542 6647 35271 372217 7090 17655 2042 1902 2202682 2020-09-01T00:00:00Z 176647 372217 80398263 2020-09-01T00:00:00Z 0 0 1027 1837 656103 42433 732413 08308e2b77bf463699a26e246623462723fc1897
25 25 20200902 56 6073190 73019975 9293 35569 373864 7087 17784 2024 1918 2231757 2020-09-02T00:00:00Z 177679 373864 81082167 2020-09-02T00:00:00Z 0 0 1032 1647 614433 30603 683904 4313ca187b2017dcd788a1fae4d8d719d67509d3
24 24 20200903 56 6117904 73699205 9987 34682 375400 6921 17894 2042 1928 2266957 2020-09-03T00:00:00Z 178749 375400 81880356 2020-09-03T00:00:00Z 0 0 1070 1536 679230 44714 798189 7b2471b2f209e34c2943979986acf269c426a215
23 23 20200904 56 6169495 74549817 10118 34099 376639 6924 18012 1995 1943 2283454 2020-09-04T00:00:00Z 179747 376639 82830061 2020-09-04T00:00:00Z 0 0 998 1239 850612 51591 949705 d4ab71ef0c5654ff0f6cc05c77f8708d74cd9fea
22 22 20200905 56 6214400 75310873 9021 33502 377926 6766 18089 1956 1956 2302203 2020-09-05T00:00:00Z 180665 377926 83706621 2020-09-05T00:00:00Z 0 0 918 1287 761056 44905 876560 aaa1a677f08047608e71fa894a262fca59fdd183
21 21 20200906 56 6247517 76013582 8946 32372 378415 6700 18125 1912 1960 2316020 2020-09-06T00:00:00Z 181114 378415 84488974 2020-09-06T00:00:00Z 0 0 449 489 702709 33117 782353 02fd0d24303b64715b8d2157ebbc3890378b2de0
20 20 20200907 56 6276199 76573198 8986 31999 378907 6630 18156 1879 1967 2333583 2020-09-07T00:00:00Z 181339 378907 85104245 2020-09-07T00:00:00Z 0 0 225 492 559616 28682 615271 eb74b9b69d7e66edd72015dac4d82ad29be1ee56
19 19 20200908 56 6298422 77059685 8983 32262 379866 6542 18189 1879 1975 2359111 2020-09-08T00:00:00Z 181697 379866 85644289 2020-09-08T00:00:00Z 0 0 358 959 486487 22223 540044 91779686a6eb0496f5b165cf5b0e45f9b47fa6bb
18 18 20200909 56 6329405 77613114 6551 32562 381926 6646 18322 1903 1994 2387479 2020-09-09T00:00:00Z 182780 381926 86270469 2020-09-09T00:00:00Z 0 0 1083 2060 553429 30983 626180 9ac7c6cdf3a9e6d0c90c407db3cc60dccf78d41e
17 17 20200910 56 6366986 78189575 10530 32421 383458 6531 18453 1925 2008 2403511 2020-09-10T00:00:00Z 183950 383458 86960770 2020-09-10T00:00:00Z 0 0 1170 1532 576461 37581 690301 0b4109f6b912176ed2cad211edef13d456dd8bbf
16 16 20200911 56 6411913 78910645 10813 31421 385011 6379 18549 1715 2031 2417878 2020-09-11T00:00:00Z 184968 385011 87787128 2020-09-11T00:00:00Z 0 0 1018 1553 721070 44927 826358 2a0228699277a3a1d0c24a18ee6be96ae46803fc
15 15 20200912 56 6454000 79717367 10403 30655 386087 6451 18648 1619 2051 2438903 2020-09-12T00:00:00Z 185778 386087 88690493 2020-09-12T00:00:00Z 0 0 810 1076 806722 42087 903365 ae91680c4fd34239b361ce261527c4ffce526a82
14 14 20200913 56 6488453 80329804 10467 29810 386679 6233 18692 1562 2056 2450184 2020-09-13T00:00:00Z 186167 386679 89418713 2020-09-13T00:00:00Z 0 0 389 592 612437 34453 728220 363e4c22825f561c50b0eb1b0da9c49101422e2a
13 13 20200914 56 6522317 80701552 10494 29895 387616 6238 18748 1507 2061 2477942 2020-09-14T00:00:00Z 186571 387616 89864549 2020-09-14T00:00:00Z 0 0 404 937 371748 33864 445836 f413abdc5f6b497a500efc84aaba27e27d840fdb
12 12 20200915 56 6557762 81351140 4966 30328 389107 6310 18847 1572 2071 2495127 2020-09-15T00:00:00Z 187602 389107 90589305 2020-09-15T00:00:00Z 0 0 1031 1491 649588 35445 724756 4d696ccbdcfa5fe19e9c8c2a49a7d3bc8ed2b69b
11 11 20200916 56 6597783 81976741 10587 30278 390624 6308 18961 1651 2090 2525573 2020-09-16T00:00:00Z 188802 390624 91318942 2020-09-16T00:00:00Z 0 0 1200 1517 625601 40021 729637 b4113987b56d6bf2844e68a1c937544a18a96df7
10 10 20200917 56 6641341 82709952 11768 29900 392173 6278 19057 1658 2092 2540334 2020-09-17T00:00:00Z 189665 392173 92160883 2020-09-17T00:00:00Z 0 0 863 1549 733211 43558 841941 432bd71bd052e0ad18c96ecac29082a3a853cf4f
9 9 20200918 56 6688827 83566093 11805 29501 393632 6175 19163 1608 2107 2557862 2020-09-18T00:00:00Z 190566 393632 93145887 2020-09-18T00:00:00Z 0 0 901 1459 856141 47486 985004 6d4c4601411774894c99c91d4c25d4cef25f7131
8 8 20200919 56 6734366 84512983 13217 29035 394699 6070 19243 1577 2111 2577467 2020-09-19T00:00:00Z 191306 394699 94211956 2020-09-19T00:00:00Z 0 0 740 1067 946890 45539 1066069 ad566f5484b15ef7970c88a02dc945717241ae80
7 7 20200920 56 6770661 85303584 13192 28608 395215 6015 19281 1595 2112 2589239 2020-09-20T00:00:00Z 191633 395215 95117279 2020-09-20T00:00:00Z 0 0 327 516 790601 36295 905323 115ac58aff38e5689a3a935446d32695d36e5752
6 6 20200921 56 6810133 85942856 13241 28755 396355 6071 19353 1572 2116 2615974 2020-09-21T00:00:00Z 191920 396355 95842590 2020-09-21T00:00:00Z 0 0 287 1140 639272 39472 725311 35f2217a40f04df2a93c8577b4f1b83a8c97c558
5 5 20200922 56 6859572 86615497 7999 29459 397801 6111 19324 1562 2130 2646959 2020-09-22T00:00:00Z 192774 397801 96612543 2020-09-22T00:00:00Z 0 0 854 1446 672641 49439 769953 b740122e3892c1c8bc2bc5b38bd50e429a1b6cf0
4 4 20200923 56 6898139 87416375 10535 29905 399252 6113 19452 1544 2154 2672338 2020-09-23T00:00:00Z 193931 399252 97536247 2020-09-23T00:00:00Z 0 0 1157 1451 800878 38567 923704 b4fe7067370631b26f8e988fd2524b5691235a09
3 3 20200924 56 6941911 88239824 12008 30043 400840 6168 19555 1560 2177 2710183 2020-09-24T00:00:00Z 194852 400840 98476600 2020-09-24T00:00:00Z 0 0 921 1588 823449 43772 940353 375a88dd29991abc1946cd7f98f4f20a9e37fb5d
2 2 20200925 56 6997437 89096343 10905 29769 402171 6133 19919 1506 2264 2727335 2020-09-25T00:00:00Z 195696 402171 99488275 2020-09-25T00:00:00Z 0 0 844 1331 856519 55526 1011675 8d311e73fe038522a1a6be4bc3202de206ec0adb
1 1 20200926 56 7045170 89982483 11183 29554 403325 6057 20002 1509 2272 2750459 2020-09-26T00:00:00Z 196562 403325 100492536 2020-09-26T00:00:00Z 0 0 866 1154 886140 47733 1004261 e98f5076c72de4a27a283d22756b7d0b9a44d41f

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [us_daily] (
   [date] INTEGER,
   [states] INTEGER,
   [positive] INTEGER,
   [negative] INTEGER,
   [pending] INTEGER,
   [hospitalizedCurrently] INTEGER,
   [hospitalizedCumulative] INTEGER,
   [inIcuCurrently] INTEGER,
   [inIcuCumulative] INTEGER,
   [onVentilatorCurrently] INTEGER,
   [onVentilatorCumulative] INTEGER,
   [recovered] INTEGER,
   [dateChecked] TEXT,
   [death] INTEGER,
   [hospitalized] INTEGER,
   [totalTestResults] INTEGER,
   [lastModified] TEXT,
   [total] INTEGER,
   [posNeg] INTEGER,
   [deathIncrease] INTEGER,
   [hospitalizedIncrease] INTEGER,
   [negativeIncrease] INTEGER,
   [positiveIncrease] INTEGER,
   [totalTestResultsIncrease] INTEGER,
   [hash] TEXT
);