names

54 rows where place_id = 587695

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592167 1865169 1865169 defendant Burges John wheeler 587695 587695 Burges, John, of Buxsted, wheeler 4
3629755 1904157 1904157 defendant Levett William carpenter 587695 587695 Levett, William, of Buxsted, carpenter 0
3636157 1906099 1906099 defendant Grenegore John tailor 587695 587695 Grenegore, John, of Buxsted, tailor 0
3636158 1906099 1906099 defendant Burges Thomas laborer 587695 587695 Burges, Thomas, of Buxsted, laborer 1
3636160 1906099 1906099 defendant Dopson William laborer 587695 587695 Dopson, William, of Buxsted, laborer 3
3636161 1906099 1906099 defendant Levet William carpenter 587695 587695 Levet, William, of Buxsted, carpenter 4
3636162 1906099 1906099 defendant Doglee John tanner 587695 587695 Doglee, John, of Buxsted, tanner 5
3636164 1906099 1906099 defendant Burges John, junior laborer 587695 587695 Burges, John, junior, of Buxsted, laborer 7
3740707 1938955 1938955 defendant Machyn John yeoman 587695 587695 Machyn, John, of Buxsted, yeoman 0
3816625 1963100 1963100 defendant Rote William clerk 587695 587695 Rote, William, of Buxsted, clerk 1
3825844 1965932 1965932 defendant Yonge Richard husbandman 587695 587695 Yonge, Richard, of Buxsted, husbandman 0
3846256 1972385 1972385 defendant Yong Richard yeoman 587695 587695 Yong, Richard, of Buxsted, yeoman 1
3856210 1975562 1975562 defendant Dycare William yeoman 587695 587695 Dycare, William, of Buxsted, yeoman 0
3950091 2007115 2007115 defendant Wyllard Robert butcher 587695 587695 Wyllard, Robert, of Buxsted, butcher 0
3957324 2009622 2009622 defendant Wooddye Robert   587695 587695 Wooddye, Robert, of Buxsted, gent, son of William Wooddye, of Buxsted 0
3993076 2022274 2022274 defendant Burgeys Thomas husbandman 587695 587695 Burgeys, Thomas, of Buxsted, husbandman 0
3994768 2022879 2022879 defendant Parker alias Barbor William husbandman 587695 587695 Parker alias Barbor, William, of Buxsted, husbandman 4
4012397 2029156 2029156 defendant Dyne or Dyve John husbandman 587695 587695 Dyne or Dyve, John, of Buxsted, husbandman 0
4030291 2035488 2035488 defendant Dyne John, senior smith 587695 587695 Dyne, John, senior, of Buxsted, smith 0
4045486 2040840 2040840 defendant Cowcheman George tailor 587695 587695 Cowcheman, George, of Buxsted, tailor 0
4045489 2040841 2040841 defendant Cowtheman George tailor 587695 587695 Cowtheman, George, of Buxsted, tailor 0
4046813 2041314 2041314 defendant Symond Thomas collier 587695 587695 Symond, Thomas, of Buxsted, collier 0
4052855 2043456 2043456 defendant Phillippe Edward tailor 587695 587695 Phillippe, Edward, of Buxsted, yeoman, or of Hasting, tailor 0
4070823 2049861 2049861 defendant Pentcost John husbandman 587695 587695 Pentcost, John, of Buxsted, husbandman 0
4094840 2058487 2058487 defendant Laurence Maurice hammer man 587695 587695 Laurence, Maurice, of Buxsted, hammer man 0
4103290 2061458 2061458 defendant Sleche John yeoman 587695 587695 Sleche, John, of Buxsted, yeoman 0
4107064 2062820 2062820 defendant Vynton Henry husbandman 587695 587695 Vynton, Henry, of Buxsted, husbandman 2
4169335 2084779 2084779 defendant Cade Thomas husbandman 587695 587695 Cade, Thomas, of Buxsted, husbandman 2
4171456 2085481 2085481 defendant Hogge Ralph yeoman 587695 587695 Hogge, Ralph, of Buxsted, yeoman 0
4190597 2092272 2092272 defendant Corneford Robert yeoman 587695 587695 Corneford, Robert, of Buxsted, yeoman 0
4257519 2115488 2115488 defendant Pettit Robert yeoman 587695 587695 Pettit, Robert, of Buxsted, yeoman 1
4269722 2119461 2119461 defendant Pettit Robert yeoman 587695 587695 Pettit, Robert, of Buxsted, yeoman 1
4350972 2147595 2147595 defendant Cornforde Robert yeoman 587695 587695 Cornforde, Robert, of Buxsted, yeoman 0
4375022 2156127 2156127 defendant Cornforde Robert yeoman 587695 587695 Cornforde, Robert, of Buxsted, yeoman 0
4375450 2156274 2156274 defendant Wyllyams John yeoman 587695 587695 Wyllyams, John, of Buxsted, yeoman 0
4375457 2156276 2156276 defendant Wyllyams John yeoman 587695 587695 Wyllyams, John, of Buxsted, yeoman 2
4416727 2170097 2170097 defendant Beltald John   587695 587695 Beltald, John, of Buxsted 0
4723064 2272524 2272524 defendant Galop William laborer 587695 587695 Galop, William, of Buxsted, laborer 1
4775981 2288487 2288487 defendant Dyere Robert husbandman 587695 587695 Dyere, Robert, of Buxsted, husbandman 0
4964830 2346395 2346395 defendant Page John thatcher 587695 587695 Page, John, of Buxsted, thatcher 0
4977139 2350117 2350117 defendant Mascall John husbandman 587695 587695 Mascall, John, of Buxsted, husbandman 0
5007921 2359206 2359206 defendant Pentecost William husbandman 587695 587695 Pentecost, William, of Buxsted, husbandman 1
5035669 2367287 2367287 defendant Mascall John yeoman 587695 587695 Mascall, John, of Buxsted, yeoman 1
5035675 2367288 2367288 defendant Mascall John yeoman 587695 587695 Mascall, John, of Buxsted, yeoman 1
5104016 2387599 2387599 defendant Mabbe Thomas wheeler 587695 587695 Mabbe, Thomas, of Buxsted, wheeler 0
5104017 2387599 2387599 defendant Mabbe Robert wheeler 587695 587695 Mabbe, Robert, of Buxsted, wheeler 1
5113201 2390258 2390258 defendant atte Melle Robert butcher 587695 587695 atte Melle, Robert,of Buxsted, butcher 0
5189367 2412623 2412623 defendant atte Melle Robert butcher 587695 587695 atte Melle, Robert, of Buxsted, butcher 2
5206482 2417629 2417629 defendant atte Melle Robert butcher 587695 587695 atte Melle, Robert, of Buxsted, butcher 2
5489820 2501838 2501838 defendant Ludwell John husbandman 587695 587695 Ludwell, John, of Buxsted, husbandman 0
5489824 2501839 2501839 defendant Ludwell John husbandman 587695 587695 Ludwell, John, of Buxsted, husbandman 0
5526017 2512728 2512728 defendant Salmon Thomas laborer 587695 587695 Salmon, Thomas, of Buxsted, laborer 9
5598728 2534478 2534478 defendant Burges John, junior tanner 587695 587695 Burges, John, junior, of Buxsted, tanner 0
5604142 2536155 2536155 defendant Grenegore John laborer 587695 587695 Grenegore, John, of Buxsted, laborer 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);