names

26 rows where place_id = 758704

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4456072 2186921 2186921 plaintiff Nelsthorp Walter   758704 758704 Nelsthorp, Walter, of Allerton by the Water 0
4492492 2198340 2198340 defendant Nelthorp Walter   758704 758704 Nelthorp, Walter, of Allerton by the Water 1
4724868 2273074 2273074 defendant Cook John miller 758704 758704 Cook, John, of Allerton by the water, miller 3
4878901 2320335 2320335 defendant Horsforth Henry husbandman 758704 758704 Horsforth, Henry, of Allerton by the Water, husbandman 0
4997763 2356187 2356187 defendant Watson John husbandman 758704 758704 Watson, John, of Allerton by the water, husbandman 0
4997764 2356187 2356187 defendant Watson Henry husbandman 758704 758704 Watson, Henry, of Allerton by the water, husbandman 1
5093028 2384352 2384352 defendant Shakilton John husbandman 758704 758704 Shakilton, John, of Allerton by the Water, husbandman 0
5303826 2446142 2446142 defendant Banke Peter esq 758704 758704 Banke, Peter, of Allerton by the Water, esq 1
5313681 2449121 2449121 defendant Watson Richard husbandman 758704 758704 Watson, Richard, of Allerton by the Water, husbandman 0
5327590 2453325 2453325 defendant Bank Peter esq 758704 758704 Bank, Peter, of Allerton by the Water, esq 0
5349114 2459853 2459853 defendant Bank Richard gent 758704 758704 Bank, Richard, of Allerton by the Water, gent 0
5349115 2459853 2459853 defendant Bank Peter gent 758704 758704 Bank, Peter, of Allerton by the Water, gent 1
5352949 2461012 2461012 defendant Bank Peter gent 758704 758704 Bank, Peter, of Allerton by the Water, gent 0
5352950 2461012 2461012 defendant Snytall John husbandman 758704 758704 Snytall, John, of Allerton by the Water, husbandman 1
5353886 2461281 2461281 defendant Storre John husbandman 758704 758704 Storre, John, of Allerton by the Water, husbandman 3
5353887 2461281 2461281 defendant Freman Thomas husbandman 758704 758704 Freman, Thomas, of Allerton by the Water, husbandman 4
5381656 2469806 2469806 defendant Dykonson John yeoman 758704 758704 Dykonson, John, of Allerton by the Water, yeoman 0
5389389 2472011 2472011 defendant Dykonson John yeoman 758704 758704 Dykonson, John, of Allerton by the Water, yeoman 0
5392512 2472931 2472931 defendant Bank Peter gent 758704 758704 Bank, Peter, of Allerton by the Water, gent 0
5392513 2472931 2472931 defendant Bank Richard gent 758704 758704 Bank, Richard, of Allerton by the Water, gent 1
5392519 2472931 2472931 defendant Ferman Thomas husbandman 758704 758704 Ferman, Thomas, of Allerton by the Water, husbandman 7
5392520 2472931 2472931 defendant Storre John husbandman 758704 758704 Storre, John, of Allerton by the Water, husbandman 8
5399500 2474936 2474936 plaintiff Dyconson John yeoman 758704 758704 Dyconson, John, of Allerton by the Water, yeoman 0
5402066 2475652 2475652 defendant Dykonson John yeoman 758704 758704 Dykonson, John, of Allerton by the Water, yeoman 0
5414978 2479411 2479411 defendant Dykenson John yeoman 758704 758704 Dykenson, John, of Allerton by the Water, yeoman 0
5454099 2491125 2491125 defendant Dykonson John yeoman 758704 758704 Dykonson, John, of Allerton by the Water, yeoman 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);