names

50 rows where place_id = 586146

✎ 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
3588031 1863910 1863910 defendant Asee Richard fuller 586146 586146 Asee, Richard, of Hastyng, fuller 0
3606170 1869599 1869599 defendant Couper Thomas cordwainer 586146 586146 Couper, Thomas, of Hastyng, cordwainer 3
3625647 1875556 1875556 plaintiff Wylkynson Robert   586146 586146 Wylkynson, Robert, of Hastyng 0
3684587 1921311 1921311 defendant Bocher Edmund draper 586146 586146 Bocher, Edmund, of Hastyng, draper 11
3699812 1926165 1926165 defendant Bocher Edmund draper 586146 586146 Bocher, Edmund, of Hastyng, draper 8
3725622 1934302 1934302 defendant Mott John yeoman 586146 586146 Mott, John, of Hastyng, yeoman 0
3753861 1943153 1943153 defendant Mott John yeoman 586146 586146 Mott, John, of Hastyng, yeoman 0
3754738 1943441 1943441 defendant Frank John merchant 586146 586146 Frank, John, of Hastyng, merchant 3
3772150 1948981 1948981 defendant Frank John merchant 586146 586146 Frank, John, of Hastyng, merchant 2
3834841 1968836 1968836 defendant Regele Thomas   586146 586146 Regele, Thomas, of Hastyng, tallow chandler 0
3879112 1983264 1983264 defendant Benet William yeoman 586146 586146 Benet, William, of Hastyng, yeoman 0
4122651 2068395 2068395 defendant Dowle Stephen (legal representative) 586146 586146 Dowle, Stephen, of Hastyng, yeoman, executrix of 0
4126723 2069844 2069844 defendant Hayes Thomas yeoman 586146 586146 Hayes, Thomas, of Hastyng, yeoman 1
4173998 2086360 2086360 defendant Wells William cutler 586146 586146 Wells, William, of Hastyng, cutler 3
4183817 2089833 2089833 defendant Locke William thatcher 586146 586146 Locke, William, of Hastyng, thatcher 0
4210258 2099144 2099144 defendant Cooper John yeoman 586146 586146 Cooper, John, of Hastyng, yeoman 0
4210259 2099144 2099144 defendant Horsey John yeoman 586146 586146 Horsey, John, of Hastyng, yeoman 1
4358354 2150154 2150154 defendant Brabon Thomas yeoman 586146 586146 Brabon, Thomas, of Hastyng, yeoman 0
4369189 2154044 2154044 defendant Isted Thomas yeoman 586146 586146 Isted, Thomas, of Hastyng, or of Battell, Sussex, yeoman 0
4371123 2154732 2154732 defendant Crabbe John tailor 586146 586146 Crabbe, John, of Hastyng, tailor 0
4585352 2226843 2226843 defendant Longe John   586146 586146 Longe, John, of Hastyng 0
4637334 2242472 2242472 plaintiff Borgrove Robert (legal representative) 586146 586146 Borgrove, Robert, of Hastyng, executors of 0
4721799 2272151 2272151 defendant Parker John yeoman 586146 586146 Parker, John, of Hastyng, yeoman 0
4828541 2304966 2304966 defendant Fylchyng Simon husbandman 586146 586146 Fylchyng, Simon, of Hastyng, husbandman 0
4907693 2328972 2328972 plaintiff Adam John   586146 586146 Adam, John, of Hastyng 0
4907727 2328980 2328980 plaintiff Addam John   586146 586146 Addam, John, of Hastyng 0
4949599 2341870 2341870 plaintiff Neweman Thomas   586146 586146 Neweman, Thomas, of Hastyng 0
4965623 2346637 2346637 defendant Kete John husbandman 586146 586146 Kete, John, of Hastyng, husbandman 1
5035132 2367139 2367139 plaintiff Tamworth John, senior gent 586146 586146 Tamworth, John, senior, of Hastyng, gent 0
5035133 2367139 2367139 defendant Vestynden Thomas gent 586146 586146 Vestynden, Thomas, of Hastyng, gent 0
5056372 2373480 2373480 plaintiff Carpenter John (legal representative) 586146 586146 Carpenter, John, of Hastyng, merchant, executors of 0
5056376 2373480 2373480 defendant Carpenter Agnes widow 586146 586146 Carpenter, Agnes, of Hastyng, widow 0
5078250 2379981 2379981 defendant Candem or Cauden William butcher 586146 586146 Candem or Cauden, William, of Hastyng, butcher 0
5087287 2382662 2382662 defendant Baker Thomas sherman 586146 586146 Baker, Thomas, of Hastyng, sherman 3
5113957 2390471 2390471 defendant Markham Thomas merchant 586146 586146 Markham, Thomas, of Hastyng, merchant 0
5118581 2391865 2391865 plaintiff Roser John   586146 586146 Roser, John, of Hastyng 0
5303967 2446190 2446190 defendant Fleccher John husbandman 586146 586146 together with Fleccher, John, of Hastyng, husbandman 2
5324868 2452513 2452513 defendant Carpengton Robert barber 586146 586146 Carpengton, Robert, of Hastyng, barber 0
5324871 2452514 2452514 defendant Carpyngton Robert barber 586146 586146 Carpyngton, Robert, of Hastyng, barber 0
5352180 2460782 2460782 defendant Rede John yeoman 586146 586146 Rede, John, of Hastyng, yeoman 4
5375694 2467989 2467989 defendant Benette Thomas smith 586146 586146 Benette, Thomas, of Hastyng, smith 0
5512605 2508796 2508796 defendant Hogges John fletcher 586146 586146 Hogges, John, of Hastyng, fletcher 0
5512606 2508796 2508796 defendant Kyrowe John yeoman 586146 586146 Kyrowe, John, of Hastyng, yeoman 1
5581245 2529204 2529204 defendant Fraunces John butcher 586146 586146 Fraunces, John, of Hastyng, butcher 1
5589570 2531737 2531737 defendant Mayhewe Robert butcher 586146 586146 Mayhewe, Robert, of Hastyng, butcher 2
5618408 2549579 2549579 defendant Tyson Ralph   586146 586146 Tyson, Ralph, of Hastyng 4
5631214 2553770 2553770 defendant Multon William shoemaker 586146 586146 Multon, William, of Hastyng, shoemaker 0
5631216 2553770 2553770 defendant Clerk Simon husbandman 586146 586146 Clerk, Simon, of Hastyng, husbandman 2
5631220 2553771 2553771 defendant Multon William shoemaker 586146 586146 together with Multon, William, of Hastyng, shoemaker 1
5631222 2553771 2553771 defendant Clerk Simon husbandman 586146 586146 Clerk, Simon, of Hastyng, husbandman 3

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