names

43 rows where place_id = 586263

✎ 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
3588306 1863995 1863995 defendant Morys Thomas husbandman 586263 586263 Morys, Thomas, of Desburgh, husbandman 0
3588326 1864000 1864000 defendant Morys Thomas husbandman 586263 586263 Morys, Thomas, of Desburgh, husbandman 0
3804045 1959186 1959186 defendant Palmer Humphrey husbandman 586263 586263 Palmer, Humphrey, of Desburgh, husbandman 0
3804047 1959187 1959187 defendant Palmer Humphrey husbandman 586263 586263 Palmer, Humphrey, of Desburgh, husbandman 0
3845136 1972039 1972039 defendant Tomson Roger tanner 586263 586263 Tomson, Roger, of Desburgh, tanner 1
4469300 2191069 2191069 plaintiff Bocher John   586263 586263 Bocher, John, of Desburgh 0
4469302 2191070 2191070 plaintiff Bocher John   586263 586263 Bocher, John, of Desburgh, on his own account 0
4475129 2192892 2192892 defendant Norman John   586263 586263 Norman, John, of Desburgh 0
4504369 2201917 2201917 defendant Burdon John   586263 586263 Burdon, John, of Desburgh 0
4511880 2204164 2204164 plaintiff Bocher John   586263 586263 Bocher, John, of Desburgh 0
4637189 2242430 2242430 plaintiff Bocher John   586263 586263 Bocher, John, of Desburgh 0
4647950 2245468 2245468 defendant Burdon John   586263 586263 Burdon, John, of Desburgh, son of Roger 0
4654379 2247243 2247243 plaintiff Bocher John   586263 586263 Bocher, John, of Desburgh 0
4654381 2247244 2247244 plaintiff Bocher John   586263 586263 Bocher, John, of Desburgh 0
4669164 2256062 2256062 plaintiff Bocher John   586263 586263 Bocher, John, of Desburgh 0
4669168 2256063 2256063 plaintiff Bocher John   586263 586263 Bocher, John, of Desburgh 0
4669267 2256095 2256095 defendant Bocher John husbandman 586263 586263 Bocher, John, of Desburgh, husbandman 1
4681469 2259819 2259819 defendant Burdon John, senior husbandman 586263 586263 Burdon, John, senior, of Desburgh, husbandman 4
4683600 2260473 2260473 defendant Burdon John husbandman 586263 586263 Burdon, John, of Desburgh, husbandman 0
4709769 2268412 2268412 defendant Quenburgh John laborer 586263 586263 Quenburgh, John, of Desburgh, laborer 0
4749882 2280438 2280438 defendant Mayhewe William gent 586263 586263 Mayhewe, William, of Desburgh, gent 0
4767303 2285761 2285761 defendant Manton John husbandman 586263 586263 Manton, John, of Desburgh, husbandman 0
4778755 2289331 2289331 plaintiff Bisshoptre John   586263 586263 Bisshoptre, John, of Desburgh 0
4794102 2294289 2294289 defendant Mahewe William gent 586263 586263 Mahewe, William, of Desburgh, gent 0
4859202 2314252 2314252 plaintiff Bysshoptre John   586263 586263 Bysshoptre, John, of Desburgh 1
4881929 2321246 2321246 defendant Pulton John gent 586263 586263 Pulton, John, of Desburgh, gent 0
4957535 2344222 2344222 defendant Burdon John husbandman 586263 586263 Burdon, John, of Desburgh, husbandman 0
4963602 2346031 2346031 defendant Warner John husbandman 586263 586263 Warner, John, of Desburgh, husbandman 0
4963608 2346032 2346032 defendant Warner John husbandman 586263 586263 Warner, John, of Desburgh, husbandman 0
4984638 2352336 2352336 defendant Pulton Thomas gent 586263 586263 Pulton, Thomas, of Desburgh, gent 0
5007085 2358967 2358967 defendant Pulton Thomas gent 586263 586263 Pulton, Thomas, of Desburgh, gent 0
5007096 2358968 2358968 defendant Pulton Thomas gent 586263 586263 Pulton, Thomas, of Desburgh, gent 0
5078959 2380190 2380190 plaintiff Burdon John   586263 586263 Burdon, John, of Desburgh 3
5122834 2393110 2393110 defendant Breuster John husbandman 586263 586263 Breuster, John, of Desburgh, husbandman 0
5462533 2493703 2493703 defendant Bolland John husbandman 586263 586263 Bolland, John, of Desburgh, husbandman 0
5462534 2493703 2493703 defendant Wryght John husbandman 586263 586263 Wryght, John, of Desburgh, husbandman 1
5474082 2497226 2497226 defendant Bolland John husbandman 586263 586263 Bolland, John, of Desburgh, husbandman 0
5474083 2497226 2497226 defendant Wryght John husbandman 586263 586263 Wryght, John, of Desburgh, husbandman 1
5612113 2547522 2547522 defendant Perkyn William   586263 586263 Perkyn, William, of Desburgh 0
5612114 2547522 2547522 defendant Umfrey Andrew   586263 586263 Umfrey, Andrew, of Desburgh 1
5628162 2552769 2552769 defendant Burdon John husbandman 586263 586263 Burdon, John, of Desburgh, husbandman 2
5633119 2554361 2554361 plaintiff Symmesson John   586263 586263 Symmesson, John, of Desburgh 0
5636674 2555416 2555416 plaintiff Wynde John   586263 586263 Wynde, John, of Desburgh 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);