names

70 rows where place_id = 595156

✎ 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
3619163 1873596 1873596 defendant Pecok William carpenter 595156 595156 Pecok, William, of Cowyk, carpenter 4
3678259 1919255 1919255 defendant Rudde John husbandman 595156 595156 Rudde, John, of Cowyk, husbandman 2
3878090 1982918 1982918 defendant Harryson Thomas husbandman 595156 595156 Harryson, Thomas, of Cowyk, husbandman 0
4436196 2176063 2176063 plaintiff Rotis Alexander de   595156 595156 Rotis, Alexander de, of Cowyk, prior 0
4441290 2182209 2182209 defendant Godewyn John   595156 595156 Godewyn, John, of Cowyk, parson 0
4463607 2189314 2189314 defendant Touker Thomas   595156 595156 Touker, Thomas, of Cowyk 0
4509849 2203569 2203569 plaintiff Camyn John   595156 595156 Camyn, John, of Cowyk 2
4509855 2203570 2203570 plaintiff Camyn John   595156 595156 Camyn, John, of Cowyk 2
4597015 2230310 2230310 defendant Forman John   595156 595156 Forman, John, of Cowyk 0
4636841 2242339 2242339 defendant Poule Robert   595156 595156 Poule, Robert, of Cowyk, parson & clerk 0
4638259 2242734 2242734 defendant Shyt William   595156 595156 Shyt, William, of Cowyk 0
4638261 2242735 2242735 defendant Whit Henry   595156 595156 Whit, Henry, of Cowyk 0
4638262 2242735 2242735 defendant Whit William   595156 595156 Whit, William, of Cowyk 1
4638263 2242735 2242735 defendant Rudde John   595156 595156 Rudde, John, of Cowyk 2
4638266 2242736 2242736 defendant Whyt William   595156 595156 Whyt, William, of Cowyk 0
4674550 2257646 2257646 defendant Holand Richard gent 595156 595156 Holand, Richard, of Cowyk, gent 1
4767651 2285866 2285866 defendant Lyndlay William yeoman 595156 595156 Lyndlay, William, of Cowyk, yeoman 5
4767652 2285866 2285866 defendant Jollan John porter 595156 595156 Jollan, John, of Cowyk, porter 6
4767657 2285866 2285866 defendant Cowyk John de gent 595156 595156 Cowyk, John de, of Cowyk, gent 11
4767658 2285866 2285866 defendant Darnald Thomas gent 595156 595156 Darnald, Thomas, of Cowyk, gent 12
4767660 2285866 2285866 defendant Fyssher William potter 595156 595156 Fyssher, William, of Cowyk, potter 14
4788655 2292508 2292508 defendant Samon Thomas tailor 595156 595156 Samon, Thomas, of Cowyk, tailor 3
4789583 2292814 2292814 defendant Osset William husbandman 595156 595156 Osset, William, of Cowyk, husbandman 1
4789584 2292814 2292814 defendant Osset Richard husbandman 595156 595156 Osset, Richard, of Cowyk, husbandman 2
4790467 2293106 2293106 defendant Sawemon Thomas yeoman 595156 595156 Sawemon, Thomas, of Cowyk, yeoman 1
4790899 2293243 2293243 defendant Dey William husbandman 595156 595156 Dey, William, of Cowyk, husbandman 0
4792026 2293612 2293612 defendant de Cowyk John gent 595156 595156 de Cowyk, John, of Cowyk, gent 0
4792027 2293612 2293612 defendant Darnald Thomas gent 595156 595156 Darnald, Thomas, of Cowyk, gent 1
4792033 2293612 2293612 defendant Lyndlay William yeoman 595156 595156 Lyndlay, William, of Cowyk, yeoman 7
4792034 2293612 2293612 defendant Jallan John porter 595156 595156 Jallan, John, of Cowyk, porter 8
4792040 2293612 2293612 defendant Fyssher William potter 595156 595156 Fyssher, William, of Cowyk, potter 14
4797909 2295529 2295529 defendant Scot Thomas husbandman 595156 595156 Scot, Thomas, of Cowyk, husbandman 2
4804272 2297522 2297522 defendant Dumbawede William   595156 595156 Dumbawede, William, of Cowyk, prior 0
4808267 2298764 2298764 defendant Holand Richard esq 595156 595156 Holand, Richard, of Cowyk, esq 1
4813102 2300214 2300214 defendant Cowyk John yeoman 595156 595156 Cowyk, John, of Cowyk, yeoman 0
4814084 2300506 2300506 defendant Hekke John husbandman 595156 595156 Hekke, John, of Cowyk, husbandman 3
4819652 2302222 2302222 defendant Forman William, junior husbandman 595156 595156 Forman, William, junior, of Cowyk, husbandman 0
4819653 2302222 2302222 defendant Osset John husbandman 595156 595156 Osset, John, of Cowyk, husbandman 1
4819654 2302222 2302222 defendant Ryder John husbandman 595156 595156 Ryder, John, of Cowyk, husbandman 2
4819655 2302222 2302222 defendant White William husbandman 595156 595156 White, William, of Cowyk, husbandman 3
4819657 2302223 2302223 defendant Forman William, junior yeoman 595156 595156 Forman, William, junior, of Cowyk, yeoman 0
4819658 2302223 2302223 defendant Osset John husbandman 595156 595156 Osset, John, of Cowyk, husbandman 1
4819659 2302223 2302223 defendant Ryder John husbandman 595156 595156 Ryder, John, of Cowyk, husbandman 2
4819660 2302223 2302223 defendant White William husbandman 595156 595156 White, William, of Cowyk, husbandman 3
4819673 2302228 2302228 defendant Forman William, junior husbandman 595156 595156 Forman, William, junior, of Cowyk, husbandman 0
4819674 2302228 2302228 defendant Osset John husbandman 595156 595156 Osset, John, of Cowyk, husbandman 1
4819675 2302228 2302228 defendant Ryder John husbandman 595156 595156 Ryder, John, of Cowyk, husbandman 2
4819676 2302228 2302228 defendant White William husbandman 595156 595156 White, William, of Cowyk, husbandman 3
4854571 2312812 2312812 defendant Milner John   595156 595156 Milner, John, of Cowyk 1
4854572 2312812 2312812 defendant Osset John   595156 595156 Osset, John, of Cowyk 2
4854573 2312812 2312812 defendant Hek John   595156 595156 Hek, John, of Cowyk 3
4861415 2314941 2314941 defendant Bony or Bouy John glover 595156 595156 Bony or Bouy, John, of Cowyk, glover 0
4861416 2314941 2314941 defendant Dudeney John, junior laborer 595156 595156 Dudeney, John, junior, of Cowyk, laborer 1
4932929 2336688 2336688 defendant Frensheman Nicholas laborer 595156 595156 Frensheman, Nicholas, of Cowyk, laborer 2
4975563 2349647 2349647 defendant Cowyk John yeoman 595156 595156 Cowyk, John, of Cowyk, yeoman 0
5014433 2361086 2361086 defendant Kneubon John husbandman 595156 595156 Kneubon, John, of Cowyk, husbandman 0
5019993 2362729 2362729 defendant Legh Alvered laborer 595156 595156 Legh, Alvered, of Cowyk, laborer 0
5051349 2372016 2372016 defendant Cowyk John yeoman 595156 595156 Cowyk, John, of Cowyk, yeoman 0
5060551 2374735 2374735 defendant Holand Richard gent 595156 595156 Holand, Richard, of Cowyk, gent 0
5060552 2374735 2374735 defendant Holand Thomas gent 595156 595156 Holand, Thomas, of Cowyk, gent 1
5082960 2381408 2381408 defendant Casson John   595156 595156 Casson, John, of Cowyk, cartwright 1
5095221 2385019 2385019 defendant Okkeden William gent 595156 595156 Okkeden, William, of Cowyk, or of Eton, Berks, gent 0
5137985 2397619 2397619 defendant Dobbe John yeoman 595156 595156 Dobbe, John, of Cowyk, yeoman 3
5137986 2397619 2397619 defendant Bond Hnery husbandman 595156 595156 Bond, Hnery, of Cowyk, husbandman 4
5263378 2434294 2434294 defendant Lylle John dyer 595156 595156 Lylle, John, of Cowyk, dyer 0
5437884 2486264 2486264 defendant Witton John husbandman 595156 595156 Witton, John, of Cowyk, husbandman 2
5567392 2525043 2525043 defendant Scotte John husbandman 595156 595156 Scotte, John, of Cowyk, husbandman 0
5592229 2532565 2532565 defendant Rycard Thomas (legal representative) 595156 595156 Rycard, Thomas, of Cowyk, executor of Cowper, Robert, of Snath, executor of 0
5614647 2548377 2548377 defendant Watson William   595156 595156 Watson, William, of Cowyk 1
5630792 2553637 2553637 defendant Lynnelay William husbandman 595156 595156 Lynnelay, William, of Cowyk, 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);