names

21 rows where place_id = 589167

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596760 1866619 1866619 defendant Godewyn William yeoman 589167 589167 Godewyn, William, of Mendelysham, yeoman 0
3602515 1868445 1868445 defendant Whytyng Robert shoemaker 589167 589167 Whytyng, Robert, of Mendelysham, shoemaker 2
3730213 1935676 1935676 defendant Neve John husbandman 589167 589167 Neve, John, of Mendelysham, husbandman 0
3730215 1935676 1935676 defendant Bak John husbandman 589167 589167 (Bak, John, of Mendelysham, husbandman 2
3748362 1941417 1941417 defendant Cooke John husbandman 589167 589167 Cooke, John, of Mendelysham, husbandman 3
4684432 2260733 2260733 defendant Ballard Seamus chaplain 589167 589167 Ballard, Seamus, of Mendelysham, chaplain 0
4989622 2353818 2353818 defendant Aldhowe Thomas gent 589167 589167 Aldhowe, Thomas, of Mendelysham, gent 16
5136455 2397178 2397178 defendant Maunyng Robert yeoman 589167 589167 Maunyng, Robert, of Mendelysham, yeoman 1
5173026 2407822 2407822 defendant Mannyng Robert yeoman 589167 589167 Mannyng, Robert, of Mendelysham, yeoman 1
5184458 2411193 2411193 defendant Boysth Geoffrey   589167 589167 Boysth, Geoffrey, of Mendelysham, glove maker 0
5184461 2411194 2411194 defendant Boysch Geoffrey   589167 589167 Boysch, Geoffrey, of Mendelysham, glove maker 0
5207908 2418043 2418043 defendant Mannyng Robert yeoman 589167 589167 Mannyng, Robert, of Mendelysham, yeoman 1
5211750 2419180 2419180 defendant Cake John cordwainer 589167 589167 Cake, John, of Mendelysham, cordwainer 0
5211751 2419180 2419180 defendant Peteman Richard tailor 589167 589167 Peteman, Richard, of Mendelysham, tailor 1
5227440 2423654 2423654 defendant Boyssh Geoffrey glover 589167 589167 Boyssh, Geoffrey, of Mendelysham, glover 0
5262119 2433901 2433901 defendant Mannyng Robert yeoman 589167 589167 Mannyng, Robert, of Mendelysham, yeoman 0
5279468 2439076 2439076 defendant Canon Walter husbandman 589167 589167 Canon, Walter, of Mendelysham, husbandman 0
5505589 2506669 2506669 defendant Goodwyn William husbandman 589167 589167 Goodwyn, William, of Mendelysham, husbandman 0
5520627 2511274 2511274 defendant Annes or Aimes Richard husbandman 589167 589167 Annes or Aimes, Richard, of Mendelysham, husbandman 3
5577771 2528116 2528116 defendant Brunwyn Robert husbandman 589167 589167 Brunwyn, Robert, of Mendelysham, husbandman 0
5592896 2532777 2532777 defendant Brunwyn Robert husbandman 589167 589167 Brunwyn, Robert, of Mendelysham, 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);