names

52 rows where place_id = 597050

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3627094 1903335 1903335 defendant Wright William yeoman 597050 597050 Wright, William, of Gretford, yeoman 1
3630187 1904291 1904291 defendant Wright William yeoman 597050 597050 Wright, William, of Gretford, yeoman 0
3630191 1904291 1904291 defendant Lokke Henry husbandman 597050 597050 Lokke, Henry, of Gretford, husbandman 4
3630193 1904292 1904292 defendant Wright William yeoman 597050 597050 Wright, William, of Gretford, yeoman 0
3630197 1904292 1904292 defendant Lokke Henry husbandman 597050 597050 Lokke, Henry, of Gretford, husbandman 4
3631547 1904683 1904683 defendant Foster Richard husbandman 597050 597050 Foster, Richard, of Gretford, husbandman 1
3631549 1904683 1904683 defendant Loke Henry husbandman 597050 597050 Loke, Henry, of Gretford, husbandman 3
3636406 1906175 1906175 defendant Maltby Robert husbandman 597050 597050 Maltby, Robert, of Gretford, husbandman 0
3636407 1906175 1906175 defendant Laughton John husbandman 597050 597050 Laughton, John, of Gretford, husbandman 1
3641838 1907897 1907897 defendant Wryght William yeoman 597050 597050 Wryght, William, of Gretford, yeoman 1
3644130 1908597 1908597 defendant Wright William yeoman 597050 597050 Wright, William, of Gretford, yeoman 0
3644135 1908597 1908597 defendant Lokke Henry husbandman 597050 597050 Lokke, Henry, of Gretford, husbandman 5
3658521 1912918 1912918 defendant Wryght William yeoman 597050 597050 Wryght, William, of Gretford, yeoman 0
3659969 1913377 1913377 defendant Wright William yeoman 597050 597050 Wright, William, of Gretford, yeoman 3
3659971 1913378 1913378 defendant Wright William yeoman 597050 597050 Wright, William, of Gretford, yeoman 0
3689128 1922761 1922761 defendant Lokke Henry husbandman 597050 597050 Lokke, Henry, of Gretford, husbandman 4
3691558 1923518 1923518 defendant Wright William yeoman 597050 597050 Wright, William, of Gretford, yeoman 0
3726313 1934500 1934500 defendant Rede John husbandman 597050 597050 Rede, John, of Gretford, husbandman 0
3746949 1940964 1940964 defendant Writhe William (legal representative) 597050 597050 Writhe, William, of Gretford, yeoman, administratrix of 0
3746950 1940964 1940964 defendant Writhe Agnes widow 597050 597050 Writhe, Agnes, of Gretford, widow 1
3958280 2009970 2009970 defendant Fysher Octavius merchant of the staple 597050 597050 Fysher, Octavius, of Gretford, merchant of the staple 5
3972029 2014773 2014773 defendant Browne Robert yeoman 597050 597050 Browne, Robert, of Gretford, yeoman 3
3991897 2021859 2021859 plaintiff Browne Robert yeoman 597050 597050 Browne, Robert, of Gretford, yeoman 0
4219512 2102324 2102324 defendant Bracken Alexander yeoman 597050 597050 Bracken, Alexander, of Gretford, yeoman 0
4219516 2102326 2102326 defendant Humfrey Edmund yeoman 597050 597050 Humfrey, Edmund, of Gretford, yeoman 0
4241544 2110156 2110156 defendant Tayler Thomas yeoman 597050 597050 Tayler, Thomas, of Gretford, yeoman 0
4419506 2170985 2170985 defendant West Geoffrey   597050 597050 West, Geoffrey, of Gretford 0
4429815 2174110 2174110 plaintiff West Ralph (legal representative) 597050 597050 West, Ralph, of Gretford, executor of 0
4464827 2189665 2189665 plaintiff West Ralph   597050 597050 West, Ralph, of Gretford 0
4481779 2195004 2195004 defendant Beauchamp John   597050 597050 Beauchamp, John, of Gretford 0
4510070 2203637 2203637 plaintiff Baly Roger   597050 597050 Baly, Roger, of Gretford 0
4517732 2205936 2205936 plaintiff Daly Roger   597050 597050 Daly, Roger, of Gretford 0
4524621 2208034 2208034 defendant Salman John   597050 597050 Salman, John, of Gretford 0
4538054 2212182 2212182 defendant Walcote John   597050 597050 Walcote, John, of Gretford 0
4540560 2212948 2212948 plaintiff West Margaret   597050 597050 West, Margaret, of Gretford, formerly wife of Ralph 0
4540561 2212948 2212948 plaintiff West Thomas   597050 597050 West, Thomas, of Gretford, son of Thomas 1
4556334 2217921 2217921 defendant Salman John   597050 597050 Salman, John, of Gretford 0
4565480 2220774 2220774 defendant Salman John   597050 597050 Salman, John, of Gretford 0
4860550 2314656 2314656 plaintiff Clopton John miller 597050 597050 Clopton, John, of Gretford, miller 0
5031067 2365959 2365959 defendant Bocher William husbandman 597050 597050 Bocher, William, of Gretford, husbandman 2
5063113 2375503 2375503 defendant Godelok William yeoman 597050 597050 Godelok, William, of Gretford, yeoman 4
5153747 2402255 2402255 defendant Houson Edward husbandman 597050 597050 (Houson, Edward, of Gretford, husbandman 2
5171053 2407257 2407257 defendant Houson Edward husbandman 597050 597050 (Houson, Edward, of Gretford, husbandman 2
5188892 2412486 2412486 defendant Bocher William husbandman 597050 597050 Bocher, William, of Gretford, husbandman 4
5230566 2424553 2424553 defendant Alawe William butcher 597050 597050 Alawe, William, of Gretford, butcher 4
5263311 2434273 2434273 defendant Ongyll William husbandman 597050 597050 Ongyll, William, of Gretford, husbandman 1
5263313 2434274 2434274 defendant Malyn Robert yeoman 597050 597050 Malyn, Robert, of Gretford, yeoman 0
5263315 2434275 2434275 defendant Malyn Robert yeoman 597050 597050 Malyn, Robert, of Gretford, yeoman 0
5435528 2485565 2485565 defendant Wright Henry yeoman 597050 597050 Wright, Henry, of Gretford, yeoman 0
5435529 2485565 2485565 defendant Foster John husbandman 597050 597050 Foster, John, of Gretford, husbandman 1
5606984 2537076 2537076 defendant Wryghte William yeoman 597050 597050 Wryghte, William, of Gretford, yeoman 0
5622903 2551097 2551097 plaintiff West Ralph   597050 597050 West, Ralph, of Gretford 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);