names

21 rows where place_id = 616756

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3715939 1931272 1931272 defendant Adam Robert clerk 616756 616756 Adam, Robert, of Uphill, clerk 0
4100087 2060361 2060361 defendant Hyll alias Mathewe John husbandman 616756 616756 Hyll alias Mathewe, John, of Uphill, husbandman 2
4111087 2064218 2064218 defendant Hoper John husbandman 616756 616756 Hoper, John, of Uphill, husbandman 0
4111088 2064218 2064218 defendant Hordell John husbandman 616756 616756 Hordell, John, of Uphill, husbandman 1
4178019 2087782 2087782 defendant Bragge Walter clerk 616756 616756 Bragge, Walter, of Uphill, clerk 3
4179102 2088167 2088167 defendant Warde William husbandman 616756 616756 Warde, William, of Uphill, husbandman 1
4179106 2088168 2088168 defendant Warde William husbandman 616756 616756 Warde, William, of Uphill, husbandman 1
4197011 2094507 2094507 defendant Warde William husbandman 616756 616756 Warde, William, of Uphill, husbandman 0
4287928 2125729 2125729 defendant Savidge William husbandman 616756 616756 Savidge, William, of Uphill, husbandman 2
4303078 2131204 2131204 defendant Humfrey John   616756 616756 Humfrey, John, of Uphill, or of New Inn, Middx, gent, his son 1
4304882 2131845 2131845 defendant Tucker Richard yeoman 616756 616756 Tucker, Richard, of Uphill, yeoman 0
4386993 2160306 2160306 defendant Carter William husbandman 616756 616756 Carter, William, of Uphill, husbandman 0
4478736 2194016 2194016 defendant Pyndene John   616756 616756 Pyndene, John, of Uphill 0
4837069 2307551 2307551 defendant Edmundes Walter husbandman 616756 616756 Edmundes, Walter, of Uphill, husbandman 0
4978951 2350665 2350665 defendant Hous Henry, senior husbandman 616756 616756 Hous, Henry, senior, of Uphill, husbandman 0
4978952 2350665 2350665 defendant Hous Nicholas husbandman 616756 616756 Hous, Nicholas, of Uphill, husbandman 1
5227147 2423585 2423585 defendant Dee Jenin weaver 616756 616756 Dee, Jenin, of Uphill, weaver 11
5227148 2423585 2423585 defendant Banewell John hosteler 616756 616756 Banewell, John, of Uphill, hosteler 12
5227176 2423586 2423586 defendant Dee Jenin weaver 616756 616756 Dee, Jenin, of Uphill, weaver 11
5227177 2423586 2423586 defendant Banewell John hosteler 616756 616756 Banewell, John, of Uphill, hosteler 12
5317509 2450322 2450322 defendant House John husbandman 616756 616756 House, John, of Uphill, husbandman 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);