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

204 rows where obsid = "0.0" sorted by rowid descending

View and edit SQL

Suggested facets: Year, National_score, Upper CI, Lower CI, State_score

obsid

  • 0.0 · 204
Link rowid ▲ obsid Year Item Name Item Type Item Status Relevant Domain Relevant Subdomain Item Name Item Description National_score Upper CI Lower CI State State_score
7879 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 WY 5.7
7853 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 WY 5.9
7827 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 WY 6.0
7801 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 WY 6.4
7723 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 WV 5.9
7697 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 WV 6.2
7671 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 WV 6.2
7645 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 WV 6.1000000000000005
7567 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 WI 6.300000000000001
7541 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 WI 6.7
7515 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 WI 6.9
7489 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 WI 6.800000000000001
7411 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 WA 6.2
7385 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 WA 6.4
7359 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 WA 6.4
7333 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 WA 6.5
7255 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 VT 6.800000000000001
7229 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 VT 7.0
7203 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 VT 7.0
7177 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 VT 7.2
7099 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 VA 6.7
7073 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 VA 6.800000000000001
7047 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 VA 7.2
7021 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 VA 7.2
6943 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 UT 6.5
6917 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 UT 6.7
6891 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 UT 6.800000000000001
6865 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 UT 7.1000000000000005
6787 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 TX 6.300000000000001
6761 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 TX 6.300000000000001
6735 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 TX 6.4
6709 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 TX 6.5
6631 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 TN 6.1000000000000005
6605 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 TN 6.4
6579 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 TN 6.5
6553 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 TN 6.800000000000001
6475 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 SD 6.0
6449 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 SD 6.300000000000001
6423 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 SD 6.300000000000001
6397 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 SD 6.300000000000001
6319 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 SC 6.300000000000001
6293 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 SC 6.5
6267 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 SC 6.6000000000000005
6241 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 SC 6.7
6163 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 RI 6.5
6137 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 RI 6.800000000000001
6111 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 RI 6.9
6085 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 RI 7.2
6007 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 PA 6.1000000000000005
5981 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 PA 6.6000000000000005
5955 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 PA 6.6000000000000005
5929 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 PA 6.7
5851 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 OR 6.2
5825 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 OR 6.6000000000000005
5799 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 OR 6.5
5773 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 OR 6.7
5695 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 OK 6.0
5669 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 OK 6.2
5643 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 OK 6.2
5617 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 OK 6.6000000000000005
5539 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 OH 5.9
5513 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 OH 5.9
5487 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 OH 5.9
5461 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 OH 6.1000000000000005
5383 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 NY 6.6000000000000005
5357 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 NY 6.6000000000000005
5331 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 NY 6.800000000000001
5305 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 NY 6.9
5227 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 NV 5.5
5201 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 NV 5.7
5175 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 NV 5.800000000000001
5149 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 NV 6.1000000000000005
5071 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 NM 6.0
5045 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 NM 6.0
5019 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 NM 6.2
4993 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 NM 6.2
4915 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 NJ 5.9
4889 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 NJ 6.2
4863 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 NJ 6.300000000000001
4837 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 NJ 6.6000000000000005
4759 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 NH 6.5
4733 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 NH 6.6000000000000005
4707 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 NH 6.7
4681 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 NH 6.800000000000001
4603 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 NE 6.9
4577 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 NE 6.9
4551 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 NE 6.9
4525 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 NE 7.300000000000001
4447 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 ND 6.300000000000001
4421 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 ND 6.4
4395 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 ND 6.5
4369 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 ND 6.800000000000001
4291 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 NC 6.2
4265 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 NC 6.6000000000000005
4239 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 NC 6.7
4213 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 NC 6.7
4135 0.0 2015 overall   Active     Overall Index NHSPI Index 6.199999809 6.32 6.05 MT 6.1000000000000005
4109 0.0 2016 overall   Active     Overall Index NHSPI Index 6.400000095 6.53 6.29 MT 6.2
4083 0.0 2017 overall   Active     Overall Index NHSPI Index 6.5 6.67 6.41 MT 6.4
4057 0.0 2018 overall   Active     Overall Index NHSPI Index 6.699999809 6.8100000000000005 6.55 MT 6.5

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [NHSPI_domains_subdomains] (
   [obsid] TEXT,
   [Year] INTEGER,
   [Item Name] TEXT,
   [Item Type] TEXT,
   [Item Status] TEXT,
   [Relevant Domain] TEXT,
   [Relevant Subdomain] TEXT,
   [Item  Name] TEXT,
   [Item Description] TEXT,
   [National_score] TEXT,
   [Upper CI] TEXT,
   [Lower CI] TEXT,
   [State] TEXT,
   [State_score] TEXT
);