names

50 rows where place_id = 590089

✎ 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
3599867 1867609 1867609 defendant Gamelyn Robert husbandman 590089 590089 Gamelyn, Robert, of Polsted, husbandman 1
3639471 1907150 1907150 defendant Papford Thomas fishmonger 590089 590089 Papford, Thomas, of Polsted, fishmonger 0
3822109 1964808 1964808 defendant Barker John husbandman 590089 590089 Barker, John, of Polsted, husbandman 2
3849815 1973527 1973527 defendant Pod John husbandman 590089 590089 Pod, John, of Polsted, husbandman 0
3868877 1979832 1979832 defendant Bronde John chaplain 590089 590089 Bronde, John, of Polsted, chaplain 1
3925908 1998980 1998980 defendant Taylor John husbandman 590089 590089 Taylor, John, of Polsted, husbandman 1
3929205 2000111 2000111 plaintiff Bull John   590089 590089 Bull, John, of Polsted 0
3981992 2018323 2018323 plaintiff Rosse Thomas yeoman 590089 590089 Rosse, Thomas, of Polsted, yeoman 0
4017397 2030927 2030927 defendant Dethyk Richard gent 590089 590089 Dethyk, Richard, of Polsted, gent 0
4062438 2046855 2046855 defendant Wheler William husbandman 590089 590089 Wheler, William, of Polsted, husbandman 0
4111719 2064440 2064440 defendant Blynde Silvester yeoman 590089 590089 Blynde, Silvester, of Polsted, yeoman 0
4244631 2111189 2111189 defendant Hamonde Thomas   590089 590089 Hamonde, Thomas, of Polsted yeoman 0
4293557 2127757 2127757 defendant Wheler Roger miller 590089 590089 Wheler, Roger, of Polsted, miller 0
4304165 2131589 2131589 defendant Rosse Thomas clerk 590089 590089 Rosse, Thomas, of Polsted, clerk 1
4305567 2132080 2132080 defendant Cricke Robert blacksmith 590089 590089 Cricke, Robert, of Polsted, blacksmith 3
4307352 2132708 2132708 defendant Rosse Thomas   590089 590089 Rosse, Thomas, of Polsted clerk 1
4330593 2140527 2140527 defendant Smythe John yeoman 590089 590089 Smythe, John, of Polsted, yeoman 0
4332234 2141074 2141074 defendant Rosse Thomas clerk 590089 590089 Rosse, Thomas, of Polsted, clerk 1
4332673 2141212 2141212 defendant Ericke or Gricke Robert blacksmith 590089 590089 Ericke or Gricke, Robert, of Polsted, blacksmith 3
4347276 2146305 2146305 defendant Rosse Thomas clerk 590089 590089 Rosse, Thomas, of Polsted, clerk 2
4504391 2201924 2201924 defendant Wollemontere John   590089 590089 Wollemontere, John, of Polsted 1
4579270 2224998 2224998 defendant Calle John   590089 590089 Calle, John, of Polsted 0
4671071 2256618 2256618 defendant Synt John yeoman 590089 590089 Synt, John, of Polsted, yeoman 1
4736036 2276410 2276410 defendant Hacche John fuller 590089 590089 Hacche, John, of Polsted, fuller 0
4737889 2276955 2276955 defendant Crenche Robert yeoman 590089 590089 Crenche, Robert, of Polsted, yeoman 2
5006453 2358787 2358787 defendant Londham Thomas tailor 590089 590089 Londham, Thomas, of Polsted, tailor 1
5018654 2362343 2362343 defendant Baudewyn Thomas husbandman 590089 590089 Baudewyn, Thomas, of Polsted, husbandman 0
5150105 2401169 2401169 defendant Bande Thomas husbandman 590089 590089 Bande, Thomas, of Polsted, husbandman 3
5154930 2402600 2402600 defendant Proud Augustine butcher 590089 590089 Proud, Augustine, of Polsted, butcher 0
5161764 2404545 2404545 defendant Arnold John husbandman 590089 590089 Arnold, John, of Polsted, husbandman 1
5168792 2406602 2406602 defendant Bande or Baude Thomas husbandman 590089 590089 Bande or Baude, Thomas, of Polsted, husbandman 3
5184950 2411344 2411344 defendant Bande Thomas husbandman 590089 590089 Bande, Thomas, of Polsted, husbandman 2
5184956 2411345 2411345 defendant Bande Thomas husbandman 590089 590089 Bande, Thomas, of Polsted, husbandman 3
5230897 2424645 2424645 defendant Sekelyng John husbandman 590089 590089 Sekelyng, John, of Polsted, husbandman 0
5230902 2424646 2424646 defendant Sekelyng John husbandman 590089 590089 Sekelyng, John, of Polsted, husbandman 0
5231554 2424811 2424811 defendant Codwell John smith 590089 590089 Codwell, John, of Polsted, smith 3
5276474 2438190 2438190 defendant Page illegible, junior fuller 590089 590089 Page, ---, junior, of Polsted, fuller 4
5299928 2444944 2444944 plaintiff Baudewyn Thomas   590089 590089 (Baudewyn, Thomas, of Polsted 1
5325429 2452690 2452690 defendant Cudwell John smith 590089 590089 Cudwell, John, of Polsted, smith 1
5328468 2453588 2453588 defendant Gamlyn Robert timberman 590089 590089 Gamlyn, Robert, of Polsted, timberman 0
5329908 2454016 2454016 defendant Plummer Roger husbandman 590089 590089 Plummer, Roger, of Polsted, husbandman 4
5350802 2460362 2460362 defendant Prat John yeoman 590089 590089 Prat, John, of Polsted, yeoman 0
5378112 2468732 2468732 defendant Gamelyn Robert carpenter 590089 590089 Gamelyn, Robert, of Polsted, carpenter 1
5378116 2468733 2468733 defendant Gamelyn Robert carpenter 590089 590089 Gamelyn, Robert, of Polsted, carpenter 1
5476053 2497852 2497852 defendant Gamelyn Robert carpenter 590089 590089 Gamelyn, Robert, of Polsted, carpenter 0
5487547 2501169 2501169 defendant Gamelyn Robert carpenter 590089 590089 Gamelyn, Robert, of Polsted, carpenter 0
5502334 2505653 2505653 defendant Gamlyn Robert carpenter 590089 590089 Gamlyn, Robert, of Polsted, carpenter 2
5517519 2510321 2510321 defendant Gamelyn Robert yeoman or timberman 590089 590089 Gamelyn, Robert, of Polsted, yeoman or timberman 1
5561721 2523414 2523414 defendant Baudewyn Thomas yeoman 590089 590089 Baudewyn, Thomas, of Polsted, yeoman 1
5590144 2531892 2531892 defendant Baker Thomas clerk 590089 590089 Baker, Thomas, of Polsted, clerk 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);