names

54 rows where place_id = 591572

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3604867 1869187 1869187 defendant Bryght John husbandman 591572 591572 Bryght, John, of Crawley, husbandman 3
3606769 1869791 1869791 defendant Bocher John butcher 591572 591572 Bocher, John, of Crawley, butcher 0
3606770 1869791 1869791 defendant Gater Richard husbandman 591572 591572 Gater, Richard, of Crawley, husbandman 1
3612222 1871461 1871461 defendant Bawant Richard laborer 591572 591572 Bawant, Richard, of Crawley, laborer 5
3612228 1871461 1871461 defendant Sawyer George laborer 591572 591572 Sawyer, George, of Crawley, laborer 11
3631089 1904549 1904549 defendant Hichman Thomas miller 591572 591572 Hichman, Thomas, of Crawley, miller 0
3631090 1904549 1904549 defendant Smallam Roger husbandman 591572 591572 Smallam, Roger, of Crawley, husbandman 1
3631091 1904549 1904549 defendant Topsall Henry laborer 591572 591572 Topsall, Henry, of Crawley, laborer 2
3631092 1904549 1904549 defendant Shepard Thomas yeoman 591572 591572 Shepard, Thomas, of Crawley, yeoman 3
3631093 1904549 1904549 defendant Mille Thomas laborer 591572 591572 Mille, Thomas, of Crawley, laborer 4
3670352 1916680 1916680 defendant White William innholder 591572 591572 White, William, of Crawley, innholder 0
3670353 1916680 1916680 defendant White Richard yeoman 591572 591572 White, Richard, of Crawley, yeoman 1
3670354 1916680 1916680 defendant Stone Richard husbandman 591572 591572 Stone, Richard, of Crawley, husbandman 2
3670356 1916681 1916681 defendant White William innholder 591572 591572 White, William, of Crawley, innholder 0
3670357 1916681 1916681 defendant White Richard yeoman 591572 591572 White, Richard, of Crawley, yeoman 1
3670358 1916681 1916681 defendant Stone Richard husbandman 591572 591572 Stone, Richard, of Crawley, husbandman 2
3674555 1918094 1918094 defendant Knyght William husbandman 591572 591572 Knyght, William, of Crawley, husbandman 1
3751094 1942270 1942270 defendant Bycheno John husbandman 591572 591572 Bycheno, John, of Crawley, husbandman 1
3774232 1949659 1949659 defendant Rogers Thomas yeoman 591572 591572 Rogers, Thomas, of Crawley, yeoman 0
3809533 1960866 1960866 defendant Fenner John gent 591572 591572 Fenner, John, of Crawley, gent 0
3816475 1963059 1963059 defendant Elys John fletcher 591572 591572 Elys, John, of Crawley, fletcher 2
3816476 1963059 1963059 defendant Symon Roger laborer 591572 591572 Symon, Roger, of Crawley, laborer 3
3835215 1968953 1968953 defendant Berd Denise widow 591572 591572 Berd, Denise, of Crawley, widow 0
3835217 1968954 1968954 defendant Berd Denise widow 591572 591572 Berd, Denise, of Crawley, widow 0
3851612 1974093 1974093 defendant Berd Denise widow 591572 591572 Berd, Denise, of Crawley, widow 0
3851614 1974094 1974094 defendant Berd Denise widow 591572 591572 Berd, Denise, of Crawley, widow 0
3854602 1975083 1975083 defendant Topsell Henry husbandman 591572 591572 Topsell, Henry, of Crawley, husbandman 0
3869456 1980025 1980025 defendant Perkyns William husbandman 591572 591572 Perkyns, William, of Crawley, husbandman 3
3923675 1998231 1998231 defendant Chatfeld John husbandman 591572 591572 Chatfeld, John, of Crawley, husbandman 0
3982892 2018658 2018658 defendant Homwood George mercer 591572 591572 Homwood, George, of Crawley, mercer 0
4083677 2054435 2054435 defendant Seldon Thomas smith 591572 591572 Seldon, Thomas, of Crawley, smith 1
4119134 2067132 2067132 defendant Parker Thomas husbandman 591572 591572 Parker, Thomas, of Crawley, husbandman 3
4127275 2070048 2070048 defendant Longherst Robert husbandman 591572 591572 Longherst, Robert, of Crawley, husbandman 0
4377314 2156962 2156962 defendant Chambers Eustace shoemaker 591572 591572 Chambers, Eustace, of Crawley, shoemaker 0
5076024 2379324 2379324 defendant Browne Thomas butcher 591572 591572 Browne, Thomas, of Crawley, butcher 0
5155171 2402660 2402660 defendant Smyth John smith 591572 591572 Smyth, John, of Crawley, smith 0
5180436 2410020 2410020 defendant Mathewe Richard chapman 591572 591572 Mathewe, Richard, of Crawley, chapman 0
5184545 2411224 2411224 defendant Kyngesmyll Richard weaver 591572 591572 Kyngesmyll, Richard, of Crawley, weaver 2
5184546 2411224 2411224 defendant Cornyssh John tailor 591572 591572 Cornyssh, John, of Crawley, tailor 3
5184551 2411225 2411225 defendant Cornyssh John tailor 591572 591572 Cornyssh, John, of Crawley, tailor 3
5190088 2412843 2412843 defendant Thwaytes Alice widow 591572 591572 Thwaytes, Alice, of Crawley, widow 0
5225801 2423218 2423218 defendant Johnson Mathew gent 591572 591572 (Johnson, Mathew, of Crawley, gent 1
5268826 2435995 2435995 defendant Wody John gent 591572 591572 Wody, John, of Crawley, gent 0
5326863 2453109 2453109 defendant Howley Richard gent 591572 591572 Howley, Richard, of Crawley, gent 0
5331224 2454412 2454412 defendant Arnold William yeoman 591572 591572 Arnold, William, of Crawley, yeoman 1
5331225 2454412 2454412 defendant Arnold Stephen yeoman 591572 591572 Arnold, Stephen, of Crawley, yeoman 2
5331226 2454412 2454412 defendant Benke Richard yeoman 591572 591572 Benke, Richard, of Crawley, yeoman 3
5331227 2454412 2454412 defendant Capten William yeoman 591572 591572 Capten, William, of Crawley, yeoman 4
5331228 2454412 2454412 defendant Clymber Henry yeoman 591572 591572 Clymber, Henry, of Crawley, yeoman 5
5517979 2510468 2510468 defendant Gater Richard yeoman 591572 591572 Gater, Richard, of Crawley, yeoman 0
5537284 2516149 2516149 defendant Gater Richard yeoman 591572 591572 Gater, Richard, of Crawley, yeoman 0
5560839 2523141 2523141 defendant Bechener William husbandman 591572 591572 Bechener, William, of Crawley, husbandman 0
5560841 2523142 2523142 defendant Bechener William husbandman 591572 591572 Bechener, William, of Crawley, husbandman 0
5562523 2523638 2523638 defendant Parker Richard yeoman 591572 591572 Parker, Richard, of Crawley, 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);