names

23 rows where place_id = 640328

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3854649 1975098 1975098 defendant Seggebarowe Richard yeoman 640328 640328 Seggebarowe, Richard, of Old Wyndesore, yeoman 0
4416601 2170058 2170058 defendant atte Berne Gilbert   640328 640328 atte Berne, Gilbert, of Old Wyndesore 0
4604266 2232504 2232504 plaintiff Walton Thomas   640328 640328 Walton, Thomas, of Old Wyndesore 2
4742299 2278239 2278239 defendant Fazakerley Simon yeoman 640328 640328 Fazakerley, Simon, of Old Wyndesore, yeoman 2
4798967 2295849 2295849 defendant Hardwyn John laborer 640328 640328 together with Hardwyn, John, of Old Wyndesore, laborer 2
4956497 2343902 2343902 defendant Wayte Roger husbandman 640328 640328 Wayte, Roger, of Old Wyndesore, husbandman 0
5016791 2361805 2361805 defendant Walton Nicholas gent 640328 640328 Walton, Nicholas, of Old Wyndesore, gent 0
5016792 2361805 2361805 defendant Wade Robert fisher 640328 640328 Wade, Robert, of Old Wyndesore, fisher 1
5118694 2391898 2391898 defendant Garston John husbandman 640328 640328 Garston, John, of Old Wyndesore, husbandman 1
5239575 2427160 2427160 defendant Style Thomas gent 640328 640328 Style, Thomas, of Old Wyndesore, gent 1
5245708 2428908 2428908 defendant Meyre Philip   640328 640328 Meyre, Philip, of Old Wyndesore 0
5352050 2460747 2460747 defendant Pery Edmund yeoman 640328 640328 Pery, Edmund, of Old Wyndesore, yeoman 1
5411237 2478321 2478321 defendant Tyle Thomas (legal representative) 640328 640328 Tyle, Thomas, of Old Wyndesore, administratrix of 0
5433679 2485037 2485037 defendant Eede Robert yeoman 640328 640328 Eede, Robert, of Old Wyndesore, yeoman 8
5433682 2485037 2485037 defendant Meyr John yeoman 640328 640328 Meyr, John, of Old Wyndesore, yeoman 11
5551580 2520503 2520503 defendant Ferrour John yeoman 640328 640328 Ferrour, John, of Old Wyndesore, yeoman 2
5554771 2521402 2521402 defendant Ferrour John yeoman 640328 640328 Ferrour, John, of Old Wyndesore, yeoman 1
5554807 2521405 2521405 defendant Ferrour John yeoman 640328 640328 Ferrour, John, of Old Wyndesore, yeoman 3
5593635 2532993 2532993 defendant Bartelet John husbandman 640328 640328 Bartelet, John, of Old Wyndesore, husbandman 0
5593636 2532993 2532993 defendant Barne Henry husbandman 640328 640328 Barne, Henry, of Old Wyndesore, husbandman 1
5593637 2532993 2532993 defendant Broun William husbandman 640328 640328 Broun, William, of Old Wyndesore, husbandman 2
5593638 2532993 2532993 defendant Bexfeld John husbandman 640328 640328 Bexfeld, John, of Old Wyndesore, husbandman 3
5593639 2532993 2532993 defendant Donne or Doune William husbandman 640328 640328 Donne or Doune, William, of Old Wyndesore, husbandman 4

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);