names

59 rows where place_id = 600137

✎ 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
3639842 1907275 1907275 defendant Whytyng William husbandman 600137 600137 Whytyng, William, of Cokfeld, husbandman 0
3649859 1910319 1910319 defendant Kyng Thomas   600137 600137 Kyng, Thomas, of Cokfeld, wheelwright 0
3683765 1921057 1921057 defendant Blomfeld John husbandman 600137 600137 Blomfeld, John, of Cokfeld, husbandman 0
3683768 1921058 1921058 defendant Blomfelde John husbandman 600137 600137 Blomfelde, John, of Cokfeld, husbandman 0
3702371 1927000 1927000 defendant Kyng Thomas laborer 600137 600137 Kyng, Thomas, of Cokfeld, laborer 0
3717308 1931696 1931696 defendant Brown William carpenter 600137 600137 Brown, William, of Cokfeld, carpenter 1
3723138 1933504 1933504 defendant Blomefeld Benedict husbandman 600137 600137 Blomefeld, Benedict, of Cokfeld, husbandman 0
3728138 1935060 1935060 defendant Brown William husbandman 600137 600137 Brown, William, of Cokfeld, husbandman 1
3729456 1935460 1935460 defendant Brown John husbandman 600137 600137 Brown, John, of Cokfeld, husbandman 1
3730271 1935698 1935698 defendant Brigger Richard miller 600137 600137 Brigger, Richard, of Cokfeld, miller 0
3734694 1937098 1937098 defendant Whytyng John laborer 600137 600137 Whytyng, John, of Cokfeld, laborer 4
3743592 1939872 1939872 defendant Brown William husbandman 600137 600137 Brown, William, of Cokfeld, husbandman 0
3751243 1942312 1942312 defendant Brown William husbandman 600137 600137 Brown, William, of Cokfeld, husbandman 1
3758278 1944585 1944585 defendant Edward William husbandman 600137 600137 Edward, William, of Cokfeld, husbandman 0
3759060 1944818 1944818 defendant Horssy John husbandman 600137 600137 Horssy, John, of Cokfeld, husbandman 3
3759224 1944875 1944875 plaintiff Chenery John (legal representative) 600137 600137 Chenery, John, of Cokfeld, executors of 0
3759231 1944875 1944875 defendant Chenery John husbandman 600137 600137 Chenery, John, of Cokfeld, husbandman 3
3764382 1946521 1946521 defendant Letman John painter 600137 600137 Letman, John, of Cokfeld, painter 0
3765317 1946816 1946816 defendant Lytman Johnm painter 600137 600137 Lytman, Johnm, of Cokfeld, painter 0
3769718 1948183 1948183 defendant Chenery or Chevery John husbandman 600137 600137 Chenery or Chevery, John, of Cokfeld, husbandman 0
3777044 1950566 1950566 defendant Brown William carpenter 600137 600137 Brown, William, of Cokfeld, carpenter 2
3777152 1950606 1950606 defendant Wellys Thomas   600137 600137 Wellys, Thomas, of Cokfeld, wheelwright 0
3783372 1952549 1952549 defendant Lytman John painter 600137 600137 Lytman, John, of Cokfeld, painter 0
3807462 1960239 1960239 defendant Edward Henry husbandman 600137 600137 Edward, Henry, of Cokfeld, husbandman 0
3815102 1962643 1962643 defendant Browne William carpenter 600137 600137 Browne, William, of Cokfeld, carpenter 1
3833790 1968500 1968500 defendant Brown William carpenter 600137 600137 Brown, William, of Cokfeld, carpenter 0
3833794 1968501 1968501 defendant Brown William carpenter 600137 600137 (Brown, William, of Cokfeld, carpenter 1
3855371 1975320 1975320 defendant Carpynter alias Hewer John carpenter 600137 600137 Carpynter alias Hewer, John, of Cokfeld, carpenter 0
3855372 1975320 1975320 defendant att Feld alias Austye William husbandman 600137 600137 att Feld alias Austye, William, of Cokfeld, husbandman 1
3861000 1977163 1977163 defendant Kyng Thomas laborer 600137 600137 Kyng, Thomas, of Cokfeld, laborer 0
3886643 1985785 1985785 defendant Catywold John smith 600137 600137 Catywold, John, of Cokfeld, smith 2
3928788 1999963 1999963 defendant Byrde John husbandman 600137 600137 Byrde, John, of Cokfeld, husbandman 3
3945977 2005672 2005672 plaintiff Brundyshe Robert yeoman 600137 600137 Brundyshe, Robert, of Cokfeld, yeoman 0
3965854 2012673 2012673 defendant Flemynge Robert yeoman 600137 600137 Flemynge, Robert, of Cokfeld, yeoman 0
4840509 2308573 2308573 defendant Beton Stephen husbandman 600137 600137 Beton, Stephen, of Cokfeld, husbandman 0
5183930 2411036 2411036 defendant Forthe Richard clerk 600137 600137 Forthe, Richard, of Cokfeld, clerk 1
5201060 2416070 2416070 defendant Forthe Richard clerk 600137 600137 Forthe, Richard, of Cokfeld, clerk 1
5204076 2416941 2416941 defendant Forthe Richard clerk 600137 600137 Forthe, Richard, of Cokfeld, clerk 1
5254510 2431532 2431532 defendant Crane Margaret widow 600137 600137 Crane, Margaret, of Cokfeld, widow 0
5260991 2433556 2433556 defendant Forde Robert clerk 600137 600137 Forde, Robert, of Cokfeld, clerk 0
5260992 2433556 2433556 defendant Forde Thomas yeoman 600137 600137 Forde, Thomas, of Cokfeld, yeoman 1
5260993 2433556 2433556 defendant Forde William yeoman 600137 600137 Forde, William, of Cokfeld, yeoman 2
5286822 2441153 2441153 defendant Brynglove John fletcher 600137 600137 Brynglove, John, of Cokfeld, fletcher 4
5309523 2447884 2447884 defendant Chennory John husbandman 600137 600137 Chennory, John, of Cokfeld, husbandman 0
5343746 2458228 2458228 defendant Forth Robert husbandman 600137 600137 Forth, Robert, of Cokfeld, husbandman 3
5343747 2458228 2458228 defendant Assy William husbandman 600137 600137 Assy, William, of Cokfeld, husbandman 4
5390356 2472305 2472305 defendant Broun John husbandman 600137 600137 Broun, John, of Cokfeld, husbandman 12
5477637 2498328 2498328 defendant Gardyner Thomas husbandman 600137 600137 Gardyner, Thomas, of Cokfeld, husbandman 1
5508596 2507552 2507552 defendant Kemp Thomas laborer 600137 600137 Kemp, Thomas, of Cokfeld, laborer 0
5520874 2511349 2511349 defendant Chenery or Chevery William husbandman 600137 600137 Chenery or Chevery, William, of Cokfeld, husbandman 0
5520875 2511349 2511349 defendant Brynglove Edward husbandman 600137 600137 Brynglove, Edward, of Cokfeld, husbandman 1
5527684 2513239 2513239 defendant Kyng John laborer 600137 600137 Kyng, John, of Cokfeld, laborer 0
5539366 2516798 2516798 defendant Hore William smith 600137 600137 Hore, William, of Cokfeld, smith 0
5558699 2522498 2522498 defendant Gardener Thomas laborer 600137 600137 Gardener, Thomas, of Cokfeld, laborer 0
5559596 2522765 2522765 defendant Hyll William husbandman 600137 600137 Hyll, William, of Cokfeld, husbandman 8
5567751 2525142 2525142 defendant Edward Edmund husbandman 600137 600137 Edward, Edmund, of Cokfeld, husbandman 0
5569874 2525763 2525763 defendant Campe John clerk 600137 600137 Campe, John, of Cokfeld, clerk 0
5577945 2528175 2528175 defendant Abotte Robert   600137 600137 Abotte, Robert, of Cokfeld, tile maker 2
5632070 2554052 2554052 defendant Brokesmell John yeoman 600137 600137 Brokesmell, John, of Cokfeld, 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);