names

34 rows where place_id = 597128

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3627409 1903428 1903428 defendant Sawer William yeoman 597128 597128 Sawer, William, of Carcolston, yeoman 0
3627410 1903428 1903428 defendant Thoroton Alice widow 597128 597128 Thoroton, Alice, of Carcolston, widow 1
3715284 1931068 1931068 defendant Kyrke John husbandman 597128 597128 Kyrke, John, of Carcolston, husbandman 0
3805599 1959694 1959694 defendant Hall Thomas, junior husbandman 597128 597128 Hall, Thomas, junior, of Carcolston, husbandman 0
3805600 1959694 1959694 defendant Leke John husbandman 597128 597128 Leke, John, of Carcolston, husbandman 1
3967245 2013172 2013172 defendant Arnall John husbandman 597128 597128 Arnall, John, of Carcolston, husbandman 0
3967246 2013172 2013172 defendant Warde Richard husbandman 597128 597128 Warde, Richard, of Carcolston, husbandman 1
3967247 2013172 2013172 defendant Stampe Thomas husbandman 597128 597128 Stampe, Thomas, of Carcolston, husbandman 2
3967249 2013173 2013173 defendant Bylledge William husbandman 597128 597128 Bylledge, William, of Carcolston, husbandman 0
3967250 2013173 2013173 defendant Warde Roger husbandman 597128 597128 Warde, Roger, of Carcolston, husbandman 1
4073255 2050726 2050726 defendant Hall Robert husbandman 597128 597128 Hall, Robert, of Carcolston, husbandman 0
4695116 2263964 2263964 defendant Whetley Richard husbandman 597128 597128 Whetley, Richard, of Carcolston, husbandman 2
4705425 2267063 2267063 defendant atte Kirke John husbandman 597128 597128 atte Kirke, John, of Carcolston, husbandman 4
4716492 2270478 2270478 defendant Welbey John husbandman 597128 597128 Welbey, John, of Carcolston, husbandman 0
4716493 2270478 2270478 defendant Borton John husbandman 597128 597128 Borton, John, of Carcolston, husbandman 1
4832248 2306120 2306120 plaintiff Byngham Ralph gent 597128 597128 Byngham, Ralph, of Carcolston, gent 0
4832250 2306120 2306120 defendant Glocestre John gent 597128 597128 Glocestre, John, of Carcolston, gent 0
4832255 2306121 2306121 defendant Hed Thomas husbandman 597128 597128 Hed, Thomas, of Carcolston, husbandman 3
4859145 2314237 2314237 plaintiff Byngham Ralph gent 597128 597128 Byngham, Ralph, of Carcolston, gent 0
4859147 2314237 2314237 defendant Gloucester John esq 597128 597128 Gloucester, John, of Carcolston, esq 0
4868403 2317088 2317088 defendant Gloucestre John esq 597128 597128 Gloucestre, John, of Carcolston, esq 0
4893474 2324658 2324658 defendant Chaworth John yeoman 597128 597128 Chaworth, John, of Carcolston, yeoman 0
4920381 2332891 2332891 defendant Gloucestere John esq 597128 597128 Gloucestere, John, of Carcolston, esq 0
4951052 2342293 2342293 defendant Gloucestre Hugh gent 597128 597128 Gloucestre, Hugh, of Carcolston, gent 0
4958404 2344481 2344481 defendant Byngham John gent 597128 597128 Byngham, John, of Carcolston, gent 0
4985010 2352448 2352448 defendant Byngham John gent 597128 597128 Byngham, John, of Carcolston, gent 0
5069736 2377444 2377444 defendant Glauceter John gent 597128 597128 Glauceter, John, of Carcolston, gent 0
5069737 2377444 2377444 defendant Glauceter Thomas gent 597128 597128 Glauceter, Thomas, of Carcolston, gent 1
5228862 2424050 2424050 defendant Chamber John yeoman 597128 597128 Chamber, John, of Carcolston, yeoman 0
5351679 2460625 2460625 defendant Byngham Thomas (legal representative) 597128 597128 Byngham, Thomas, of Carcolston, executors of 0
5432861 2484795 2484795 defendant Dene John husbandman 597128 597128 Dene, John, of Carcolston, husbandman 1
5432862 2484795 2484795 defendant Broughton John husbandman 597128 597128 Broughton, John, of Carcolston, husbandman 2
5483382 2499976 2499976 defendant Arnold William husbandman 597128 597128 Arnold, William, of Carcolston, husbandman 0
5483384 2499977 2499977 defendant Arnold William husbandman 597128 597128 Arnold, William, of Carcolston, 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);