names

33 rows where place_id = 716874

✎ 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
4216802 2101373 2101373 defendant Seare Anthony yeoman 716874 716874 Seare, Anthony, of Cranford, yeoman 1
4239755 2109536 2109536 defendant Cannell William husbandman 716874 716874 Cannell, William, of Cranford, or of Draughton, husbandman 0
4275929 2121530 2121530 defendant Goodfellowe Thomas gent 716874 716874 Goodfellowe, Thomas, of Cranford, or of Barnards Inn, Middx, gent 0
4346115 2145895 2145895 defendant Sare Anthony yeoman 716874 716874 Sare, Anthony, of Cranford, yeoman 1
4447482 2184125 2184125 plaintiff Elus John   716874 716874 Elus, John, of Cranford 0
4572011 2222813 2222813 defendant Toppyng William   716874 716874 Toppyng, William, of Cranford 4
4644690 2244529 2244529 defendant Staunton William formerly parson of the church of St Andrew 716874 716874 Staunton William, of Cranford, formerly parson of the church of St Andrew 10
4675612 2257983 2257983 defendant Peyntour William laborer 716874 716874 Peyntour, William, of Cranford, laborer 0
4767522 2285819 2285819 defendant Porchet Thomas husbandman 716874 716874 Porchet, Thomas, of Cranford, husbandman 3
4794907 2294553 2294553 defendant Orlyngbere Thomas ploughman 716874 716874 Orlyngbere, Thomas, of Cranford, ploughman 0
4908328 2329160 2329160 defendant Fostbrook Gerard gent 716874 716874 Fostbrook, Gerard, of Cranford, gent 1
4920196 2332830 2332830 defendant Shelston William butcher 716874 716874 Shelston, William, of Cranford, butcher 1
5044897 2370109 2370109 defendant Munde Richard husbandman 716874 716874 Munde, Richard, of Cranford, husbandman 0
5055246 2373151 2373151 defendant Bonde Thomas husbandman 716874 716874 Bonde, Thomas, of Cranford, husbandman 0
5104001 2387594 2387594 defendant Vyrley John chapman 716874 716874 Vyrley, John, of Cranford, chapman 2
5108990 2389047 2389047 defendant Vyrly John laborer 716874 716874 Vyrly, John, of Cranford, laborer 2
5124977 2393781 2393781 defendant Fosbroke Gerard   716874 716874 Fosbroke, Gerard, of Cranford 0
5133321 2396236 2396236 defendant Fosbroke Gerard   716874 716874 Fosbroke, Gerard, of Cranford 0
5139656 2398074 2398074 defendant Fosbroke Gerard esq 716874 716874 Fosbroke, Gerard, of Cranford, esq 0
5143602 2399265 2399265 defendant Fosbroke Gerard gent 716874 716874 Fosbroke, Gerard, of Cranford, gent 0
5153145 2402063 2402063 defendant Fosbroke Gerard esq 716874 716874 Fosbroke, Gerard, of Cranford, esq 0
5153147 2402064 2402064 defendant Fosbroke Gerard esq 716874 716874 Fosbroke, Gerard, of Cranford, esq 0
5160578 2404186 2404186 defendant Fossebroke Gerard esq 716874 716874 Fossebroke, Gerard, of Cranford, esq 0
5160580 2404187 2404187 defendant Fossebroke Gerard esq 716874 716874 Fossebroke, Gerard, of Cranford, esq 0
5164758 2405426 2405426 defendant Fossebroke Gerard gent 716874 716874 Fossebroke, Gerard, of Cranford, gent 0
5170679 2407145 2407145 defendant Fosbroke Gerard esq 716874 716874 Fosbroke, Gerard, of Cranford, esq 0
5175344 2408479 2408479 defendant Fossebroke Gerard esq 716874 716874 Fossebroke, Gerard, of Cranford, esq 0
5296110 2443852 2443852 defendant Kynge Nicholas husbandman 716874 716874 Kynge, Nicholas, of Cranford, husbandman 2
5521284 2511476 2511476 defendant Smyth William husbandman 716874 716874 Smyth, William, of Cranford, husbandman 2
5521285 2511476 2511476 defendant Salman Richard clerk 716874 716874 Salman, Richard, of Cranford, clerk 3
5521286 2511476 2511476 defendant Parker William yeoman 716874 716874 Parker, William, of Cranford, clerk: Loge, Nicholas, of Cotyngham, yeoman 4
5552875 2520892 2520892 defendant Salman Richard Clerk 716874 716874 Salman, Richard, of Cranford, Clerk 0
5552877 2520893 2520893 defendant Salman Richard clerk 716874 716874 Salman, Richard, of Cranford, 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);