variables
Data license: CC-BY
7 rows where sourceId = 29562 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: unit, updatedAt, timespan, display, type, createdAt (date), updatedAt (date)
id ▲ | name | unit | description | createdAt | updatedAt | code | coverage | timespan | datasetId | sourceId | shortUnit | display | columnOrder | originalMetadata | grapherConfigAdmin | shortName | catalogPath | dimensions | schemaVersion | processingLevel | processingLog | titlePublic | titleVariant | attributionShort | attribution | descriptionShort | descriptionFromProducer | descriptionKey | descriptionProcessing | licenses | license | grapherConfigETL | type | sort | dataChecksum | metadataChecksum |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
699800 | Patent grants to foreign residents | patents | 2023-05-25 09:50:15 | 2024-07-08 16:28:47 | 1836-2020 | U.S. patent activity since 1790 (USPTO, 2023) 6012 | United States Patent and Trademark Office (2020) 29562 | { "unit": "patents", "numDecimalPlaces": 0 } |
0 | patent_grants__to_foreign_residents__a | grapher/research_development/2023-05-25/us_patents/us_patents#patent_grants__to_foreign_residents__a | 1 | [] |
int | [] |
c7878935de626a6a94ce2f54a1625a56 | 7f0efb50d5c3e63ac0e1c9ecd49fb0a4 | |||||||||||||||||||
699799 | Plant patents | patents | 2023-05-25 09:50:15 | 2024-07-08 16:28:47 | 1931-2020 | U.S. patent activity since 1790 (USPTO, 2023) 6012 | United States Patent and Trademark Office (2020) 29562 | { "unit": "patents", "numDecimalPlaces": 0 } |
0 | plant_patents | grapher/research_development/2023-05-25/us_patents/us_patents#plant_patents | 1 | [] |
int | [] |
3c1e7fee49bfe6f580bb26a60cd1ea96 | 4f101f6c1eb5108dc0a5da376da08eb3 | |||||||||||||||||||
699798 | Design patents | patents | 2023-05-25 09:50:15 | 2024-07-08 16:28:47 | 1836-2020 | U.S. patent activity since 1790 (USPTO, 2023) 6012 | United States Patent and Trademark Office (2020) 29562 | { "unit": "patents", "numDecimalPlaces": 0 } |
0 | design_patents | grapher/research_development/2023-05-25/us_patents/us_patents#design_patents | 1 | [] |
mixed | [] |
8afd17750b4f8d8b7b6259231bffeb34 | b1ea6da0e5f506b8306203c7429f42a0 | |||||||||||||||||||
699797 | Utility/inventions patents | patents | 2023-05-25 09:50:15 | 2024-07-08 16:28:47 | 1790-2020 | U.S. patent activity since 1790 (USPTO, 2023) 6012 | United States Patent and Trademark Office (2020) 29562 | { "unit": "patents", "numDecimalPlaces": 0 } |
0 | utility_patents__e__inventions | grapher/research_development/2023-05-25/us_patents/us_patents#utility_patents__e__inventions | 1 | [] |
int | [] |
d5062d1e6f217cf178e5d2b88eb9155a | 7e678573bf3491ddce29ed0786b70c33 | |||||||||||||||||||
699796 | Plant patent applications | applications | 2023-05-25 09:50:15 | 2024-07-08 16:28:47 | 1930-2020 | U.S. patent activity since 1790 (USPTO, 2023) 6012 | United States Patent and Trademark Office (2020) 29562 | { "unit": "applications", "numDecimalPlaces": 0 } |
0 | plant_patent__applications | grapher/research_development/2023-05-25/us_patents/us_patents#plant_patent__applications | 1 | [] |
int | [] |
7aee52df04df3ab3fb52315d7e9b024c | 2d75b20e0bdca60871e53e2242e93adc | |||||||||||||||||||
699795 | Design patent applications | applications | 2023-05-25 09:50:15 | 2024-07-08 16:28:46 | 1880-2020 | U.S. patent activity since 1790 (USPTO, 2023) 6012 | United States Patent and Trademark Office (2020) 29562 | { "unit": "applications", "numDecimalPlaces": 0 } |
0 | design__patent_applications | grapher/research_development/2023-05-25/us_patents/us_patents#design__patent_applications | 1 | [] |
int | [] |
7bf3feab63ab994a37ca76172fe87402 | 597e855dd237b490787129569e006bce | |||||||||||||||||||
699794 | Utility/inventions patent applications | applications | 2023-05-25 09:50:15 | 2024-07-08 16:28:46 | 1840-2020 | U.S. patent activity since 1790 (USPTO, 2023) 6012 | United States Patent and Trademark Office (2020) 29562 | { "unit": "applications", "numDecimalPlaces": 0 } |
0 | utility__patent__applications__e__inventions | grapher/research_development/2023-05-25/us_patents/us_patents#utility__patent__applications__e__inventions | 1 | [] |
int | [] |
634a15fe69b23785197d938b0d4f7833 | eb417a297c8d75e6b5e792c5736dcd83 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "variables" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(750) NULL , "unit" VARCHAR(255) NOT NULL , "description" TEXT NULL , "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , "updatedAt" DATETIME NULL , "code" VARCHAR(255) NULL , "coverage" VARCHAR(255) NOT NULL , "timespan" VARCHAR(255) NOT NULL , "datasetId" INTEGER NOT NULL , "sourceId" INTEGER NULL , "shortUnit" VARCHAR(255) NULL , "display" TEXT NOT NULL , "columnOrder" INTEGER NOT NULL DEFAULT '0' , "originalMetadata" TEXT NULL , "grapherConfigAdmin" TEXT NULL , "shortName" VARCHAR(255) NULL , "catalogPath" VARCHAR(767) NULL , "dimensions" TEXT NULL , "schemaVersion" INTEGER NOT NULL DEFAULT '1' , "processingLevel" VARCHAR(30) NULL , "processingLog" TEXT NULL , "titlePublic" VARCHAR(512) NULL , "titleVariant" VARCHAR(255) NULL , "attributionShort" VARCHAR(512) NULL , "attribution" TEXT NULL , "descriptionShort" TEXT NULL , "descriptionFromProducer" TEXT NULL , "descriptionKey" TEXT NULL , "descriptionProcessing" TEXT NULL , "licenses" TEXT NULL , "license" TEXT NULL , "grapherConfigETL" TEXT NULL , "type" TEXT NULL , "sort" TEXT NULL , "dataChecksum" VARCHAR(64) NULL , "metadataChecksum" VARCHAR(64) NULL, FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT, FOREIGN KEY("sourceId") REFERENCES "sources" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT ); CREATE UNIQUE INDEX "idx_catalogPath" ON "variables" ("catalogPath"); CREATE UNIQUE INDEX "unique_short_name_per_dataset" ON "variables" ("shortName", "datasetId"); CREATE UNIQUE INDEX "variables_code_fk_dst_id_7bde8c2a_uniq" ON "variables" ("code", "datasetId"); CREATE INDEX "variables_datasetId_50a98bfd_fk_datasets_id" ON "variables" ("datasetId"); CREATE UNIQUE INDEX "variables_name_fk_dst_id_f7453c33_uniq" ON "variables" ("name", "datasetId"); CREATE INDEX "variables_sourceId_31fce80a_fk_sources_id" ON "variables" ("sourceId");