names

35 rows where place_id = 587043

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590327 1864617 1864617 defendant Peke William mercer 587043 587043 Peke, William, of Blythe, Notts, mercer 0
3905732 1992196 1992196 defendant Burton Robert yeoman 587043 587043 Burton, Robert, of Blythe, Notts, yeoman 0
3919021 1996686 1996686 defendant Swyft Henry mercer 587043 587043 Swyft, Henry, of Blythe, Notts, mercer 2
3919025 1996687 1996687 defendant Swyft Henry mercer 587043 587043 Swyft, Henry, of Blythe, Notts, mercer 2
4065775 2048054 2048054 plaintiff Hewett Francis gent 587043 587043 Hewett, Francis, of Blythe, Notts, gent 0
4098142 2059664 2059664 plaintiff Hewett Francis (legal representative) 587043 587043 Hewett, Francis, of Blythe, Notts, gent, executrix of 0
4247642 2112192 2112192 defendant Ingleby Robert yeoman 587043 587043 Ingleby, Robert, of Blythe, Notts, yeoman 0
4272395 2120342 2120342 defendant Ingleby Robert yeoman 587043 587043 Ingleby, Robert, of Blythe, Notts, yeoman 0
4297940 2129365 2129365 defendant Byngley Richard yeoman 587043 587043 Byngley, Richard, of Blythe, Notts, yeoman 0
4331090 2140698 2140698 defendant Byngley Richard yeoman 587043 587043 Byngley, Richard, of Blythe, Notts, yeoman 0
4553630 2217060 2217060 defendant Watson Adam   587043 587043 Watson, Adam, of Blythe, Notts 3
4671435 2256716 2256716 defendant Lincoln John butcher 587043 587043 Lincoln, John, of blythe, Notts, butcher 0
4677859 2258688 2258688 defendant Bagley Thomas chapman 587043 587043 Bagley, Thomas, of Blythe, Notts, chapman 1
4744977 2279045 2279045 defendant Doncastre William draper 587043 587043 Doncastre, William, of Blythe, Notts, draper 0
4779574 2289597 2289597 defendant Hudson Richard husbandman 587043 587043 Hudson, Richard, of Blythe, Notts, husbandman 0
4779583 2289600 2289600 defendant Hudson Richard husbandman 587043 587043 Hudson, Richard, of Blythe, Notts, husbandman 0
4779591 2289602 2289602 defendant Doncastre William draper 587043 587043 Doncastre, William, of Blythe, Notts, draper 0
4848847 2311102 2311102 defendant Baggeley Thomas draper 587043 587043 Baggeley, Thomas, of Blythe, Notts, draper 0
4848849 2311103 2311103 defendant Baggeley Thomas draper 587043 587043 Baggeley, Thomas, of Blythe, Notts, draper 0
4882681 2321497 2321497 defendant Craven Henry clerk 587043 587043 Craven, Henry, of Blythe, Notts, clerk 2
4886123 2322519 2322519 defendant Adamsone William miller 587043 587043 Adamsone, William, of Blythe, Notts, miller 0
4905640 2328366 2328366 defendant Syngleton Thomas scrivener 587043 587043 Syngleton, Thomas, of Blythe, Notts, scrivener 1
4910419 2329774 2329774 defendant Savage Thomas hosier 587043 587043 Savage, Thomas, of Blythe, Notts, hosier 2
4957542 2344225 2344225 defendant Hudson Richard yeoman 587043 587043 Hudson, Richard, of Blythe, Notts, yeoman 1
5002419 2357616 2357616 defendant Hancok Robert   587043 587043 Hancok, Robert, of Blythe, Notts 2
5047968 2371012 2371012 defendant Baron William ostler 587043 587043 Baron, William, of Blythe, Notts, ostler 0
5137794 2397563 2397563 defendant Warde Henry yeoman 587043 587043 Warde, Henry, of Blythe, Notts, yeoman 4
5194361 2414081 2414081 defendant Warde Henry yeoman 587043 587043 Warde, Henry, of Blythe, Notts, yeoman 4
5302419 2445690 2445690 defendant Fulbaron Agnes widow 587043 587043 Fulbaron, Agnes, of Blythe, Notts, widow 1
5427834 2483279 2483279 defendant Padley Robert chapman 587043 587043 Padley, Robert, of Blythe, Notts, chapman 3
5458217 2492360 2492360 defendant Padley Robert chapman 587043 587043 Padley, Robert, of Blythe, Notts, chapman 2
5458223 2492361 2492361 defendant Padley Robert chapman 587043 587043 Padley, Robert, of Blythe, Notts, chapman 3
5502039 2505560 2505560 defendant Peke John clerk 587043 587043 Peke, John, of Blythe, Notts, clerk 0
5502048 2505561 2505561 defendant Peke John clerk 587043 587043 Peke, John, of Blythe, Notts, clerk 0
5523195 2512084 2512084 defendant Peek John clerk 587043 587043 Peek, John, of Blythe, Notts, clerk 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);