names

71 rows where place_id = 592038

✎ 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
3606369 1869658 1869658 defendant Osberne Thomas clothier 592038 592038 Osberne, Thomas, of Midhurst, clothier 2
3639626 1907201 1907201 defendant Ball Robert sherman 592038 592038 Ball, Robert, of Midhurst, sherman 0
3663164 1914397 1914397 defendant Kempe Henry tailor 592038 592038 Kempe, Henry, of Midhurst, tailor 0
3663165 1914397 1914397 defendant Macy Edward smith 592038 592038 Macy, Edward, of Midhurst, smith 1
3663166 1914397 1914397 defendant Stret William yeoman 592038 592038 Stret, William, of Midhurst, yeoman 2
3663174 1914401 1914401 defendant Stert William yeoman 592038 592038 Stert, William, of Midhurst, yeoman 0
3663175 1914401 1914401 defendant Kempe Henry tailor 592038 592038 Kempe, Henry, of Midhurst, tailor 1
3663176 1914401 1914401 defendant de Macy Edward smith 592038 592038 de Macy, Edward, of Midhurst, smith 2
3678947 1919484 1919484 defendant Knyght John yeoman 592038 592038 Knyght, John, of Midhurst, yeoman 0
3678948 1919484 1919484 defendant Coke William husbandman 592038 592038 Coke, William, of Midhurst, husbandman 1
3708595 1928988 1928988 defendant Knyght John yeoman 592038 592038 Knyght, John, of Midhurst, yeoman 0
3708599 1928989 1928989 defendant Redman alias Mason William butcher 592038 592038 Redman alias Mason, William, of Midhurst, butcher 0
3723183 1933521 1933521 defendant Mowsehole Robert yeoman 592038 592038 Mowsehole, Robert, of Midhurst, yeoman 0
3723184 1933521 1933521 defendant Mowsehole Philip yeoman 592038 592038 Mowsehole, Philip, of Midhurst, yeoman 1
3723185 1933521 1933521 defendant Mowsehole John, senior weaver 592038 592038 Mowsehole, John, senior, of Midhurst, weaver 2
3723186 1933521 1933521 defendant Mowsehole John, junior husbandman 592038 592038 Mowsehole, John, junior, of Midhurst, husbandman 3
3797723 1957186 1957186 defendant Hollerst Henry fuller 592038 592038 Hollerst, Henry, of Midhurst, fuller 0
3819660 1964029 1964029 defendant Hollerst Henry fuller 592038 592038 Hollerst, Henry, of Midhurst, fuller 0
3834921 1968859 1968859 defendant Carpenter alias Amys Thomas barber 592038 592038 Carpenter alias Amys, Thomas, of Midhurst, barber 0
3894198 1988277 1988277 defendant Capron John weaver 592038 592038 Capron, John, of Midhurst, weaver 0
3908411 1993109 1993109 defendant Capron John weaver 592038 592038 Capron, John, of Midhurst, weaver 0
4071683 2050169 2050169 defendant Fachyn John mercer 592038 592038 Fachyn, John, of Midhurst, mercer 0
4285396 2124825 2124825 defendant Ruffyn Roger yeoman 592038 592038 Ruffyn, Roger, of Midhurst, yeoman 0
4389118 2160990 2160990 defendant Calden or Colden John gent 592038 592038 Calden or Colden, John, of Midhurst, gent 0
4392263 2162038 2162038 defendant Johnson Edward carpenter 592038 592038 Johnson, Edward, of Midhurst, carpenter 1
4413008 2168943 2168943 defendant Dyghere Stephen le   592038 592038 Dyghere, Stephen le, of Midhurst 0
4418824 2170753 2170753 defendant Baillyff Thomas le   592038 592038 (Baillyff, Thomas le, of Midhurst, son of Richard 1
4428776 2173800 2173800 defendant Baillyf Thomas le   592038 592038 Baillyf, Thomas le, of Midhurst 0
4431683 2174678 2174678 defendant Bohun John de   592038 592038 Bohun, John de, of Midhurst 0
4451965 2185596 2185596 defendant Hosteler Thomas   592038 592038 Hosteler, Thomas, of Midhurst 2
4474750 2192770 2192770 defendant Hobkyn Richard   592038 592038 Hobkyn, Richard, of Midhurst 0
4525339 2208267 2208267 plaintiff Ive John   592038 592038 Ive, John, of Midhurst, bailiff 0
4557914 2218405 2218405 defendant Germayn John   592038 592038 Germayn, John, of Midhurst 1
4585404 2226858 2226858 defendant Rumbald John   592038 592038 Rumbald, John, of Midhurst 0
4618713 2236861 2236861 defendant Pedlyn John   592038 592038 Pedlyn, John, of Midhurst 2
4626049 2239105 2239105 plaintiff Pokepol John   592038 592038 Pokepol, John, of Midhurst 0
4626051 2239106 2239106 plaintiff Pokepol John   592038 592038 Pokepol, John, of Midhurst 0
4654456 2247265 2247265 defendant Barbour John barber 592038 592038 Barbour, John, of Midhurst, barber 0
4692542 2263181 2263181 defendant T_ester Simon tanner 592038 592038 T_ester, Simon, of Midhurst, tanner 0
4704857 2266896 2266896 defendant Waltham John husbandman 592038 592038 Waltham, John, of Midhurst, husbandman 4
4709985 2268480 2268480 plaintiff Popkepole John   592038 592038 Popkepole, John, of Midhurst 0
4711388 2268893 2268893 defendant Mosehole Robert husbandman 592038 592038 Mosehole, Robert, of Midhurst, husbandman 3
4715085 2270046 2270046 defendant Bohun John   592038 592038 Bohun, John, of Midhurst, knight 0
4764032 2284739 2284739 plaintiff Hanbedene William   592038 592038 Hanbedene, William, of Midhurst 0
4767684 2285872 2285872 plaintiff Maunter Michael   592038 592038 Maunter, Michael, of Midhurst 0
4768420 2286095 2286095 plaintiff Mustard Michael   592038 592038 Mustard, Michael, of Midhurst 0
4833919 2306616 2306616 defendant Cubell John smith 592038 592038 Cubell, John, of Midhurst, smith 0
4845696 2310167 2310167 defendant Moushole Robert baker 592038 592038 Moushole, Robert, of Midhurst, baker 0
4846530 2310423 2310423 plaintiff Puppoll John (legal representative) 592038 592038 Puppoll, John, of Midhurst, executor of 0
4846532 2310423 2310423 defendant Flaynsburgh Dokettus weaver 592038 592038 Flaynsburgh, Dokettus, of Midhurst, weaver 0
4850995 2311759 2311759 defendant Dyere Simon dyer 592038 592038 Dyere, Simon, of Midhurst, dyer 1
4850996 2311759 2311759 defendant Amors William tanner 592038 592038 Amors, William, of Midhurst, tanner 2
4875110 2319169 2319169 defendant Scoland John barber 592038 592038 Scoland, John, of Midhurst, barber 0
4916251 2331587 2331587 defendant Clerk John mercer 592038 592038 Clerk, John, of Midhurst, mercer 0
4925286 2334340 2334340 plaintiff Pedelyn Gregory   592038 592038 Pedelyn, Gregory, of Midhurst 0
4925287 2334340 2334340 defendant Pedelyn Gregory   592038 592038 Pedelyn, Gregory, of Midhurst 0
4978569 2350541 2350541 defendant Byrnesford John clerk 592038 592038 Byrnesford, John, of Midhurst, clerk 0
4991531 2354352 2354352 defendant Smyth William smith 592038 592038 Smyth, William, of Midhurst, smith 0
4991923 2354473 2354473 defendant Curteys William smith 592038 592038 Curteys, William, of Midhurst, smith 0
4996341 2355763 2355763 defendant Whityng John clerk 592038 592038 Whityng, John, of Midhurst, clerk 0
5002033 2357495 2357495 defendant Mundevyle Michael butcher 592038 592038 Mundevyle, Michael, of Midhurst, butcher 0
5101498 2386851 2386851 plaintiff Bagle Michael (legal representative) 592038 592038 Bagle, Michael, of Midhurst, executors of 0
5101503 2386852 2386852 plaintiff Bagle Michael (legal representative) 592038 592038 Bagle, Michael, of Midhurst, executors of 0
5193041 2413694 2413694 defendant Wartour Thomas tanner 592038 592038 Wartour, Thomas, of Midhurst, tanner 0
5334363 2455348 2455348 defendant White Robert chapman 592038 592038 White, Robert, of Midhurst, chapman 0
5460370 2493042 2493042 defendant Kenham John gent 592038 592038 Kenham, John, of Midhurst, gent 0
5460371 2493042 2493042 defendant Serych Thomas shoemaker 592038 592038 Serych, Thomas, of Midhurst, shoemaker 1
5471985 2496580 2496580 defendant Kenham John gent 592038 592038 Kenham, John, of Midhurst, gent 0
5471986 2496580 2496580 defendant Serych Thomas shoemaker 592038 592038 Serych, Thomas, of Midhurst, shoemaker 1
5543922 2518209 2518209 defendant A Parke William butcher 592038 592038 A Parke, William, of Midhurst, butcher 1
5626622 2552301 2552301 plaintiff Mosehole Robert   592038 592038 Mosehole, Robert, of Midhurst 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);