names

39 rows where place_id = 592212

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588242 1863978 1863978 defendant Camme John   592212 592212 Camme, John, of Covehithe, mason 1
3606940 1869835 1869835 defendant Hardyng John mariner 592212 592212 Hardyng, John, of Covehithe, mariner 0
3880163 1983619 1983619 plaintiff Payne Thomas gent 592212 592212 Payne, Thomas, of Covehithe, gent 0
3955391 2008950 2008950 defendant Payne Robert merchant 592212 592212 Payne, Robert, of Covehithe, merchant 1
4071977 2050275 2050275 defendant Payne Robert gent 592212 592212 Payne, Robert, of Covehithe, gent 1
4248423 2112460 2112460 defendant Thorpe Lawrence bricklayer 592212 592212 Thorpe, Lawrence, of Covehithe, bricklayer 2
4569007 2221890 2221890 defendant Gygyl Richard   592212 592212 Gygyl, Richard, of Covehithe 0
4637452 2242506 2242506 defendant Tucke Walter   592212 592212 Tucke, Walter, of Covehithe 0
4712630 2269269 2269269 defendant Leek William miller 592212 592212 Leek, William, of Covehithe, miller 0
4772719 2287440 2287440 defendant Forthe Robert yeoman 592212 592212 Forthe, Robert, of Covehithe, yeoman 0
4795504 2294747 2294747 plaintiff Reynold Robert   592212 592212 Reynold, Robert, of Covehithe 0
4795505 2294747 2294747 defendant Palmer Thomas shipman 592212 592212 Palmer, Thomas, of Covehithe, shipman 0
4795506 2294747 2294747 defendant Perkyns Edmund shipman 592212 592212 Perkyns, Edmund, of Covehithe, shipman 1
4817516 2301571 2301571 defendant Palmere Thomas shipman 592212 592212 Palmere, Thomas, of Covehithe, shipman 0
4817517 2301571 2301571 defendant Adamesson Thomas shipman 592212 592212 Adamesson, Thomas, of Covehithe, shipman 1
4817518 2301571 2301571 defendant Culford Henry shipman 592212 592212 Culford, Henry, of Covehithe, shipman 2
4894262 2324892 2324892 defendant Sherman Peter Dutchman 592212 592212 Sherman, Peter, of Covehithe, Dutchman 1
4915129 2331240 2331240 defendant Forthe Robert yeoman 592212 592212 Forthe, Robert, of Covehithe, yeoman 0
4915130 2331240 2331240 defendant Palmere Thomas yeoman 592212 592212 Palmere, Thomas, of Covehithe, yeoman 1
4915131 2331240 2331240 defendant Holver or Holner Thomas yeoman 592212 592212 Holver or Holner, Thomas, of Covehithe, yeoman 2
5020229 2362807 2362807 defendant Alman John shipman 592212 592212 Alman, John, of Covehithe, shipman 1
5028013 2365072 2365072 defendant atte Welle Henry shipman 592212 592212 atte Welle, Henry, of Covehithe, shipman 2
5109265 2389136 2389136 defendant Bene Robert butcher 592212 592212 Bene, Robert, of Covehithe, butcher 1
5109266 2389136 2389136 defendant Fylby Alexander butcher 592212 592212 Fylby, Alexander, of Covehithe, butcher 2
5109366 2389168 2389168 defendant Forthe Robert yeoman 592212 592212 Forthe, Robert, of Covehithe, yeoman 1
5142847 2399036 2399036 defendant Hill William baker 592212 592212 Hill, William, of Covehithe, baker 4
5142848 2399036 2399036 defendant Reder Henry husbandman 592212 592212 Reder, Henry, of Covehithe, husbandman 5
5243418 2428270 2428270 defendant Hayron John yeoman 592212 592212 Hayron, John, of Covehithe, yeoman 3
5291322 2442464 2442464 defendant Joos Richard yeoman 592212 592212 Joos, Richard, of Covehithe, yeoman 2
5375553 2467943 2467943 defendant Doraunt William yeoman 592212 592212 Doraunt, William, of Covehithe, yeoman 2
5435432 2485537 2485537 defendant Smyth John husbandman 592212 592212 Smyth, John, of Covehithe, husbandman 4
5445043 2488405 2488405 defendant More John shoemaker 592212 592212 More, John, of Covehithe, shoemaker 0
5447768 2489211 2489211 plaintiff Wyseman John   592212 592212 Wyseman, John, of Covehithe 1
5450492 2490031 2490031 defendant Smyth John husbandman 592212 592212 Smyth, John, of Covehithe, husbandman 4
5460155 2492971 2492971 plaintiff Wyseman John   592212 592212 Wyseman, John, of Covehithe 1
5462632 2493734 2493734 defendant Smyth John husbandman 592212 592212 Smyth, John, of Covehithe, husbandman 4
5471786 2496516 2496516 plaintiff Wiseman John   592212 592212 Wiseman, John, of Covehithe 1
5471789 2496517 2496517 plaintiff Wyseman John   592212 592212 Wyseman, John, of Covehithe 1
5502190 2505612 2505612 defendant Heth John husbandman 592212 592212 Heth, John, of Covehithe, husbandman 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);