names

20 rows where place_id = 589329

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597240 1866760 1866760 defendant Forde Robert innholder 589329 589329 Forde, Robert, of Milton juxta Gravesend, innholder 1
3649989 1910363 1910363 defendant Burton John hackneyman 589329 589329 Burton, John, of Milton juxta Gravesend, hackneyman 0
3650897 1910647 1910647 defendant Hoker John   589329 589329 Hoker, John, of Milton juxta Gravesend 1
3678728 1919414 1919414 defendant Burton John husbandman 589329 589329 Burton, John, of Milton juxta Gravesend, husbandman 1
4090881 2057028 2057028 defendant Burnam Hugh yeoman 589329 589329 Burnam, Hugh, of Milton juxta Gravesend, yeoman 0
4098530 2059805 2059805 defendant Mayow Thomas gent 589329 589329 Mayow, Thomas, of Milton juxta Gravesend, gent 0
4143984 2076059 2076059 defendant Bowle Christopher yeoman 589329 589329 Bowle, Christopher, of Milton juxta Gravesend, yeoman 0
4143985 2076059 2076059 defendant Davyes Griffin yeoman 589329 589329 Davyes, Griffin, of Milton juxta Gravesend, yeoman 1
4148932 2077746 2077746 defendant Bowle Christopher laborer 589329 589329 Bowle, Christopher, of Milton juxta Gravesend, laborer 0
4772195 2287274 2287274 defendant Spryner John gent 589329 589329 Spryner, John, of Milton near Gravesend, gent 0
4947501 2341212 2341212 defendant Seman Robert husbandman 589329 589329 Seman, Robert, of Milton juxta Gravesend, husbandman 0
5319900 2451038 2451038 defendant Hillys William yeman 589329 589329 Hillys, William, of Milton juxta Gravesend, yeman 0
5343897 2458279 2458279 defendant Bote Robert husbandman 589329 589329 Bote, Robert, of Milton juxta Gravesend, husbandman 0
5343898 2458279 2458279 defendant Hokey Robert barber 589329 589329 Hokey, Robert, of Milton juxta Gravesend, barber 1
5480725 2499197 2499197 defendant Kyrkeby John laborer 589329 589329 Kyrkeby, John, of Milton juxta Gravesend, laborer 1
5487832 2501249 2501249 defendant Colyng John husbandman 589329 589329 Colyng, John, of Milton juxta Gravesend, husbandman 2
5528238 2513389 2513389 defendant Grey Thomas husbandman 589329 589329 Grey, Thomas, of Milton juxta Gravesend, husbandman 4
5553130 2520954 2520954 defendant Godfrey John hosteler 589329 589329 Godfrey, John, of Milton juxta Gravesend, hosteler 0
5579169 2528560 2528560 defendant Hoker John innholder 589329 589329 Hoker, John, of Milton juxta Gravesend, innholder 0
5607870 2537366 2537366 defendant Laurence Richard yeoman 589329 589329 Laurence, Richard, of Milton juxta Gravesend, 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);