names

45 rows where place_id = 590330

✎ 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
3600667 1867855 1867855 defendant Blakmour Roger yeoman 590330 590330 Blakmour, Roger, of Cokeham, yeoman 0
3662172 1914085 1914085 defendant Blakemore Roger yeoman 590330 590330 Blakemore, Roger, of Cokeham, yeoman 0
3691954 1923645 1923645 defendant Blakemore Roger yeoman 590330 590330 Blakemore, Roger, of Cokeham, yeoman 0
3694092 1924357 1924357 defendant Blakemore Roger yeoman 590330 590330 Blakemore, Roger, of Cokeham, yeoman 0
3707384 1928600 1928600 defendant Premar John husbandman 590330 590330 Premar, John, of Cokeham, husbandman 0
3754238 1943276 1943276 defendant Lote Richard husbandman 590330 590330 Lote, Richard, of Cokeham, husbandman 3
3771478 1948771 1948771 defendant Loote Richard husbandman 590330 590330 Loote, Richard, of Cokeham, husbandman 2
3774719 1949823 1949823 defendant Cokeseter Robert husbandman 590330 590330 Cokeseter, Robert, of Cokeham, husbandman 1
3775290 1950010 1950010 defendant Baker John fuller 590330 590330 Baker, John, of Cokeham, fuller 1
3775291 1950010 1950010 defendant Awsten John, junior fisherman 590330 590330 Awsten, John, junior, of Cokeham, fisherman 2
3777402 1950678 1950678 plaintiff Cley John miller 590330 590330 Cley, John, of Cokeham, miller 0
3777403 1950678 1950678 defendant Radyche Nicholas husbandman 590330 590330 Radyche, Nicholas, of Cokeham, husbandman 0
3777404 1950678 1950678 defendant Warner Stephen husbandman 590330 590330 Warner, Stephen, of Cokeham, husbandman 1
3795525 1956481 1956481 defendant Grynder or Grynden William yeoman 590330 590330 Grynder or Grynden, William, of Cokeham, yeoman 0
3832113 1967952 1967952 defendant ap Ryce John (legal representative) 590330 590330 ap Ryce, John, of Cokeham, yeoman, executors of 0
3832115 1967952 1967952 defendant Lutman Thomas yeoman 590330 590330 Lutman, Thomas, of Cokeham, yeoman 2
3851604 1974090 1974090 defendant Holdernes Thomas husbandman 590330 590330 Holdernes, Thomas, of Cokeham, husbandman 0
3851605 1974090 1974090 defendant Hilton John husbandman 590330 590330 Hilton, John, of Cokeham, husbandman 1
3851606 1974090 1974090 defendant Seriaunt William husbandman 590330 590330 Seriaunt, William, of Cokeham, husbandman 2
3856112 1975533 1975533 defendant Warner John husbandman 590330 590330 Warner, John, of Cokeham, husbandman 1
3866165 1978913 1978913 defendant Holdernes Thomas husbandman 590330 590330 Holdernes, Thomas, of Cokeham, husbandman 0
4666181 2250893 2250893 defendant Louches William gent 590330 590330 Louches, William, of Cokeham, gent 0
4666182 2250893 2250893 defendant Louches John gent 590330 590330 Louches, John, of Cokeham, gent 1
4815297 2300894 2300894 defendant Pynkeneye John gent 590330 590330 Pynkeneye, John, of Cokeham, gent 0
4815300 2300895 2300895 defendant Pynkeneye John gent 590330 590330 Pynkeneye, John, of Cokeham, gent 0
4815303 2300896 2300896 defendant Pynkeneye John gent 590330 590330 Pynkeneye, John, of Cokeham, gent 0
4885796 2322428 2322428 defendant Carmond Nicholas husbandman 590330 590330 Carmond, Nicholas, of Cokeham, husbandman 2
5234110 2425569 2425569 defendant Polhampton William husbandman 590330 590330 Polhampton, William, of Cokeham, husbandman 3
5234111 2425569 2425569 defendant Watlyngton John husbandman 590330 590330 Watlyngton, John, of Cokeham, husbandman 4
5234112 2425569 2425569 defendant Janyns Thomas tiler 590330 590330 Janyns, Thomas, of Cokeham, tiler 5
5256836 2432267 2432267 defendant Monketon John yeoman 590330 590330 Monketon, John, of Cokeham, yeoman 0
5256837 2432267 2432267 defendant Bakemore John husbandman 590330 590330 Bakemore, John, of Cokeham, husbandman 1
5312660 2448823 2448823 defendant Draper Nicholas husbandman 590330 590330 Draper, Nicholas, of Cokeham, husbandman 0
5342970 2457992 2457992 defendant Smallebroke John husbandman 590330 590330 Smallebroke, John, of Cokeham, husbandman 2
5371314 2466607 2466607 defendant Kymber John husbandman 590330 590330 Kymber, John, of Cokeham, husbandman 0
5388902 2471889 2471889 defendant Kember John husbandman 590330 590330 Kember, John, of Cokeham, husbandman 1
5425046 2482455 2482455 defendant Terry John husbandman 590330 590330 Terry, John, of Cokeham, husbandman 0
5510685 2508179 2508179 defendant Carter Roger husbandman 590330 590330 Carter, Roger, of Cokeham, husbandman 1
5519669 2510985 2510985 defendant Warner Richard husbandman 590330 590330 (Warner, Richard, of Cokeham, husbandman 1
5519670 2510985 2510985 defendant Roberdys Thomas husbandman 590330 590330 Roberdys, Thomas, of Cokeham, husbandman 2
5533647 2515071 2515071 plaintiff Wolyngton Thomas   590330 590330 Wolyngton, Thomas, of Cokeham 0
5607985 2537404 2537404 defendant Blakemor Roger husbandman 590330 590330 Blakemor, Roger, of Cokeham, husbandman 1
5607986 2537404 2537404 defendant Noke John husbandman 590330 590330 Noke, John, of Cokeham, husbandman 2
5612953 2547824 2547824 plaintiff Cok John   590330 590330 Cok, John, of Cokeham 0
5612954 2547824 2547824 defendant Spelyng William   590330 590330 Spelyng, William, of Cokeham 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);