names

40 rows where place_id = 612843

✎ 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
3695294 1924750 1924750 defendant Lane Robert husbandman 612843 612843 Lane, Robert, of Netherton, husbandman 0
3751224 1942307 1942307 defendant Comyn John cordwainer 612843 612843 Comyn, John, of Netherton, cordwainer 0
3801323 1958342 1958342 defendant Branche Giles husbandman 612843 612843 Branche, Giles, of Netherton, husbandman 0
3941074 2004018 2004018 defendant Beamond Humphrey yeoman 612843 612843 Beamond, Humphrey, of Netherton, yeoman 1
4017510 2030966 2030966 defendant Cooke Henry laborer 612843 612843 Cooke, Henry, of Netherton, laborer 0
4023055 2032963 2032963 defendant Rogers Robert clothworker 612843 612843 Rogers, Robert, of Netherton, clothworker 3
4038555 2038429 2038429 defendant Elves John glover 612843 612843 Elves, John, of Netherton, glover 1
4048865 2042037 2042037 defendant Bowstrede alias Willougby Anne widow 612843 612843 Bowstrede alias Willougby, Anne, of Netherton, widow 0
4067421 2048655 2048655 defendant Wheatley Robert yeoman 612843 612843 Wheatley, Robert, of Netherton, yeoman 0
4101619 2060885 2060885 defendant Atkys William nailer 612843 612843 Atkys, William, of Netherton, nailer 0
4101621 2060886 2060886 defendant Atkys William yeoman 612843 612843 Atkys, William, of Netherton, yeoman 0
4110736 2064098 2064098 defendant Thomas William fuller 612843 612843 Thomas, William, of Netherton, fuller 0
4116899 2066341 2066341 defendant Wheatley Robert yeoman 612843 612843 Wheatley, Robert, of Netherton, yeoman 1
4119220 2067167 2067167 defendant Atkys William yeoman 612843 612843 Atkys, William, of Netherton, yeoman 0
4135372 2072970 2072970 defendant Hall Leonard nailer 612843 612843 Hall, Leonard, of Netherton, nailer 2
4142105 2075415 2075415 defendant Atkys William yeoman 612843 612843 Atkys, William, of Netherton, yeoman 0
4151635 2078686 2078686 defendant Lyde George yeoman 612843 612843 Lyde, George, of Netherton, yeoman 0
4163566 2082779 2082779 defendant Atkys William yeoman 612843 612843 Atkys, William, of Netherton, or of Dudley, yeoman 0
4179726 2088381 2088381 defendant Dicconson Thomas clothier 612843 612843 Dicconson, Thomas, of Netherton, clothier 1
4315015 2135363 2135363 defendant Robiloke John laborer 612843 612843 Robiloke, John, of Netherton, laborer 4
4343434 2144979 2144979 defendant Geyland John   612843 612843 Geyland, John, of Netherton, yeoman, hoe maker 1
4402388 2165386 2165386 defendant Clayton John yeoman 612843 612843 Clayton, John, of Netherton, yeoman 1
4451054 2185294 2185294 defendant Mason Roger   612843 612843 Mason, Roger, of Netherton 0
4642287 2243862 2243862 defendant Smyth Henry   612843 612843 Smyth, Henry, of Netherton 0
4642336 2243879 2243879 defendant Heron John   612843 612843 Heron, John, of Netherton 0
4822208 2303027 2303027 defendant Amys Isabel widow 612843 612843 Amys, Isabel, of Netherton, widow 0
4895041 2325115 2325115 defendant Ronde Nicholas husbandman 612843 612843 Ronde, Nicholas, of Netherton, husbandman 0
4895042 2325115 2325115 defendant Bele Robert husbandman 612843 612843 Bele, Robert, of Netherton, husbandman 1
4895043 2325115 2325115 defendant Pope John husbandman 612843 612843 Pope, John, of Netherton, husbandman 2
4895044 2325115 2325115 defendant Fawekes John husbandman 612843 612843 Fawekes, John, of Netherton, husbandman 3
4907104 2328787 2328787 defendant Heron John gent 612843 612843 Heron, John, of Netherton, gent 7
4971615 2348436 2348436 defendant Gille Walter husbandman 612843 612843 Gille, Walter, of Netherton, husbandman 6
4977937 2350363 2350363 defendant Persons William   612843 612843 Persons, William, of Netherton, husbandman, son of Persons, Walter, of Netherton 0
5019676 2362636 2362636 defendant Bysshop Edmund husbandman 612843 612843 Bysshop, Edmund, of Netherton, husbandman 7
5136017 2397043 2397043 defendant atte Wode John husbandman 612843 612843 atte Wode, John, of Netherton, husbandman 4
5163859 2405163 2405163 defendant atte Wode John yeoman 612843 612843 atte Wode, John, of Netherton, yeoman 2
5200337 2415857 2415857 defendant atte Wode John yeoman 612843 612843 atte Wode, John, of netherton, yeoman 2
5290028 2442088 2442088 defendant Darnell John husbandman 612843 612843 Darnell. John, of Netherton, husbandman 0
5446140 2488729 2488729 defendant Bromhall Henry husbandman 612843 612843 Bromhall, Henry, of Netherton, husbandman 4
5455968 2491696 2491696 defendant Carbonell John husbandman 612843 612843 Carbonell, John, of Netherton in Kidderminster, 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);