names

29 rows where place_id = 640632

✎ 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
3856501 1975661 1975661 defendant Saunders William gent 640632 640632 Saunders, William, of Welford, Nhants, gent 2
3867353 1979314 1979314 defendant Saunders William   640632 640632 Saunders, William, of Welford, Nhants 0
3867392 1979329 1979329 plaintiff Saunders William esq 640632 640632 Saunders, William, of Welford, Nhants, esq 0
3953406 2008262 2008262 defendant Saunders Francis esq 640632 640632 Saunders, Francis, of Welford, Nhants, esq 0
4014090 2029768 2029768 plaintiff Saunders Francis gent 640632 640632 Saunders, Francis, of Welford, Nhants, gent 0
4045570 2040867 2040867 plaintiff Saunders Francis gent 640632 640632 Saunders, Francis, of Welford, Nhants, gent 0
4661675 2249491 2249491 defendant Godefrey Philip chapman 640632 640632 Godefrey, Philip, of Welford, Nhants, chapman 1
4769464 2286427 2286427 defendant Leek Thomas husbandman 640632 640632 Leek, Thomas, of Welford, Nhants, husbandman 0
4779563 2289592 2289592 defendant Leyke Thomas drover 640632 640632 Leyke, Thomas, of Welford, Nhants, drover 0
4793937 2294232 2294232 defendant Leek Thomas husbandman 640632 640632 Leek, Thomas, of Welford, Nhants, husbandman 0
5007106 2358968 2358968 defendant Ive Robert yeoman 640632 640632 Ive, Robert, of Welford, Nhants, yeoman 10
5012671 2360543 2360543 defendant Ive Robert yeoman 640632 640632 Ive, Robert, of Welford, Nhants, yeoman 7
5065580 2376239 2376239 defendant Dexter John ostler 640632 640632 Dexter, John, of Welford, Nhants, ostler 4
5164005 2405211 2405211 defendant Aylemere John (legal representative) 640632 640632 Aylemere, John, of Welford, Nhants, executors of 5
5164008 2405211 2405211 defendant Aylmere Thomas yeoman 640632 640632 Aylmere, Thomas, of Welford, Nhants, yeoman 8
5200477 2415899 2415899 defendant Aylmere John   640632 640632 Aylmere, John, of Welford, Nhants, executors 5
5200794 2415991 2415991 defendant Aylmere John (legal representative) 640632 640632 Aylmere, John, of Welford, Nhants, executors of 5
5231036 2424676 2424676 defendant Scarburgh John gent 640632 640632 Scarburgh, John, of Welford, Nhants, gent 2
5231043 2424677 2424677 defendant Skarburgh John gent 640632 640632 Skarburgh, John, of Welford, Nhants, gent 2
5238777 2426931 2426931 defendant Noble John yeoman 640632 640632 Noble, John, of Welford, Nhants, yeoman 3
5242959 2428143 2428143 defendant Starburgh John   640632 640632 Starburgh, John, of Welford, Nhants 0
5242969 2428146 2428146 defendant Scarburgh John gent 640632 640632 Scarburgh, John, of Welford, Nhants, gent 2
5247603 2429457 2429457 defendant Lovett Thomas gent 640632 640632 Lovett, Thomas, of Welford, Nhants, gent 1
5323522 2452117 2452117 defendant Lovett Thomas gent 640632 640632 Lovett, Thomas, of Welford, Nhants, gent 0
5339400 2456893 2456893 defendant Lovet Thomas yeoman 640632 640632 Lovet, Thomas, of Welford, Nhants, yeoman 0
5376256 2468168 2468168 plaintiff Saunders Edward   640632 640632 Saunders, Edward, of Welford, Nhants 0
5378407 2468827 2468827 defendant Gilberd John butcher 640632 640632 Gilberd, John, of Welford, Nhants, butcher 0
5393877 2473311 2473311 defendant Gilbard John butcher 640632 640632 Gilbard, John, of Welford, Nhants, butcher 1
5420250 2480979 2480979 defendant Gilbard John butcher 640632 640632 Gilbard, John, of Welford, Nhants, butcher 1

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);