names

31 rows where place_id = 654484

✎ 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
3932547 2001174 2001174 defendant Smythe Thomas husbandman 654484 654484 Smythe, Thomas, of Twywell, husbandman 4
4270585 2119740 2119740 defendant Weste Robert husbandman 654484 654484 Weste, Robert, of Twywell or of Twyngeden, Nhants, husbandman 0
4285043 2124701 2124701 defendant Harris Elizabeth widow 654484 654484 Harris, Elizabeth, of Twywell, widow 0
4285044 2124701 2124701 defendant Stratton Robert husbandman 654484 654484 Stratton, Robert, of Twywell, husbandman 1
4285045 2124701 2124701 defendant Dawes Thomas husbandman 654484 654484 Dawes, Thomas, of Twywell, husbandman 2
4285047 2124702 2124702 defendant Harrys Elizabeth widow 654484 654484 Harrys, Elizabeth, of Twywell, widow 0
4285048 2124702 2124702 defendant Stratton Robert husbandman 654484 654484 Stratton, Robert, of Twywell, husbandman 1
4285049 2124702 2124702 defendant Dawes Thomas husbandman 654484 654484 Dawes, Thomas, of Twywell, husbandman 2
4325841 2139015 2139015 defendant Good Anthony yeoman 654484 654484 Good, Anthony, of Twywell, yeoman 0
4421749 2171684 2171684 plaintiff Curteys William   654484 654484 Curteys, William, of Twywell 0
4500946 2200910 2200910 defendant Baxter Thomas   654484 654484 Baxter, Thomas, of Twywell 2
4501003 2200917 2200917 defendant Baxter Thomas   654484 654484 Baxter, Thomas, of Twywell 2
4568635 2221769 2221769 defendant Rogerson Henry   654484 654484 Rogerson, Henry, of Twywell 0
4579886 2225198 2225198 plaintiff Crosseby Richard   654484 654484 Crosseby, Richard, of Twywell, parson 0
4579890 2225198 2225198 defendant Wadenho William   654484 654484 Wadenho, William, of Twywell 1
4611192 2234564 2234564 defendant Bakstere Thomas, sen   654484 654484 Bakstere, Thomas, sen, of Twywell 0
4611195 2234564 2234564 defendant Bakstere Henry   654484 654484 Bakstere, Henry, of Twywell 3
4756963 2282546 2282546 defendant Hamapton John yeoman 654484 654484 Hamapton, John, of Twywell, yeoman 0
4756964 2282546 2282546 defendant Heyne William clerk 654484 654484 Heyne, William, of Twywell, clerk 1
4761838 2284045 2284045 defendant Bette John husbandman 654484 654484 Bette, John, of Twywell, husbandman 0
4761840 2284046 2284046 defendant Bette John husbandman 654484 654484 Bette, John, of Twywell, husbandman 0
4761841 2284046 2284046 defendant Bette Katherine   654484 654484 Bette, Katherine, of Twywell, servant 1
4761843 2284047 2284047 defendant Bette Katherine   654484 654484 Bette, Katherine, of Twywell, servant 0
4858099 2313905 2313905 defendant Campion Thomas yeoman 654484 654484 Campion, Thomas, of Twywell, yeoman 0
4918605 2332334 2332334 defendant Herry Henry husbandman 654484 654484 Herry, Henry, of Twywell, husbandman 1
4970940 2348253 2348253 defendant Taillour John husbandman 654484 654484 Taillour, John, of Twywell, husbandman 0
4972545 2348718 2348718 defendant Godefelowe John clerk 654484 654484 Godefelowe, John, of Twywell, clerk 0
5003043 2357796 2357796 defendant Daundeleyn Richard yeoman 654484 654484 Daundeleyn, Richard, of Twywell, yeoman 1
5025177 2364259 2364259 defendant Benet Thomas   654484 654484 Benet, Thomas, of Twywell, shepherd 0
5617375 2549254 2549254 plaintiff le Reve Robert   654484 654484 le Reve, Robert, of Twywell, son of Adam 0
5634702 2554851 2554851 defendant Hampton Thomas husbandman 654484 654484 Hampton, Thomas, of Twywell, 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);