names

65 rows where place_id = 622825

✎ 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
3749108 1941651 1941651 defendant Symond John butcher 622825 622825 Symond, John, of Brantham, butcher 1
3781618 1951989 1951989 defendant Whytyng John yeoman 622825 622825 Whytyng, John, of Brantham, yeoman 1
3795190 1956362 1956362 defendant Whytyng John yeoman 622825 622825 Whytyng, John, of Brantham, yeoman 0
3837397 1969606 1969606 defendant Moptyde Roger yeoman 622825 622825 Moptyde, Roger, of Brantham, yeoman 1
3860629 1977047 1977047 defendant Grymston William gent 622825 622825 Grymston, William, of Brantham, gent 1
3867706 1979436 1979436 defendant Grymston William gent 622825 622825 Grymston, William, of Brantham, gent 0
3909060 1993329 1993329 defendant Brugge Richard sherman 622825 622825 Brugge, Richard, of Brantham, sherman 2
3914443 1995175 1995175 defendant Gardener Nicholas butcher 622825 622825 Gardener, Nicholas, of Brantham, butcher 2
3940970 2003987 2003987 defendant Wyngfeld Robert esq 622825 622825 Wyngfeld, Robert, of Brantham, esq 1
3945843 2005621 2005621 plaintiff Brounrick John merchant 622825 622825 Brounrick, John, of Brantham, or of Ipswich, Suff, merchant 0
3949747 2006991 2006991 defendant Wyngfyelde Robert esq 622825 622825 Wyngfyelde, Robert, of Brantham, esq 0
3971147 2014464 2014464 defendant Bett or Bettes Richard husbandman 622825 622825 Bett or Bettes, Richard, of Brantham, or of Cattywarde, Suff, husbandman 0
3991380 2021672 2021672 defendant Russhebrooke Robert clothier 622825 622825 Russhebrooke, Robert, of Brantham, clothier 0
3991833 2021833 2021833 plaintiff Brounryge or Brounryck John merchant 622825 622825 Brounryge or Brounryck, John, of Brantham, or of Wyllysham, merchant 0
3991837 2021834 2021834 plaintiff Brounryge or Brounryck John merchant 622825 622825 Brounryge or Brounryck, John, of Brantham, or of Wyllysham, merchant 0
3991887 2021855 2021855 defendant Clarke William yeoman 622825 622825 Clarke, William, of Brantham, yeoman 2
4005806 2026851 2026851 defendant Rashbrooke Robert clothier 622825 622825 Rashbrooke, Robert, of Brantham, or of Kersey, clothier 0
4019803 2031812 2031812 defendant Bogas Robert gent 622825 622825 Bogas, Robert, of Brantham, gent 2
4025739 2033859 2033859 plaintiff Brownrige John merchant 622825 622825 Brownrige, John, of Brantham, merchant 0
4058688 2045499 2045499 defendant Bretton Richard butcher 622825 622825 Bretton, Richard, of Brantham, butcher 0
4059543 2045806 2045806 defendant Bretton Richard butcher 622825 622825 Bretton, Richard, of Brantham, butcher 1
4080945 2053498 2053498 defendant Amys James merchant 622825 622825 Amys, James, of Brantham, or of Ipswich, merchant 0
4133841 2072440 2072440 defendant Bretton Richard butcher 622825 622825 Bretton, Richard, of Brantham, butcher 1
4139560 2074510 2074510 defendant Bretton Philip butcher 622825 622825 Bretton, Philip, of Brantham, butcher 0
4203787 2096881 2096881 defendant Harrys John husbandman 622825 622825 Harrys, John, of Brantham, husbandman 2
4232243 2106780 2106780 defendant Bretton Richard butcher 622825 622825 Bretton, Richard, of Brantham, butcher 1
4274318 2120963 2120963 defendant Poter William yeoman 622825 622825 Poter, William, of Brantham, yeoman 0
4274319 2120963 2120963 defendant Smyth William yeoman 622825 622825 Smyth, William, of Brantham, yeoman 1
4323577 2138302 2138302 defendant Baryngton John yeoman 622825 622825 Baryngton, John, of Brantham, yeoman 0
4324635 2138630 2138630 defendant Bretton Richard butcher 622825 622825 Bretton, Richard, of Brantham, butcher 0
4337069 2142688 2142688 defendant Wilken Bartholomww yeoman 622825 622825 Wilken, Bartholomww, of Brantham, yeoman 1
4423732 2172266 2172266 defendant Chesterton Thomas de   622825 622825 Chesterton, Thomas de, of Brantham 0
4432110 2174826 2174826 defendant Guneday Robert   622825 622825 Guneday, Robert, of Brantham 0
4491670 2198080 2198080 defendant Sere John   622825 622825 Sere, John, of Brantham 0
4528750 2209276 2209276 plaintiff Medburn John, sen   622825 622825 Medburn, John, sen, of Brantham 0
4586932 2227313 2227313 plaintiff Holme John   622825 622825 Holme, John, of Brantham 0
4620463 2237380 2237380 defendant Bodyngham John   622825 622825 Bodyngham, John, of Brantham 0
4660604 2249143 2249143 defendant Cukhou or Cukhon John fuller 622825 622825 Cukhou or Cukhon, John, of Brantham, fuller 1
4660740 2249183 2249183 defendant Cukhok Adam husbandman 622825 622825 Cukhok, Adam, of Brantham, husbandman 0
4662607 2249773 2249773 defendant Horndon William clerk 622825 622825 Horndon, William, of Brantham, clerk 1
4684615 2260786 2260786 defendant Wyram John   622825 622825 Wyram, John, of Brantham, wright 3
4684936 2260882 2260882 plaintiff Rewele John merchant 622825 622825 Rewele, John, of Brantham, merchant 0
4728585 2274179 2274179 defendant Cordlay William yeoman 622825 622825 Cordlay, William, of Brantham, yeoman 0
4728586 2274179 2274179 defendant Seynsbury John yeoman 622825 622825 Seynsbury, John, of Brantham, yeoman 1
4811823 2299809 2299809 defendant Bette John skinner 622825 622825 Bette, John, of Brantham, skinner 2
4813185 2300237 2300237 defendant Dilton Thomas husbandman 622825 622825 Dilton, Thomas, of Brantham, husbandman 4
4825003 2303859 2303859 defendant Edwardby Adam husbandman 622825 622825 Edwardby, Adam, of Brantham, husbandman 0
5019570 2362609 2362609 defendant Pyllon Joan widow 622825 622825 Pyllon, Joan, of Brantham, widow 0
5035255 2367173 2367173 defendant Cranfen John yeoman 622825 622825 Cranfen, John, of Brantham, yeoman 0
5038464 2368142 2368142 defendant Ingforby Thomas husbandman 622825 622825 Ingforby, Thomas, of Brantham, husbandman 0
5043587 2369702 2369702 defendant Broker John husbandman 622825 622825 with Broker, John, of Brantham, husbandman 1
5046827 2370673 2370673 defendant Haryngton John gent 622825 622825 Haryngton, John, of Brantham, gent 0
5046828 2370673 2370673 defendant Saltby John (legal representative) 622825 622825 Saltby, John, of Brantham, gent, executors of 1
5086027 2382304 2382304 defendant Cranesen or Cranefen William weaver 622825 622825 Cranesen or Cranefen, William, of Brantham, weaver 2
5178735 2409500 2409500 defendant Mopetyd Roger husbandman 622825 622825 Mopetyd, Roger, of Brantham, husbandman 0
5270516 2436476 2436476 defendant Curteys Henry merchant 622825 622825 Curteys, Henry, of Brantham, merchant 0
5295885 2443786 2443786 defendant Adgore Robert yeoman 622825 622825 Adgore, Robert, of Brantham, yeoman 0
5346950 2459204 2459204 defendant Wodward William yeoman 622825 622825 Wodward, William, of Brantham, yeoman 2
5368725 2465808 2465808 defendant Wodeward William husbandman 622825 622825 Wodeward, William, of Brantham, husbandman 3
5380901 2469593 2469593 defendant Wodward William husbandman 622825 622825 Wodward, William, of Brantham, husbandman 2
5468798 2495596 2495596 plaintiff Adgor Gregory   622825 622825 Adgor, Gregory, of Brantham, husbandman, son of Richard 1
5479846 2498983 2498983 defendant Bryght John, junior husbandman 622825 622825 Bryght, John, junior, of Brantham, husbandman 1
5479850 2498984 2498984 defendant Bryght John, junior husbandman 622825 622825 Bryght, John, junior, of Brantham, husbandman 1
5483723 2500081 2500081 defendant Austyn alias Peverell Thomas clothmaker 622825 622825 Austyn alias Peverell, Thomas, of Brantham, clothmaker 3
5562436 2523613 2523613 defendant Barker Gregory laborer 622825 622825 Barker, Gregory, of Brantham, laborer 2

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