names

37 rows where place_id = 622646

✎ 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
3748172 1941358 1941358 defendant Dyxson John husbandman 622646 622646 Dyxson, John, of North Dalton, husbandman 0
3860707 1977074 1977074 defendant Hungate William (legal representative) 622646 622646 Hungate, William, of North Dalton, esq, executrix of 0
3860708 1977074 1977074 defendant Hungate Etheldred widow 622646 622646 Hungate, Etheldred, of North Dalton, widow 1
3874966 1981850 1981850 defendant Hungate William (legal representative) 622646 622646 Hungate, William, of North Dalton, esq, executrix of 0
3874967 1981850 1981850 defendant Hungate Etheldreda widow 622646 622646 Hungate, Etheldreda, of North Dalton, widow 1
3997243 2023784 2023784 plaintiff Dugleby Robert yeoman 622646 622646 Dugleby, Robert, of North Dalton, yeoman 0
3997245 2023785 2023785 plaintiff Duglebye Robert yeoman 622646 622646 Duglebye, Robert, of North Dalton, yeoman 0
3997247 2023786 2023786 plaintiff Duglebye Robert yeoman 622646 622646 Duglebye, Robert, of North Dalton, yeoman 0
4034244 2036914 2036914 defendant Harryson William yeoman 622646 622646 Harryson, William, of North Dalton, yeoman 1
4048629 2041959 2041959 defendant Harryson William yeoman 622646 622646 Harryson, William, of North Dalton, yeoman 1
4048632 2041960 2041960 defendant Harryson William yeoman 622646 622646 Harryson, William, of North Dalton, yeoman 1
4065194 2047835 2047835 defendant Dales John yeoman 622646 622646 Dales, John, of North Dalton, yeoman 0
4066995 2048492 2048492 plaintiff Hungate Ralph gent 622646 622646 Hungate, Ralph, of North Dalton, gent 0
4066997 2048493 2048493 plaintiff Hungate Ralph gent 622646 622646 Hungate, Ralph, of North Dalton, gent 0
4403649 2165795 2165795 defendant Ellerker John gent 622646 622646 Ellerker, John, of North Dalton, gent 2
4426079 2172966 2172966 defendant Lencole John   622646 622646 Lencole, John, of North Dalton 0
4426080 2172966 2172966 defendant Noumarchant Robert   622646 622646 Noumarchant, Robert, of North Dalton 1
4464536 2189575 2189575 defendant Breton Robert   622646 622646 Breton, Robert, of North Dalton 0
4464548 2189580 2189580 defendant Couper John chaplain 622646 622646 Couper, John, of North Dalton, chaplain 1
4504675 2202005 2202005 defendant Thorp Robert de   622646 622646 Thorp, Robert de, of North Dalton 1
4534385 2211025 2211025 defendant Thorp Robert de   622646 622646 Thorp, Robert de, of North Dalton 0
4746985 2279621 2279621 defendant Basse Thomas husbandman 622646 622646 Basse, Thomas, of North Dalton, husbandman 0
4769385 2286397 2286397 defendant Kyrk Thomas husbandman 622646 622646 Kyrk, Thomas, of North Dalton, husbandman 1
4799231 2295939 2295939 defendant Jonson Richard husbandman 622646 622646 Jonson, Richard, of North Dalton, husbandman 0
4799232 2295939 2295939 defendant Kyrke Thomas husbandman 622646 622646 Kyrke, Thomas, of North Dalton, husbandman 1
4844514 2309800 2309800 defendant Crauncewyk William   622646 622646 Crauncewyk, William, of North Dalton, franklin 1
4871939 2318202 2318202 defendant Crawnswyk William yeoman 622646 622646 Crawnswyk, William, of North Dalton, yeoman 0
4871940 2318202 2318202 defendant Crawnswyk Robert husbandman 622646 622646 Crawnswyk, Robert, of North Dalton, husbandman 1
4903243 2327624 2327624 defendant Crauncewyk Robert husbandman 622646 622646 Crauncewyk, Robert, of North Dalton, husbandman 0
4903244 2327624 2327624 defendant Sharpe John husbandman 622646 622646 Sharpe, John, of North Dalton, husbandman 1
4903245 2327624 2327624 defendant Basse Thomas husbandman 622646 622646 Basse, Thomas, of North Dalton, husbandman 2
4903247 2327624 2327624 defendant Mitforth Nicholas husbandman 622646 622646 Mitforth, Nicholas, of North Dalton, husbandman 4
4912675 2330469 2330469 defendant Whelpyngton John chaplain 622646 622646 Whelpyngton, John, of North Dalton, chaplain 1
5378887 2468984 2468984 defendant Skeyst John husbandman 622646 622646 Skeyst, John, of North Dalton, husbandman 0
5432679 2484739 2484739 defendant Basse Robert husbandman 622646 622646 Basse, Robert, of North Dalton, husbandman 3
5460956 2493226 2493226 defendant Basse Robert husbandman 622646 622646 Basse, Robert, of North Dalton, husbandman 3
5557311 2522101 2522101 defendant Mill James miller 622646 622646 Mill, James, of North Dalton, miller 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);