names

32 rows where place_id = 592040

✎ 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
3606375 1869661 1869661 defendant Bercole Robert butcher 592040 592040 Bercole, Robert, of Ekton, butcher 0
3611552 1871283 1871283 defendant Hannod John husbandman 592040 592040 Hannod, John, of Ekton, husbandman 0
3614166 1872094 1872094 defendant Ryxston Robert yeoman 592040 592040 Ryxston, Robert, of Ekton, yeoman 0
3751195 1942299 1942299 defendant Byllyng John husbandman 592040 592040 Byllyng, John, of Ekton, husbandman 0
3751196 1942299 1942299 defendant Palady John husbandman 592040 592040 Palady, John, of Ekton, husbandman 1
3751197 1942299 1942299 defendant Maultman Robert husbandman 592040 592040 Maultman, Robert, of Ekton, husbandman 2
3751198 1942299 1942299 defendant Hornesey Thomas husbandman 592040 592040 Hornesey, Thomas, of Ekton, husbandman 3
3788972 1954363 1954363 defendant Billyng Thomas husbandman 592040 592040 Billyng, Thomas, of Ekton, husbandman 0
3788973 1954363 1954363 defendant Palady John husbandman 592040 592040 Palady, John, of Ekton, husbandman 1
3788974 1954363 1954363 defendant Kepe William husbandman 592040 592040 Kepe, William, of Ekton, husbandman 2
3788975 1954363 1954363 defendant Hynsman Henry husbandman 592040 592040 Hynsman, Henry, of Ekton, husbandman 3
3788976 1954363 1954363 defendant Hornesey Thomas husbandman 592040 592040 Hornesey, Thomas, of Ekton, husbandman 4
3788977 1954363 1954363 defendant Maltman Robert husbandman 592040 592040 Maltman, Robert, of Ekton, husbandman 5
4629345 2240109 2240109 defendant Braunfeld alias Carter Thomas   592040 592040 Braunfeld alias Carter, Thomas, of Ekton 0
4748926 2280175 2280175 defendant Fowelere John yeoman 592040 592040 Fowelere, John, of Ekton, yeoman 0
4748928 2280175 2280175 defendant Heerde Robert husbandman 592040 592040 Heerde, Robert, of Ekton, husbandman 2
4748929 2280175 2280175 defendant Preston John tailor 592040 592040 Preston, John, of Ekton, tailor 3
4748930 2280175 2280175 defendant Taillour John husbandman 592040 592040 Taillour, John, of Ekton, husbandman 4
4767535 2285822 2285822 defendant Cook Thomas husbandman 592040 592040 Cook, Thomas, of Ekton, husbandman 2
4943241 2339857 2339857 defendant Shethesby William husbandman 592040 592040 Shethesby, William, of Ekton, husbandman 0
5098302 2385932 2385932 defendant Taillour John husbandman 592040 592040 Taillour, John, of Ekton, husbandman 1
5104099 2387621 2387621 defendant Mungomery John gent 592040 592040 Mungomery, John, of Ekton, gent 0
5115479 2390951 2390951 defendant Shitelworthe John yeoman 592040 592040 Shitelworthe, John, of Ekton, yeoman 2
5231404 2424771 2424771 defendant Montegomery John gent 592040 592040 Montegomery, John, of Ekton, gent 0
5253101 2431074 2431074 defendant Montegomery John gent 592040 592040 Montegomery, John, of Ekton, gent 0
5322043 2451664 2451664 defendant Pope Richard husbandman 592040 592040 Pope, Richard, of Ekton, husbandman 0
5322046 2451665 2451665 defendant Pope Richard husbandman 592040 592040 Pope, Richard, of Ekton, husbandman 0
5322049 2451666 2451666 defendant Pope Richard husbandman 592040 592040 Pope, Richard, of Ekton, husbandman 0
5334790 2455473 2455473 defendant Colles John husbandman 592040 592040 Colles, John, of Ekton, husbandman 1
5495198 2503460 2503460 defendant Mountgomery William gent 592040 592040 Mountgomery, William, of Ekton, gent 0
5512958 2508905 2508905 defendant London Thomas miller 592040 592040 London, Thomas, of Ekton, miller 0
5542726 2517844 2517844 defendant Melton Anthony gent 592040 592040 Melton, Anthony, of Ekton, gent 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);