names

33 rows where place_id = 595619

✎ 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
3621195 1874172 1874172 defendant Hawekys William wheeler 595619 595619 Hawekys, William, of Moseley, wheeler 0
3621196 1874172 1874172 defendant Bedyll Richard husbandman 595619 595619 Bedyll, Richard, of Moseley, husbandman 1
3621197 1874172 1874172 defendant Weld Maurice tailor 595619 595619 Weld, Maurice, of Moseley, tailor 2
3621198 1874172 1874172 defendant Hawkes John wheeler 595619 595619 Hawkes, John, of Moseley, wheeler 3
3621828 1874368 1874368 plaintiff Palmer William   595619 595619 Palmer, William, of Moseley 0
3621829 1874368 1874368 defendant Halyday Richard (legal representative) 595619 595619 Halyday, Richard, of Moseley, husbandman, executors of 0
3736635 1937709 1937709 defendant Webbe Richard husbandman 595619 595619 Webbe, Richard, of Moseley, husbandman 2
3752593 1942740 1942740 defendant Hawkys John (legal representative) 595619 595619 Hawkys, John, of Moseley, wheeler, executrix of 0
3752594 1942740 1942740 defendant Hawkys Agnes widow 595619 595619 Hawkys, Agnes, of Moseley, widow 1
3826129 1966013 1966013 defendant Webbe Richard husbandman 595619 595619 Webbe, Richard, of Moseley, husbandman 0
3847430 1972758 1972758 defendant Geffreys Margaret widow 595619 595619 Geffreys, Margaret, of Moseley, widow 0
3901293 1990657 1990657 defendant Biskar Giles smith 595619 595619 Biskar, Giles, of Moseley, smith 3
3901294 1990657 1990657 defendant Perkys Arthur nailer 595619 595619 Perkys, Arthur, of Moseley, nailer 4
3909969 1993641 1993641 defendant Burne William draper 595619 595619 Burne, William, of Moseley, draper 0
3919291 1996781 1996781 defendant Burne William draper 595619 595619 Burne, William, of Moseley, draper 0
3933280 2001426 2001426 defendant Blakwey Lawrence chaplain 595619 595619 Blakwey, Lawrence, of Moseley, chaplain 0
3941995 2004332 2004332 defendant Welde Richard wheeler 595619 595619 Welde, Richard, of Moseley, wheeler 1
3960569 2010800 2010800 defendant Ellyatt William   595619 595619 Ellyatt, William, of Moseley, wheelwright 1
3960570 2010800 2010800 defendant Elyatt Thomas tailor 595619 595619 Elyatt, Thomas, of Moseley, tailor 2
4005622 2026787 2026787 defendant Parkes George nailer 595619 595619 Parkes, George, of Moseley, nailer 0
4005627 2026788 2026788 defendant Parkes George nailer 595619 595619 Parkes, George, of Moseley, nailer 0
4075257 2051454 2051454 defendant Watton Richard blacksmith 595619 595619 Watton, Richard, of Moseley, blacksmith 3
4147888 2077396 2077396 defendant Sheynton John yeoman 595619 595619 Sheynton, John, of Moseley, yeoman 3
5039118 2368346 2368346 defendant Hobys John gent 595619 595619 Hobys, John, of Moseley, gent 6
5129087 2394991 2394991 defendant Rothwell Thomas husbandman 595619 595619 Rothwell, Thomas, of Moseley, husbandman 1
5152104 2401753 2401753 defendant Bolsewell John husbandman 595619 595619 Bolsewell, John, of Moseley, husbandman 0
5167649 2406261 2406261 defendant Standyn John yeoman 595619 595619 Standyn, John, of Moseley, yeoman 1
5169995 2406960 2406960 defendant Bolsewell John husbandman 595619 595619 Bolsewell, John, of Moseley, husbandman 0
5187324 2412018 2412018 defendant Bosewell John husbandman 595619 595619 Bosewell, John, of Moseley, husbandman 0
5335664 2455738 2455738 defendant Delde Alice widow 595619 595619 Delde, Alice, of Moseley, widow 0
5335665 2455738 2455738 defendant Rotton Walter husbandman 595619 595619 Rotton, Walter, of Moseley, husbandman 1
5335666 2455738 2455738 defendant Rotton Humphrey husbandman 595619 595619 Rotton, Humphrey, of Moseley, husbandman 2
5571897 2526323 2526323 defendant Grene Thomas yeoman 595619 595619 Grene, Thomas, of Moseley, 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);