| Name | n3_chennan_medical_condition_nhs_uk |
|---|---|
| Data | 1.17G (+ 1.16G) |
| Tables | 13 (+ 9) |
| Columns | 58 (+ 37) |
| Table Rows | 137,426 (+ 133,566) |
| Media | 388.23M (+ 388.23M) |
| Files | 22,140 (+ 22,140) |
| Last Commit | 2023-06-19 18:36:38 (+ 169 d) |
This is a medications drug information database having 4,148 records for consumers and medical health professionals. Each record consists of medication, letter, class, title, generic name, brand name and editor.
From this medication information data, there are 33,570 detail records of these medications with name, content, content filter and medication id in each and these specific detail informations include brand, drug description, dosage, warnings, side effects, interactions, use, precautions, overdosage & contraindications, clinical pharmacology; 3,479 related drug records; 1,640 drug comparison records; 14,587 comparison detail records with drug comparison id, content and name in each; 206 supplement records and 1,164 supplement detail records with name, content and supplement id in each. Apart from these, there are 22,140 files of these medications and drugs in the 388.23M media set.
The whole medical information data set totally has 13 tables.
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| comparison_detail | 14,587 | name |
100%
|
| content |
100%
|
||
| drug_comparison_id |
100%
|
||
| detail | 33,570 | name |
100%
|
| content |
100%
|
||
| content_filter |
100%
|
||
| medication_id |
100%
|
||
| drug_comparison | 1,640 | comparison |
100%
|
| image_slug | 24,292 | detail_id |
100%
|
| letter | 26 | letter |
100%
|
| medication | 4,148 | medication |
100%
|
| letter |
100%
|
||
| class |
74.04%
|
||
| title |
98.58%
|
||
| generic_name |
98.58%
|
||
| brand_name |
98.58%
|
||
| editor |
65.16%
|
||
| medication_x_drug_comparison | 4,261 | medication_id |
100%
|
| drug_comparison_id |
100%
|
||
| medication_x_related_drug | 41,590 | medication_id |
100%
|
| related_drug_id |
100%
|
||
| medication_x_supplement | 8,463 | medication_id |
100%
|
| supplement_id |
100%
|
||
| related_drug | 3,479 | medication |
100%
|
| supplement | 206 | supplement |
100%
|
| other_name |
92.23%
|
||
| supplement_detail | 1,164 | name |
100%
|
| content |
100%
|
||
| supplement_id |
100%
|
| Size (Bytes) | Files |
|---|---|
| 388.23M | 22,140 |
| Time | Data | Tables | Columns | Rows | Media | Files |
|---|---|---|---|---|---|---|
| 2023-06-19 (+ 169 d) | 1.17G (+ 1.16G) | 13 (+ 9) | 58 (+ 37) | 137,426 (+ 133,566) | 388.23M (+ 388.23M) | 22,140 (+ 22,140) |
| 2023-01-01 (+ 95 d) | 11.25M (+ 0B) | 4 (+ 0) | 21 (+ 0) | 3,860 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2022-09-27 (+ 271 d) | 11.25M (+ 0B) | 4 (+ 0) | 21 (+ 0) | 3,860 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2021-12-30 (+ 115 d) | 11.25M (+ 0B) | 4 (+ 0) | 21 (+ 0) | 3,860 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2021-09-05 (+ 150 d) | 11.25M (+ 0B) | 4 (+ 0) | 21 (+ 0) | 3,860 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2021-04-08 (+ 68 d) | 11.25M (+ 0B) | 4 (+ 0) | 21 (+ 0) | 3,860 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2021-01-29 (+ 120 d) | 11.25M (+ 0B) | 4 (+ 0) | 21 (+ 0) | 3,860 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2020-10-01 (+ 38 d) | 11.25M (+ 0B) | 4 (+ 0) | 21 (+ 0) | 3,860 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2020-08-23 (+ 141 d) | 11.25M (+ 0B) | 4 (+ 0) | 21 (+ 0) | 3,860 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2020-04-04 (+ 196 d) | 11.25M (+ 0B) | 4 (+ 0) | 21 (+ 0) | 3,860 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2019-09-21 (+ 197 d) | 11.25M (+ 0B) | 4 (+ 0) | 21 (+ 0) | 3,860 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2019-03-07 (+ 43 d) | 11.25M (+ 0B) | 4 (+ 0) | 21 (+ 0) | 3,860 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2019-01-23 (+ 44 d) | 11.25M (+ 0B) | 4 (+ 0) | 21 (+ 0) | 3,860 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-12-09 (+ 29 d) | 11.25M (+ 0B) | 4 (+ 0) | 21 (+ 0) | 3,860 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-11-09 (+ 27 d) | 11.25M (- 48K) | 4 (+ 0) | 21 (+ 0) | 3,860 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-10-13 (+ 29 d) | 11.30M (+ 0B) | 4 (+ 0) | 21 (+ 0) | 3,860 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-09-13 (+ 34 d) | 11.30M (+ 0B) | 4 (+ 0) | 21 (+ 0) | 3,860 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-08-09 (+ 27 d) | 11.30M (+ 0B) | 4 (+ 0) | 21 (+ 0) | 3,860 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-07-12 (+ 31 d) | 11.30M (+ 0B) | 4 (+ 0) | 21 (+ 0) | 3,860 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-06-10 (+ 31 d) | 11.30M (+ 0B) | 4 (+ 0) | 21 (+ 0) | 3,860 (+ 0) | 0B (+ 0B) | 0 (+ 0) |
| 2018-05-10 | 11.30M | 4 | 21 | 3,860 | 0B | 0 |
Contact us for pricing to download the latest commit / release of this database.
In the same time, you can also access this data set via API.
Select a membership plan and sign up. Return to this page, click Online Query to access the API query maker. Create and open an API call to acquire the data.
The scanning and profiling of data size increments are done separately from those of the number of rows.
Subscribe to be notified of major data releases and updates.
STAY IN THE LOOP.
