names

75 rows where place_id = 597264

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3627874 1903576 1903576 defendant Norden William husbandman 597264 597264 Norden, William, of Ore, husbandman 0
3631881 1904781 1904781 defendant Porsyll Thomas husbandman 597264 597264 Porsyll, Thomas, of Ore, husbandman 0
3631882 1904781 1904781 defendant Colwey John yeoman 597264 597264 Colwey, John, of Ore, yeoman 1
3639834 1907271 1907271 defendant Norden William husbandman 597264 597264 Norden, William, of Ore, husbandman 3
3658556 1912929 1912929 defendant Hall William gent 597264 597264 Hall, William, of Ore, gent 0
3658587 1912937 1912937 defendant Hall Richard gent 597264 597264 Hall, Richard, of Ore, gent 0
3673556 1917756 1917756 defendant Hall William gent 597264 597264 Hall, William, of Ore, gent 0
3696197 1925032 1925032 defendant Horner William waterman 597264 597264 Horner, William, of Ore, waterman 0
3712196 1930130 1930130 defendant Halle William yeoman 597264 597264 Halle, William, of Ore, yeoman 1
3712202 1930131 1930131 defendant Halle William yeoman 597264 597264 Halle, William, of Ore, yeoman 1
3716786 1931539 1931539 defendant Rawley David husbandman 597264 597264 Rawley, David, of Ore, husbandman 3
3727481 1934871 1934871 defendant Chaundler John husbandman 597264 597264 Chaundler, John, of Ore, husbandman 0
3727482 1934871 1934871 defendant Polton John husbandman 597264 597264 Polton, John, of Ore, husbandman 1
3731592 1936108 1936108 defendant Hall William gent 597264 597264 Hall, William, of Ore, gent 0
3731593 1936108 1936108 defendant Hall Richard gent 597264 597264 Hall, Richard, of Ore, gent 1
3731595 1936108 1936108 defendant Kyng John laborer 597264 597264 Kyng, John, of Ore, laborer 3
3736851 1937781 1937781 defendant Hall Robert esq 597264 597264 Hall, Robert, of Ore, esq 1
3744204 1940084 1940084 defendant Hall William gent 597264 597264 Hall, William, of Ore, gent 0
3744205 1940084 1940084 defendant Puksty Thomas yeoman 597264 597264 Puksty, Thomas, of Ore, yeoman 1
3744206 1940084 1940084 defendant Wylles Richard husbandman 597264 597264 Wylles, Richard, of Ore, husbandman 2
3744207 1940084 1940084 defendant Fuller Henry paler 597264 597264 Fuller, Henry, of Ore, paler 3
3750420 1942051 1942051 defendant Hall William gent 597264 597264 Hall, William, of Ore, gent 0
3750421 1942051 1942051 defendant Puksty Thomas yeoman 597264 597264 Puksty, Thomas, of Ore, yeoman 1
3750422 1942051 1942051 defendant Wylles Richard husbandman 597264 597264 Wylles, Richard, of Ore, husbandman 2
3750423 1942051 1942051 defendant Fuller Henry paler 597264 597264 Fuller, Henry, of Ore, paler 3
3759130 1944842 1944842 defendant Hall William gent 597264 597264 Hall, William, of Ore, gent 0
3767470 1947466 1947466 defendant Trewlove Thomas butcher 597264 597264 Trewlove, Thomas, of Ore, butcher 0
3833723 1968478 1968478 defendant Halle Richard gent 597264 597264 Halle, Richard, of Ore, gent 1
3833724 1968478 1968478 defendant Barkeley Adam yeoman 597264 597264 Barkeley, Adam, of Ore, yeoman 2
3847116 1972650 1972650 defendant Russell John husbandman 597264 597264 Russell, John, of Ore, husbandman 0
3866393 1978991 1978991 defendant Rawle William husbandman 597264 597264 Rawle, William, of Ore, husbandman 1
4041118 2039316 2039316 defendant Marchall Richard yeoman 597264 597264 Marchall, Richard, of Ore, yeoman 0
4109214 2063553 2063553 defendant Relff William gent 597264 597264 Relff, William, of Ore, gent 0
4316025 2135718 2135718 defendant Samon Robert yeoman 597264 597264 Samon, Robert, of Ore, yeoman 0
4318244 2136489 2136489 defendant Balden or Baldynge John yeoman 597264 597264 Balden or Baldynge, John, of Ore, yeoman 0
4635325 2241884 2241884 defendant Peyntour John   597264 597264 Peyntour, John, of Ore 5
4652020 2246565 2246565 defendant atte Cherche Lawrence husbandman 597264 597264 atte Cherche, Lawrence, of Ore, husbandman 0
4804157 2297488 2297488 defendant Hoyskyn Richard   597264 597264 Hoyskyn, Richard, of Ore, parson 0
4858131 2313913 2313913 plaintiff Bregge William   597264 597264 Bregge, William, of Ore 0
4860299 2314580 2314580 defendant Clotte John husbandman 597264 597264 Clotte, John, of Ore, husbandman 1
4911135 2329996 2329996 plaintiff Bregge William   597264 597264 Bregge, William, of Ore 0
4911136 2329996 2329996 defendant Bregge William   597264 597264 Bregge, William, of Ore 0
4911137 2329997 2329997 plaintiff Bregges William   597264 597264 Bregges, William, of Ore 0
4933763 2336938 2336938 defendant Halle William gent 597264 597264 Halle, William, of Ore, gent 0
4936707 2337864 2337864 plaintiff Bregges William (legal representative) 597264 597264 Bregges, William, of Ore, executors of 0
4962076 2345564 2345564 plaintiff Bregges William   597264 597264 Bregges, William, of Ore 0
4962080 2345565 2345565 plaintiff Bregges William (legal representative) 597264 597264 Bregges, William, of Ore, executors of 0
4962084 2345566 2345566 plaintiff Bregges William (legal representative) 597264 597264 Bregges, William, of Ore, executors of 0
4962713 2345754 2345754 plaintiff Bryggys or Bregge William, senior (legal representative) 597264 597264 Bryggys or Bregge, William, senior, of Ore, executors of 0
4974072 2349208 2349208 defendant Brigges William (legal representative) 597264 597264 Brigges, William, of Ore, executors of 0
4998903 2356555 2356555 defendant Holbeme Robert husbandman 597264 597264 Holbeme, Robert, of Ore, husbandman 1
5006062 2358658 2358658 defendant Ho_ Thomas shipman 597264 597264 Ho_, Thomas, of Ore, shipman 4
5040719 2368836 2368836 defendant Brigges William husbandman 597264 597264 Brigges, William, of Ore, husbandman 0
5040720 2368836 2368836 defendant Barrowe Gilbert husbandman 597264 597264 Barrowe, Gilbert, of Ore, husbandman 1
5058364 2374048 2374048 plaintiff Curteys John   597264 597264 Curteys, John, of Ore 0
5093382 2384462 2384462 defendant Brygges William husbandman 597264 597264 Brygges, William, of Ore, husbandman 0
5184228 2411131 2411131 defendant Gayt William husbandman 597264 597264 Gayt, William, of Ore, husbandman 1
5219335 2421379 2421379 defendant Gayt William husbandman 597264 597264 Gayt, William, of Ore, husbandman 0
5226989 2423547 2423547 defendant Heyward William husbandman 597264 597264 Heyward, William, of Ore, husbandman 1
5265931 2435098 2435098 defendant Bregge William yeoman 597264 597264 Bregge, William, of Ore, yeoman 0
5265933 2435099 2435099 defendant Brygge William yeoman 597264 597264 Brygge, William, of Ore, yeoman 0
5332096 2454676 2454676 defendant Gayte William husbandman 597264 597264 Gayte, William, of Ore, husbandman 1
5332097 2454676 2454676 defendant Philpot Walter husbandman 597264 597264 Philpot, Walter, of Ore, husbandman 2
5333089 2454967 2454967 defendant Purfeld Richard husbandman 597264 597264 Purfeld, Richard, of Ore, husbandman 1
5335621 2455726 2455726 defendant Philpot Walter husbandman 597264 597264 Philpot, Walter, of Ore, husbandman 0
5335622 2455726 2455726 defendant Thomas Henry husbandman 597264 597264 Thomas, Henry, of Ore, husbandman 1
5348619 2459699 2459699 defendant Philpot Walter husbandman 597264 597264 Philpot, Walter, of Ore, husbandman 1
5354083 2461341 2461341 plaintiff Hall Henry esq 597264 597264 Hall, Henry, of Ore, esq 0
5359506 2463004 2463004 defendant Cantlowe Peter gent 597264 597264 Cantlowe, Peter, of Ore, gent 0
5359547 2463021 2463021 defendant Cantlowe Peter gent 597264 597264 Cantlowe, Peter, of Ore, gent 0
5492611 2502703 2502703 defendant Purfeld Richard husbandman 597264 597264 Purfeld, Richard, of Ore, husbandman 0
5545645 2518714 2518714 defendant Sampson Thomas yeoman 597264 597264 Sampson, Thomas, of Ore, yeoman 1
5594805 2533345 2533345 defendant Morecok Roger husbandman 597264 597264 Morecok, Roger, of Ore, husbandman 0
5594806 2533345 2533345 defendant Norden William husbandman 597264 597264 Norden, William, of Ore, husbandman 1
5605881 2536730 2536730 defendant Sampson Thomas husbandman 597264 597264 Sampson, Thomas, of Ore, husbandman 4

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