names

81 rows where place_id = 586986

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590150 1864558 1864558 defendant Pyke or Tyke William smith 586986 586986 Pyke or Tyke, William, of Lewys, smith 0
3592164 1865169 1865169 defendant Dosard Thomas purser 586986 586986 Dosard, Thomas, of Lewys, purser 1
3644540 1908710 1908710 defendant Marten William yeoman 586986 586986 Marten, William, of Lewys, yeoman 0
3646100 1909180 1909180 defendant Savile Leonard clerk 586986 586986 Savile, Leonard, of Lewys, clerk 0
3720973 1932856 1932856 defendant Legate Hans shoemaker 586986 586986 Legate, Hans, of Lewys, shoemaker 0
3739122 1938444 1938444 defendant Kneller Christopher pardoner 586986 586986 Kneller, Christopher, of Lewys, pardoner 0
3768640 1947839 1947839 defendant Marret Daniel chapman 586986 586986 Marret, Daniel, of Lewys, chapman 2
3776244 1950316 1950316 defendant Fowle Gabriel yeoman 586986 586986 Fowle, Gabriel, of Lewys, yeoman 1
3778674 1951044 1951044 defendant Appowell David   586986 586986 Appowell, David, of Lewys, surgeon 0
3800269 1958005 1958005 defendant Audeley John yeoman 586986 586986 Audeley, John, of Lewys, yeoman 0
3803265 1958926 1958926 defendant Webbeme Robert butcher 586986 586986 Webbeme, Robert, of Lewys, butcher 1
3803266 1958926 1958926 defendant Awdeley or Awdehey John   586986 586986 Awdeley or Awdehey, John, of Lewys, tallow chandler 2
3811651 1961543 1961543 defendant Marten John butcher 586986 586986 Marten, John, of Lewys, butcher 0
3816634 1963104 1963104 defendant Rede Richard laborer 586986 586986 Rede, Richard, of Lewys, laborer 1
3818379 1963647 1963647 defendant Wellyn Robert butcher 586986 586986 Wellyn, Robert, of Lewys, butcher 0
3819050 1963849 1963849 defendant Speke John innholder 586986 586986 Speke, John, of Lewys, innholder 0
3821503 1964620 1964620 defendant Mason John turner 586986 586986 Mason, John, of Lewys, turner 0
3877671 1982773 1982773 defendant Swayne Richard brewer 586986 586986 Swayne, Richard, of Lewys, brewer 5
3900912 1990533 1990533 plaintiff Chatfeld John   586986 586986 Chatfeld, John, of Lewys 0
4000737 2025031 2025031 plaintiff Grover John   586986 586986 Grover, John, of Lewys 0
4003878 2026151 2026151 defendant Holmewood Edward shoemaker 586986 586986 Holmewood, Edward, of Lewys, shoemaker 0
4532269 2210360 2210360 defendant Baker Thomas   586986 586986 Baker, Thomas, of Lewys 0
4547674 2215215 2215215 plaintiff Capron William   586986 586986 Capron, William, of Lewys 0
4556415 2217945 2217945 defendant Russell John   586986 586986 Russell, John, of Lewys 1
4558441 2218586 2218586 defendant Rossel John   586986 586986 Rossel, John, of Lewys 0
4604147 2232464 2232464 defendant Glasyer Geoffrey   586986 586986 Glasyer, Geoffrey, of Lewys 4
4610260 2234293 2234293 defendant Clerk Roger   586986 586986 Clerk, Roger, of Lewys 0
4610261 2234293 2234293 defendant Barbour Thomas   586986 586986 Barbour, Thomas, of Lewys 1
4637974 2242640 2242640 plaintiff Blake Andrew   586986 586986 Blake, Andrew, of Lewys 1
4644315 2244425 2244425 defendant Godwote John   586986 586986 Godwote, John, of Lewys 6
4645139 2244648 2244648 plaintiff Monke Richard receiver 586986 586986 Monke, Richard, of Lewys, receiver 0
4665717 2250749 2250749 defendant Lardener Robert skinner 586986 586986 Lardener, Robert, of Lewys, skinner 4
4706948 2267552 2267552 plaintiff Mariot John   586986 586986 Mariot, John, of Lewys 0
4723569 2272676 2272676 defendant Whytston John goldsmith 586986 586986 Whytston, John, of Lewys, goldsmith 0
4723570 2272676 2272676 defendant Wolff Alice widow 586986 586986 Wolff, Alice, of Lewys, widow 1
4733697 2275718 2275718 defendant Bresyere Richard   586986 586986 Bresyere, Richard, of Lewys, brass worker 0
4818878 2301989 2301989 plaintiff Parker John   586986 586986 Parker, John, of Lewys 0
4908511 2329216 2329216 defendant Danyell William clerk 586986 586986 Danyell, William, of Lewys, clerk 0
4922026 2333300 2333300 defendant Feret William butcher 586986 586986 Feret, William, of Lewys, butcher 0
4922027 2333300 2333300 defendant Grene Richard butcher 586986 586986 Grene, Richard, of Lewys, butcher 1
4922029 2333301 2333301 defendant Feret William butcher 586986 586986 Feret, William, of Lewys, butcher 0
4922030 2333301 2333301 defendant Grene Richard butcher 586986 586986 Grene, Richard, of Lewys, butcher 1
5000508 2357020 2357020 defendant Rolf John shoemaker 586986 586986 Rolf, John, of Lewys, shoemaker 1
5007304 2359030 2359030 defendant Kyrkeby George merchant & dyer 586986 586986 Kyrkeby, George, of Lewys, merchant & dyer 0
5023790 2363864 2363864 defendant Brasyer Richard husbandman 586986 586986 Brasyer, Richard, of Lewys, husbandman 0
5023891 2363899 2363899 defendant Eyre Richard yeoman 586986 586986 Eyre, Richard, of Lewys, yeoman 0
5042657 2369410 2369410 plaintiff Dr-- or Br-- Stephen   586986 586986 Dr-- or Br--, Stephen, of Lewys 0
5048972 2371328 2371328 defendant Knotte Thomas dyer 586986 586986 Knotte, Thomas, of Lewys, dyer 0
5113200 2390258 2390258 plaintiff Knotte John, senior   586986 586986 Knotte, John, senior, of Lewys, attorney 0
5113210 2390258 2390258 defendant Cheseman Thomas chapman 586986 586986 Cheseman, Thomas, of Lewys, chapman 9
5113214 2390258 2390258 defendant Pylgrym John sherman 586986 586986 Pylgrym, John, of Lewys, sherman 13
5123875 2393438 2393438 defendant Baker Thomas gent 586986 586986 Baker, Thomas, of Lewys, gent 0
5138047 2397632 2397632 defendant Cole Richard chapman 586986 586986 Cole, Richard, of Lewys, chapman 2
5194637 2414164 2414164 defendant Cole Richard chapman 586986 586986 Cole, Richard, of Lewys, chapman 2
5203983 2416915 2416915 defendant Wodefold Agnes widow 586986 586986 Wodefold, Agnes, of Lewys, widow 0
5212871 2419509 2419509 defendant Miller Robert carpenter 586986 586986 Miller, Robert, of Lewys, carpenter 0
5214241 2419897 2419897 defendant Cheseman alias Qwhyte Thomas chapman 586986 586986 Cheseman alias Qwhyte, Thomas, of Lewys, chapman 1
5260585 2433443 2433443 defendant Bocher Thomas buther 586986 586986 Bocher, Thomas, of Lewys, buther 1
5338663 2456663 2456663 plaintiff Leye or atte Lay Richard   586986 586986 Leye or atte Lay, Richard, of Lewys, administrators of 0
5345212 2458673 2458673 defendant Cheseman William butcher 586986 586986 Cheseman, William, of Lewys, butcher 0
5374132 2467504 2467504 defendant Hall alias Retherfeld William hosier 586986 586986 Hall alias Retherfeld, William, of Lewys, hosier 0
5374134 2467505 2467505 defendant Hall alias Retherfeld William hosier 586986 586986 Hall alias Retherfeld, William, of Lewys, hosier 0
5402558 2475802 2475802 defendant Muryell John glover 586986 586986 Muryell, John, of Lewys, glover 1
5433626 2485024 2485024 defendant Muryell John glover 586986 586986 Muryell, John, of Lewys, glover 1
5433631 2485025 2485025 defendant Muryell John glover 586986 586986 Muryell, John, of Lewys, glover 1
5439887 2486875 2486875 defendant Malpas Walter draper 586986 586986 (Malpas, Walter, of Lewys, draper 1
5449103 2489626 2489626 defendant Muryell John glover 586986 586986 Muryell, John, of Lewys, glover 1
5449848 2489845 2489845 defendant Tylman Richard chapman 586986 586986 Tylman, Richard, of Lewys, chapman 0
5462036 2493540 2493540 defendant Tylman Richard chapman 586986 586986 Tylman, Richard, of Lewys, chapman 0
5466543 2494932 2494932 defendant Aleyn William tailor 586986 586986 Aleyn, William, of Lewys, tailor 0
5486631 2500897 2500897 defendant Chamber John gent 586986 586986 Chamber, John, of Lewys, gent 0
5494698 2503304 2503304 defendant Toller John chapman 586986 586986 Toller, John, of Lewys, chapman 3
5520980 2511382 2511382 defendant Frankewell William yeoman 586986 586986 Frankewell, William, of Lewys, yeoman 0
5568859 2525441 2525441 defendant Salman William husbandman 586986 586986 Salman, William, of Lewys, husbandman 5
5574751 2527180 2527180 defendant Carpenter Thomas gent 586986 586986 Carpenter, Thomas, of Lewys, gent 0
5576178 2527611 2527611 plaintiff Symond Edward mercer 586986 586986 Symond, Edward, of Lewys, mercer 0
5576179 2527611 2527611 defendant Moyne John pewterer 586986 586986 Moyne, John, of Lewys, pewterer 0
5576180 2527611 2527611 defendant Botiller William yeoman 586986 586986 Botiller, William, of Lewys, yeoman 1
5590571 2532020 2532020 defendant Shomaker Goskyn cordwainer 586986 586986 Shomaker, Goskyn, of Lewys, cordwainer 0
5600752 2535123 2535123 defendant Knyghtebrege alias Carter John pedder 586986 586986 Knyghtebrege alias Carter, John, of Lewys, pedder 0
5608311 2537504 2537504 defendant Cater Edmund yeoman 586986 586986 Cater, Edmund, of Lewys, yeoman 1

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