names

34 rows where place_id = 593283

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3611192 1871176 1871176 defendant Pecok William husbandman 593283 593283 Pecok, William, of Garton, husbandman 1
3916294 1995832 1995832 defendant Lokewode Richard gent 593283 593283 Lokewode, Richard, of Garton, gent 2
4054272 2043917 2043917 defendant Santon William husbandman 593283 593283 Santon, William, of Garton, husbandman 0
4174799 2086653 2086653 defendant Richardson Peter yeoman 593283 593283 Richardson, Peter, of Garton, yeoman 1
4178382 2087913 2087913 defendant Hobson Thomas yeoman 593283 593283 Hobson, Thomas, of Garton, yeoman 3
4185815 2090533 2090533 defendant Richardson Thomas husbandman 593283 593283 Richardson, Thomas, of Garton, husbandman 1
4185816 2090533 2090533 defendant Richardson Peter husbandman 593283 593283 Richardson, Peter, of Garton, husbandman 2
4185817 2090533 2090533 defendant Richardson Brian yeoman 593283 593283 Richardson, Brian, of Garton, yeoman 3
4258134 2115691 2115691 defendant Flynton Marmaduke yeoman 593283 593283 Flynton, Marmaduke, of Garton, yeoman 1
4262225 2117037 2117037 defendant Fisher Ralph yeoman 593283 593283 Fisher, Ralph, of Garton, yeoman 2
4262229 2117038 2117038 defendant Fisher Ralph yeoman 593283 593283 Fisher, Ralph, of Garton, yeoman 2
4266196 2118334 2118334 defendant Dixon Thomas yeoman 593283 593283 Dixon, Thomas, of Garton, yeoman 0
4296227 2128749 2128749 defendant Towse Robert yeoman 593283 593283 Towse, Robert, of Garton, yeoman 0
4315185 2135427 2135427 defendant Hill John yeoman 593283 593283 Hill, John, of Garton, yeoman 3
4396361 2163357 2163357 defendant Elrington Thomas husbandman 593283 593283 Elrington, Thomas, of Garton, husbandman 1
4396362 2163357 2163357 defendant Browne Thomas husbandman 593283 593283 Browne, Thomas, of Garton, husbandman 2
4396363 2163357 2163357 defendant Browne John husbandman 593283 593283 Browne, John, of Garton, husbandman 3
4426103 2172974 2172974 plaintiff Neubald Hugh de   593283 593283 Neubald, Hugh de, of Garton 0
4460906 2188478 2188478 defendant Ilkele John de   593283 593283 Ilkele, John de, of Garton 0
4503496 2201663 2201663 defendant Surdyvall John   593283 593283 Surdyvall, John, of Garton 2
4602222 2231912 2231912 defendant Cotoun William   593283 593283 Cotoun, William, of Garton 0
4684152 2260645 2260645 defendant Blyne John husbandman 593283 593283 Blyne, John, of Garton, husbandman 2
4791130 2293325 2293325 defendant Hervy John husbandman 593283 593283 Hervy, John, of Garton, husbandman 0
4802692 2297028 2297028 defendant Garton Robert husbandman 593283 593283 Garton, Robert, of Garton, husbandman 2
4824678 2303760 2303760 defendant Pokthorp Thomas husbandman 593283 593283 Pokthorp, Thomas, of Garton, husbandman 3
4969259 2347764 2347764 defendant Webster Thomas husbandman 593283 593283 Webster, Thomas, of Garton, husbandman 2
5239101 2427029 2427029 defendant Burneby William gent 593283 593283 Burneby, William, of Garton juxta Sledmer, gent 0
5239102 2427029 2427029 defendant Moysyng Richard husbandman 593283 593283 Moysyng, Richard, of Garton juxta Sledmer, husbandman 1
5239103 2427029 2427029 defendant Penson Robert husbandman 593283 593283 Penson, Robert, of Garton juxta Sledmer, husbandman 2
5239104 2427029 2427029 defendant Grayneson Robert husbandman 593283 593283 Grayneson, Robert, of Garton juxta Sledmer, husbandman 3
5309942 2448010 2448010 defendant Wright John husbandman 593283 593283 Wright, John, of Garton, husbandman 0
5511894 2508576 2508576 defendant Wharom William clerk 593283 593283 Wharom, William, of Garton, clerk 1
5511895 2508576 2508576 defendant Gelson John husbandman 593283 593283 Gelson, John, of Garton, husbandman 2
5623603 2551318 2551318 defendant Odard Robert husbandman 593283 593283 Odard Robert, of Garton, husbandman 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);