names

106 rows where place_id = 596744

✎ 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
3626007 1902991 1902991 defendant Bryghtwell John, senior carpenter 596744 596744 Bryghtwell, John, senior, of Crowmer, carpenter 0
3626008 1902991 1902991 defendant Perman Roger mariner 596744 596744 Perman, Roger, of Crowmer, mariner 1
3626009 1902991 1902991 defendant Bene William baker 596744 596744 Bene, William, of Crowmer, baker 2
3627531 1903470 1903470 plaintiff Bowman Thomas   596744 596744 Bowman, Thomas, of Crowmer 0
3638502 1906858 1906858 defendant Gonnor Richard gent 596744 596744 Gonnor, Richard, of Crowmer, gent 0
3638509 1906859 1906859 defendant Gonnour Richard gent 596744 596744 Gonnour, Richard, of Crowmer, gent 0
3640553 1907483 1907483 defendant Parret Thomas mariner 596744 596744 Parret, Thomas, of Crowmer, mariner 0
3649269 1910160 1910160 defendant Vevysor John mariner 596744 596744 Vevysor, John, of Crowmer, mariner 2
3651956 1910958 1910958 defendant Gunnour Richard gent 596744 596744 Gunnour, Richard, of Crowmer, gent 0
3666360 1915429 1915429 plaintiff Tuly William (legal representative) 596744 596744 Tuly, William, of Crowmer, executor of 0
3666609 1915497 1915497 defendant Dey Michaell husbandman 596744 596744 Dey, Michaell, of Crowmer, husbandman 0
3683638 1921014 1921014 defendant Bone William baker 596744 596744 Bone, William, of Crowmer, baker 0
3683640 1921014 1921014 defendant Heweson Robert (legal representative) 596744 596744 Heweson, Robert, of Crowmer, executors of 2
3683641 1921014 1921014 defendant White Robert baker 596744 596744 (White, Robert, of Crowmer, baker 3
3687421 1922243 1922243 defendant Hoxson John husbandman 596744 596744 Hoxson, John, of Crowmer, husbandman 2
3692851 1923961 1923961 defendant Smyth John shoemaker 596744 596744 Smyth, John, of Crowmer, shoemaker 0
3716974 1931595 1931595 defendant Rysyng William husbandman 596744 596744 Rysyng, William, of Crowmer, husbandman 2
3720591 1932723 1932723 plaintiff Ingham Robert   596744 596744 Ingham, Robert, of Crowmer 0
3723444 1933600 1933600 defendant Heyles Henry merchant 596744 596744 Heyles, Henry, of Crowmer, merchant 1
3724370 1933910 1933910 defendant Heylott William glover 596744 596744 Heylott, William, of Crowmer, glover 0
3742254 1939447 1939447 defendant Brewe John mariner 596744 596744 Brewe, John, of Crowmer, mariner 1
3756243 1943912 1943912 defendant Jamys John baker 596744 596744 Jamys, John, of Crowmer, baker 1
3756244 1943912 1943912 defendant Bene Edward baker 596744 596744 Bene, Edward, of Crowmer, baker 2
3756245 1943912 1943912 defendant Blowfeld John, senior raffman 596744 596744 Blowfeld, John, senior, of Crowmer, raffman 3
3756246 1943912 1943912 defendant Blowfeld John   596744 596744 Blowfeld, John, of Crowmer, hook maker 4
3757643 1944369 1944369 defendant Anable Thomas baker 596744 596744 Anable, Thomas, of Crowmer, baker 0
3766126 1947056 1947056 defendant Anable Thomas baker 596744 596744 Anable, Thomas, of Crowmer, baker 0
3771601 1948818 1948818 plaintiff Taylour William (legal representative) 596744 596744 Taylour, William, of Crowmer, shoemaker, executors of 0
3773791 1949518 1949518 defendant Mannyngham John mercer 596744 596744 Mannyngham, John, of Crowmer, mercer 0
3773792 1949518 1949518 defendant Man William   596744 596744 Man, William, of Crowmer, shepherd 1
3775578 1950107 1950107 defendant Haylys Henry merchant 596744 596744 Haylys, Henry, of Crowmer, merchant 0
3775928 1950221 1950221 defendant Hixson John mariner 596744 596744 Hixson, John, of Crowmer, mariner 0
3779917 1951448 1951448 defendant Heylys Henry merchant 596744 596744 Heylys, Henry, of Crowmer, merchant 0
3790611 1954886 1954886 defendant Archer Robert tailor 596744 596744 Archer, Robert, of Crowmer, tailor 2
3794945 1956284 1956284 plaintiff Colbek William cordwainer 596744 596744 Colbek, William, of Crowmer, cordwainer 0
3794947 1956284 1956284 defendant Ufforth Christopher currier 596744 596744 Ufforth, Christopher, of Crowmer, currier 1
3815411 1962737 1962737 defendant Musswytt John butcher 596744 596744 Musswytt, John, of Crowmer, butcher 0
3815415 1962737 1962737 defendant Barton George husbandman 596744 596744 Barton, George, of Crowmer, husbandman 4
3820266 1964211 1964211 defendant Mannyngham John mercer 596744 596744 Mannyngham, John, of Crowmer, mercer 0
3821136 1964506 1964506 defendant Glover Robert husbandman 596744 596744 Glover, Robert, of crowmer, husbandman 0
3839927 1970422 1970422 defendant Nobbys Thomas clerk 596744 596744 Nobbys, Thomas, of Crowmer, clerk 3
3843419 1971477 1971477 defendant Fen Richard tailor 596744 596744 Fen, Richard, of Crowmer, tailor 1
3859762 1976765 1976765 defendant Bastyon John mariner 596744 596744 Bastyon, John, of Crowmer, mariner 1
3874025 1981535 1981535 defendant Archer Clement mariner 596744 596744 Archer, Clement, of Crowmer, mariner 1
3878909 1983198 1983198 defendant Arnold William gent 596744 596744 Arnold, William, of Crowmer, gent 0
3884542 1985104 1985104 defendant Abbys alias Robyns Thomas gent 596744 596744 Abbys alias Robyns, Thomas, of Crowmer, gent 1
3884789 1985189 1985189 plaintiff Arnold William gent 596744 596744 Arnold, William, of Crowmer, gent 0
3888166 1986297 1986297 defendant Fenne John (legal representative) 596744 596744 Fenne, John, of Crowmer, mariner, administrator of 0
3893963 1988204 1988204 defendant Mundys Roger mercer 596744 596744 Mundys, Roger, of Crowmer, mercer 1
3898513 1989716 1989716 plaintiff Arnold William gent 596744 596744 Arnold, William, of Crowmer, gent 0
3915839 1995676 1995676 defendant Fenne Richard yeoman 596744 596744 Fenne, Richard, of Crowmer, yeoman 0
3915843 1995677 1995677 defendant Fenne Richard yeoman 596744 596744 Fenne, Richard, of Crowmer, yeoman 0
3917869 1996337 1996337 defendant Hayles William merchant 596744 596744 Hayles, William, of Crowmer, merchant 0
4064367 2047532 2047532 defendant Fenne Richard yeoman 596744 596744 Fenne, Richard, of Crowmer, yeoman 0
4104304 2061818 2061818 defendant Arnold Richard gent 596744 596744 Arnold, Richard, of Crowmer, gent 1
4343297 2144930 2144930 defendant Amys William husbandman 596744 596744 Amys, William, of Crowmer, husbandman 0
4351348 2147721 2147721 defendant Dawes William   596744 596744 Dawes, William, of Crowmer, shepherd 1
4351351 2147722 2147722 defendant Dawes William   596744 596744 Dawes, William, of Crowmer, shepherd 1
4738803 2277227 2277227 plaintiff Wilyot Adam   596744 596744 Wilyot, Adam, of Crowmer 0
4770922 2286885 2286885 defendant Thirnyng Robert husbandman 596744 596744 Thirnyng, Robert, of Crowmer, husbandman 0
4770923 2286885 2286885 defendant Willyamsone Thomas yeoman 596744 596744 Willyamsone, Thomas, of Crowmer, yeoman 1
4773091 2287553 2287553 defendant Catelyn John shipman 596744 596744 Catelyn, John, of Crowmer, shipman 4
4841309 2308818 2308818 defendant Hokere Robert   596744 596744 Hokere, Robert, of Crowmer, hoke maker 1
4841310 2308818 2308818 defendant Chapman Robert chapman 596744 596744 Chapman, Robert, of Crowmer, chapman 2
4847698 2310774 2310774 defendant Nene Thomas butcher 596744 596744 Nene, Thomas, of Crowmer, butcher 1
4934887 2337314 2337314 defendant Sadde Clement yeoman 596744 596744 Sadde, Clement, of Crowmer, yeoman 0
4934888 2337314 2337314 defendant Jacobesson alias Ducheman James shoemaker 596744 596744 Jacobesson alias Ducheman, James, of Crowmer, shoemaker 1
4979767 2350904 2350904 plaintiff Skothowe Roger   596744 596744 Skothowe, Roger, of Crowmer 0
4989205 2353706 2353706 plaintiff Brynyng Thomas   596744 596744 Brynyng, Thomas, of Crowmer 0
5109022 2389057 2389057 defendant Scothowe Roger husbandman 596744 596744 Scothowe, Roger, of Crowmer, husbandman 0
5204549 2417080 2417080 defendant Multon Bartholomew yeoman 596744 596744 Multon, Bartholomew, of Crowmer, yeoman 1
5229842 2424347 2424347 plaintiff Arnald Richard esq 596744 596744 Arnald, Richard, of Crowmer, esq 0
5232340 2425035 2425035 defendant Aleyns Richard husbandman 596744 596744 Aleyns, Richard, of Crowmer, husbandman 0
5243415 2428270 2428270 defendant Ikelyngham Robert mercer 596744 596744 Ikelyngham, Robert, of Crowmer, mercer 0
5243421 2428271 2428271 defendant Ikelyngton Robert mercer 596744 596744 Ikelyngton, Robert, of Crowmer, mercer 1
5257118 2432359 2432359 defendant Cade Robert yeoman 596744 596744 Cade, Robert, of Crowmer, yeoman 1
5257119 2432359 2432359 defendant Duglas John yeoman 596744 596744 Duglas, John, of Crowmer, yeoman 2
5257123 2432360 2432360 defendant Cade Robert yeoman 596744 596744 Cade, Robert, of Crowmer, yeoman 1
5257124 2432360 2432360 defendant Duglas John yeoman 596744 596744 Duglas, John, of Crowmer, yeoman 2
5316984 2450160 2450160 plaintiff Mason Thomas mariner 596744 596744 Mason, Thomas, of Crowmer, mariner 3
5316990 2450161 2450161 plaintiff Mason Thomas mariner 596744 596744 Mason, Thomas, of Crowmer, mariner 3
5316996 2450162 2450162 plaintiff Mason Thomas mariner 596744 596744 Mason, Thomas, of Crowmer, mariner 3
5328598 2453630 2453630 defendant Fouler Alice (legal representative) 596744 596744 Fouler, Alice, of Crowmer, widow, administrator of 2
5341986 2457684 2457684 defendant Maryot John gent 596744 596744 Maryot, John, of Crowmer, gent 0
5349985 2460125 2460125 plaintiff Clerk John   596744 596744 Clerk, John, of Crowmer 1
5375141 2467812 2467812 defendant Bright Walter sheerman 596744 596744 Bright, Walter, of Crowmer, sheerman 0
5384760 2470725 2470725 defendant Glover Thomas butcher 596744 596744 Glover, Thomas, of Crowmer, butcher 5
5387717 2471551 2471551 defendant Balle Robert smith 596744 596744 Balle, Robert, of Crowmer, smith 0
5396777 2474170 2474170 defendant Blover Thomas butcher 596744 596744 Blover, Thomas, of Crowmer, butcher 5
5397550 2474374 2474374 defendant Norwich John husbandman 596744 596744 Norwich, John, of Crowmer, husbandman 2
5397564 2474374 2474374 defendant Kerre John   596744 596744 Kerre, John, of Crowmer 16
5397566 2474374 2474374 defendant Grenewey Richard husbandman 596744 596744 Grenewey, Richard, of Crowmer, husbandman 18
5407582 2477238 2477238 defendant Welwyk William husbandman 596744 596744 Welwyk, William, of Crowmer, husbandman 1
5439857 2486862 2486862 defendant Wolwyk William husbandman 596744 596744 Wolwyk, William, of Crowmer, husbandman 0
5445138 2488434 2488434 defendant Robyns William shipman 596744 596744 Robyns, William, of Crowmer, shipman 0
5484629 2500327 2500327 defendant Hastyng Henry miller 596744 596744 Hastyng, Henry, of Crowmer, miller 0
5484630 2500327 2500327 defendant Duglas William yeoman 596744 596744 Duglas, William, of Crowmer, yeoman 1
5518666 2510671 2510671 plaintiff Alyson William, senior   596744 596744 Alyson, William, senior, of Crowmer 0
5522193 2511758 2511758 defendant Swan John turner 596744 596744 Swan, John, of Crowmer, turner 0
5543589 2518100 2518100 defendant Sandryngham Richard husbandman 596744 596744 Sandryngham, Richard, of Crowmer, husbandman 1

Next page

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