names

36 rows where place_id = 626624

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3771230 1948690 1948690 defendant Grene Robert baker 626624 626624 Grene, Robert, of Atherston, Warks, baker 0
3952673 2008005 2008005 defendant Banyster Edward mercer 626624 626624 Banyster, Edward, of Atherston, Warks, mercer 0
3954119 2008514 2008514 defendant Wylson Thomas butcher 626624 626624 Wylson, Thomas, of Atherston, Warks, butcher 0
3978234 2016969 2016969 defendant Breche James vintner 626624 626624 Breche, James, of Atherston, Warks, gent, vintner 0
3978236 2016970 2016970 defendant Hill Robert gent 626624 626624 Hill, Robert, of Atherston, Warks, gent 0
3979926 2017580 2017580 defendant Hill Robert yeoman 626624 626624 Hill, Robert, of Atherston, Warks, yeoman 0
3981394 2018114 2018114 defendant Hill Robert gent 626624 626624 Hill, Robert, of Atherston, Warks, gent 0
3990871 2021493 2021493 defendant Hyll Robert gent 626624 626624 Hyll, Robert, of Atherston, Warks, gent 0
3993802 2022534 2022534 defendant Hyll Robert gent 626624 626624 Hyll, Robert, of Atherston, Warks, gent 0
4048338 2041851 2041851 defendant Mydleton Henry mercer 626624 626624 Mydleton, Henry, of Atherston, Warks, mercer 0
4064008 2047409 2047409 defendant Bowes Ralph gent 626624 626624 Bowes, Ralph, of Atherston, Warks, gent 3
4066372 2048267 2048267 defendant Bowes Edward gent 626624 626624 Bowes, Edward, of Atherston, Warks, gent 0
4068448 2049012 2049012 defendant Hill Robert gent 626624 626624 Hill, Robert, of Atherston, Warks, gent 0
4071941 2050264 2050264 defendant Ratlyf William draper 626624 626624 Ratlyf, William, of Atherston, Warks, draper 0
4095843 2058846 2058846 defendant Bowes Ralph gent 626624 626624 Bowes, Ralph, of Atherston, Warks, gent 1
4107168 2062858 2062858 defendant Drayton Christopher innolder 626624 626624 Drayton, Christopher, of Atherston, Warks, innolder 0
4163351 2082707 2082707 defendant Smyth Thomas laborer 626624 626624 Smyth, Thomas, of Atherston, Warks, laborer 3
4217274 2101539 2101539 defendant Hyll Robert gent 626624 626624 Hyll, Robert, of Atherston, Warks, gent 0
4270974 2119867 2119867 defendant Drayton Hugh carrier 626624 626624 Drayton, Hugh, of Atherston, , Warks, carrier 2
4337722 2142940 2142940 defendant Shetterden Daniel gent 626624 626624 Shetterden, Daniel,of Atherston,Warks, gent 0
4343468 2144992 2144992 defendant Hyll Robert gent 626624 626624 Hyll, Robert, of Atherston, Warks, gent 0
4359202 2150449 2150449 defendant Baker Humphrey gent 626624 626624 Baker, Humphrey, of Atherston, Warks, gent 1
4370433 2154475 2154475 defendant Hill Robert gent 626624 626624 Hill, Robert, of Atherston, Warks, gent 1
4380981 2158313 2158313 defendant Wildye John carpenter 626624 626624 Wildye, John, of Atherston, Warks, carpenter 0
5073225 2378478 2378478 defendant Bate Elizabeth widow 626624 626624 Bate, Elizabeth, of Atherston, Warks, widow 4
5259365 2433051 2433051 defendant Ayleston William baker 626624 626624 Ayleston, William, of Atherston, Warks, baker 0
5263070 2434191 2434191 defendant Clay John glover 626624 626624 Clay, John, of Atherston, Warks, glover 2
5266517 2435277 2435277 defendant Spark William butcher 626624 626624 Spark, William, of Atherston, Warks, butcher 3
5279111 2438998 2438998 defendant Harper Robert gent 626624 626624 Harper, Robert, of Atherston, Warks, gent 0
5279140 2439000 2439000 defendant Chapman Richard chapman 626624 626624 Chapman, Richard, of Atherston, Warks, chapman 0
5281713 2439721 2439721 defendant Tyler Richard   626624 626624 Tyler, Richard, of Atherston, Warks, tile maker 1
5313495 2449065 2449065 defendant Atherston John gent 626624 626624 Atherston, John, of Atherston, Warks, gent 0
5478138 2498487 2498487 defendant Smyth Ralph smith 626624 626624 Smyth, Ralph, of Atherston, Warks, smith 0
5482110 2499587 2499587 defendant Meryman John yeoman 626624 626624 Meryman, John, of Atherston, Warks, yeoman 1
5487238 2501079 2501079 defendant Bate Thomas chandler 626624 626624 Bate, Thomas, of Atherston, Warks, chandler 3
5563390 2523890 2523890 defendant Congulton Hugh yeoman 626624 626624 Congulton, Hugh, of Atherston, Warks, yeoman 2

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);