names

36 rows where place_id = 618394

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3724364 1933907 1933907 defendant Jonys Henry husbandman 618394 618394 Jonys, Henry, of Avenbury, husbandman 2
3775943 1950224 1950224 defendant Barne Walter husbandman 618394 618394 Barne, Walter, of Avenbury, husbandman 1
3858991 1976500 1976500 defendant Jones Henry husbandman 618394 618394 Jones, Henry, of Avenbury, husbandman 0
3878488 1983050 1983050 defendant Berne Richard husbandman 618394 618394 Berne, Richard, of Avenbury, husbandman 1
3896731 1989117 1989117 defendant Hunte John husbandman 618394 618394 Hunte, John, of Avenbury, husbandman 0
3946462 2005830 2005830 defendant Broune Richard gent 618394 618394 Broune, Richard, of Avenbury, gent 0
3956968 2009501 2009501 defendant Browne Richard gent 618394 618394 Browne, Richard, of Avenbury, gent 2
3990432 2021333 2021333 defendant Boyse Richard yeoman 618394 618394 Boyse, Richard, of Avenbury, yeoman 0
3990433 2021333 2021333 defendant Boyse John yeoman 618394 618394 Boyse, John, of Avenbury, yeoman 1
3994806 2022894 2022894 defendant Boyse William weaver 618394 618394 Boyse, William, of Avenbury, weaver 1
4001477 2025307 2025307 defendant ap Powell William Griffith laborer 618394 618394 ap Powell, William Griffith, of Avenbury, laborer 1
4016496 2030606 2030606 defendant Boysse Richard husbandman 618394 618394 Boysse, Richard, of Avenbury, husbandman 0
4024245 2033375 2033375 defendant Boyse Thomas yeoman 618394 618394 Boyse, Thomas, of Avenbury, yeoman 0
4036978 2037899 2037899 defendant Boyse John yeoman 618394 618394 Boyse, John, of Avenbury, yeoman 0
4036982 2037900 2037900 defendant Boyse John yeoman 618394 618394 Boyse, John, of Avenbury, yeoman 0
4036991 2037901 2037901 defendant Boysshe John yeoman 618394 618394 Boysshe, John, of Avenbury, yeoman 3
4036997 2037902 2037902 defendant Boysshe John yeoman 618394 618394 Boysshe, John, of Avenbury, yeoman 3
4047394 2041524 2041524 defendant Jones Henry husbandman 618394 618394 Jones, Henry, of Avenbury, husbandman 2
4047395 2041524 2041524 defendant Boyse William weaver 618394 618394 Boyse, William, of Avenbury, weaver 3
4047774 2041651 2041651 defendant Boysse William weaver 618394 618394 Boysse, William, of Avenbury, weaver 1
4059451 2045775 2045775 defendant Jones Henry yeoman 618394 618394 Jones, Henry, of Avenbury, yeoman 0
4059452 2045775 2045775 defendant Jones Richard   618394 618394 Jones, Richard, of Avenbury, his son 1
4059454 2045776 2045776 defendant Jones Henry yeoman 618394 618394 Jones, Henry, of Avenbury, yeoman 0
4111840 2064486 2064486 defendant Jones Henry yeoman 618394 618394 Jones, Henry, of Avenbury, yeoman 2
4167496 2084129 2084129 defendant Boyse William weaver 618394 618394 Boyse, William, of Avenbury, weaver 0
4167497 2084129 2084129 defendant Boyse John miller 618394 618394 Boyse, John, of Avenbury, miller 1
4285954 2125032 2125032 defendant More John yeoman 618394 618394 More, John, of Avenbury, yeoman 0
4304209 2131605 2131605 defendant More John yeoman 618394 618394 More, John, of Avenbury, yeoman 0
4311409 2134132 2134132 defendant Corbett Roger yeoman 618394 618394 Corbett, Roger, of Avenbury, yeoman 0
4317677 2136294 2136294 defendant Hancoxe Richard yeoman 618394 618394 Hancoxe, Richard, of Avenbury, yeoman 0
4326467 2139214 2139214 defendant Collyns John yeoman 618394 618394 Collyns, John, of Avenbury, yeoman 1
4360322 2150859 2150859 defendant Moore John yeoman 618394 618394 Moore, John, of Avenbury, yeoman 0
4424619 2172539 2172539 defendant Rogers William   618394 618394 Rogers, William, of Avenbury 2
4854001 2312659 2312659 defendant Aleyn John   618394 618394 Aleyn, John, of Avenbury, vicar 0
5255650 2431884 2431884 defendant Conyng John yeoman 618394 618394 Conyng, John, of Avenbury, yeoman 1
5259957 2433236 2433236 defendant Kenard John husbandman 618394 618394 Kenard, John, of Avenbury, 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);