names

42 rows where place_id = 592901

✎ 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
3609318 1870573 1870573 defendant Poty Robert mariner 592901 592901 Poty, Robert, of Walberswyk, mariner 0
3628662 1903839 1903839 defendant Gybbys Henry mariner 592901 592901 Gybbys, Henry, of Walberswyk, mariner 0
3628663 1903839 1903839 defendant Pyn John yeoman 592901 592901 Pyn, John, of Walberswyk, yeoman 1
3655968 1912117 1912117 defendant Gemyngham William mariner 592901 592901 Gemyngham, William, of Walberswyk, mariner 0
3676924 1918820 1918820 defendant Brewett John mariner 592901 592901 Brewett, John, of Walberswyk, mariner 4
3751820 1942488 1942488 defendant Fyn John fisherman 592901 592901 Fyn, John, of Walberswyk, fisherman 4
3821037 1964471 1964471 defendant Broke Robert mariner 592901 592901 Broke, Robert, of Walberswyk, mariner 5
3840578 1970617 1970617 plaintiff Arnold Thomas   592901 592901 Arnold, Thomas, of Walberswyk, shipwright 0
3840580 1970618 1970618 plaintiff Arnold Thomas   592901 592901 Arnold, Thomas, of Walberswyk, shipwright 0
3847789 1972883 1972883 defendant Arnold Thomas   592901 592901 Arnold, Thomas, of Walberswyk, shipwright 0
3868717 1979778 1979778 defendant Gardener John mariner 592901 592901 Gardener, John, of Walberswyk, mariner 2
3872007 1980869 1980869 defendant Paveys Robert yeoman 592901 592901 Paveys, Robert, of Walberswyk, yeoman 0
3942862 2004617 2004617 defendant Becke John mariner 592901 592901 (Becke, John, of Walberswyk, mariner 1
4644901 2244575 2244575 defendant Sothern John   592901 592901 Sothern, John, of Walberswyk 0
4657195 2248134 2248134 defendant Wytherley John chaplain 592901 592901 Wytherley, John, of Walberswyk, chaplain 0
4681531 2259835 2259835 defendant Nicol Stephen shipman 592901 592901 Nicol, Stephen, of Walberswyk, shipman 1
4814059 2300502 2300502 defendant Pollyng Thomas husbandman 592901 592901 Pollyng, Thomas, of Walberswyk, husbandman 0
4918376 2332264 2332264 defendant Ducheman Adrian yeoman 592901 592901 Ducheman, Adrian, of Walberswyk, yeoman 0
4918377 2332264 2332264 defendant fuller Thomas husbandman & son or John Fuller 592901 592901 fuller, Thomas, of Walberswyk, husbandman & son or John Fuller 1
4950968 2342269 2342269 defendant Calsawe or Chalfhawe John chaplain 592901 592901 Calsawe or Chalfhawe, John, of Walberswyk, chaplain 0
4966352 2346871 2346871 defendant Calfhawe John clerk 592901 592901 Calfhawe, John, of Walberswyk, clerk 0
5052466 2372332 2372332 plaintiff Almygame Walter (legal representative) 592901 592901 Almygame, Walter, of Walberswyk, executors of 0
5127170 2394423 2394423 defendant Medylton John   592901 592901 Medylton, John, of Walberswyk, shipwright 2
5132133 2395889 2395889 defendant Smyth Ralph smith 592901 592901 Smyth, Ralph, of Walberswyk, smith 0
5142482 2398930 2398930 defendant Weve or Wene William carpenter 592901 592901 Weve or Wene, William, of Walberswyk, carpenter 0
5188289 2412285 2412285 defendant Jolle John yeoman 592901 592901 Jolle, John, of Walberswyk, yeoman 1
5204700 2417119 2417119 defendant Ducheman James   592901 592901 Ducheman, James, of Walberswyk, dutch man 4
5205985 2417482 2417482 defendant Jolle John yeoman 592901 592901 Jolle, John, of Walberswyk, yeoman 1
5230261 2424469 2424469 defendant Berebrewer Hugh husbandman 592901 592901 Berebrewer, Hugh, of Walberswyk, husbandman 0
5230262 2424469 2424469 defendant Ducheman Simon berebrewer 592901 592901 Ducheman, Simon, of Walberswyk, berebrewer 1
5377960 2468687 2468687 defendant Broun John pedder 592901 592901 Broun, John, of Walberswyk, pedder 0
5425569 2482623 2482623 defendant Ids John cooper 592901 592901 Ids, John, of Walberswyk, cooper 1
5465815 2494692 2494692 defendant Breton John merchant 592901 592901 Breton, John, of Walberswyk, merchant 0
5536845 2516012 2516012 defendant Ballard Richard yeoman 592901 592901 Ballard, Richard, of Walberswyk, yeoman 0
5536846 2516012 2516012 defendant Pygot Thomas mariner 592901 592901 Pygot, Thomas, of Walberswyk, mariner 1
5536847 2516012 2516012 defendant Grave Thomas mariner 592901 592901 Grave, Thomas, of Walberswyk, mariner 2
5536848 2516012 2516012 defendant Poty Thomas mariner 592901 592901 Poty, Thomas, of Walberswyk, mariner 3
5560214 2522949 2522949 defendant Ballard Richard gent 592901 592901 Ballard, Richard, of Walberswyk, gent 0
5563225 2523843 2523843 defendant Payn John mariner 592901 592901 Payn, John, of Walberswyk, mariner 0
5563226 2523843 2523843 defendant Wymond Roger mariner 592901 592901 Wymond, Roger, of Walberswyk, mariner 1
5577161 2527907 2527907 defendant Payn John mariner 592901 592901 Payn, John, of Walberswyk, mariner 0
5599155 2534617 2534617 defendant Colles John merchant 592901 592901 Colles, John, of Walberswyk, merchant 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);