names

38 rows where place_id = 602265

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3608538 1870328 1870328 defendant Trote John husbandman 602265 602265 Trote, John, of Aysshe Prior, husbandman 2
3649215 1910143 1910143 defendant Fyssher John yeoman 602265 602265 Fyssher, John, of Aysshe, yeoman 0
3652183 1911022 1911022 defendant Trott William husbandman 602265 602265 Trott, William, of Aysshe Prior, husbandman 0
3860867 1977128 1977128 defendant Cote Roger yeoman 602265 602265 Cote, Roger, of Aysshe, yeoman 0
3915851 1995679 1995679 defendant Carlowe John yeoman 602265 602265 Carlowe, John, of Aysshe, yeoman 0
3961940 2011272 2011272 defendant Huchyns William husbandman 602265 602265 Huchyns, William, of Aysshe, husbandman 0
3983352 2018819 2018819 plaintiff Smythe William yeoman 602265 602265 Smythe, William, of Aysshe, yeoman 0
4036547 2037754 2037754 defendant Pawle Henry husbandman 602265 602265 Pawle, Henry, of Aysshe, husbandman 1
4535827 2211481 2211481 defendant Yelde John   602265 602265 Yelde, John, of Aysshe 2
4565645 2220826 2220826 defendant Yolde John   602265 602265 Yolde, John, of Aysshe 0
4612490 2234975 2234975 defendant Portour Thomas   602265 602265 Portour, Thomas, of Aysshe 0
4669390 2256135 2256135 defendant Strecche John gent 602265 602265 Strecche, John, of aysshe, gent 0
4694645 2263823 2263823 plaintiff Borde Thomas   602265 602265 Borde, Thomas, of Aysshe 0
4694648 2263824 2263824 plaintiff Borde Thomas   602265 602265 Borde, Thomas, of Aysshe 0
4773464 2287670 2287670 plaintiff Taillour John   602265 602265 Taillour, John, of Aysshe 0
4804172 2297493 2297493 defendant Stegan Hamo husbandman 602265 602265 Stegan, Hamo, of Aysshe, husbandman 3
4808262 2298762 2298762 defendant Rysdon Geoffrey husbandman 602265 602265 Rysdon, Geoffrey, of Aysshe, husbandman 2
4824468 2303702 2303702 plaintiff Taylour John (legal representative) 602265 602265 Taylour, John, of Aysshe, executors of 0
4824473 2303703 2303703 plaintiff Taylour John (legal representative) 602265 602265 Taylour, John, of Aysshe, executors of 0
4917587 2332016 2332016 defendant Carsweill Nicholas husbandman 602265 602265 Carsweill, Nicholas, of Aysshe, husbandman 0
4919704 2332669 2332669 defendant Elyot Peter husbandman 602265 602265 Elyot, Peter, of Aysshe, husbandman 0
4967719 2347291 2347291 defendant Michell John husbandman 602265 602265 Michell, John, of Aysshe, husbandman 0
4967720 2347291 2347291 defendant Watte Richard husbandman 602265 602265 Watte, Richard, of Aysshe, husbandman 1
4967721 2347291 2347291 defendant Atteley John husbandman 602265 602265 Atteley, John, of Aysshe, husbandman 2
4967722 2347291 2347291 defendant Shorte Stephen husbandman 602265 602265 Shorte, Stephen, of Aysshe, husbandman 3
4967723 2347291 2347291 defendant Forst Thomas husbandman 602265 602265 Forst, Thomas, of Aysshe, husbandman 4
5012247 2360432 2360432 defendant Benet Thomas husbandman 602265 602265 Benet, Thomas, of Aysshe, husbandman 1
5015867 2361533 2361533 defendant Maddok Stephen butcher 602265 602265 Maddok, Stephen, of Aysshe, butcher 0
5015868 2361533 2361533 defendant Leye John butcher 602265 602265 Leye, John, of Aysshe, butcher 1
5079975 2380489 2380489 defendant Hodesell William gent 602265 602265 Hodesell, William, of Aysshe, gent 0
5079976 2380489 2380489 defendant Carpenter William   602265 602265 Carpenter, William, of Aysshe, servant 1
5079977 2380489 2380489 defendant Hert Thomas laborer 602265 602265 Hert, Thomas, of Aysshe, laborer 2
5099056 2386157 2386157 defendant Harell Robert fysshiouter or fishmonger 602265 602265 Harell, Robert, of Aysshe, fysshiouter or fishmonger 0
5147500 2400414 2400414 defendant Whitehede Richard merchant 602265 602265 Whitehede, Richard, of Aysshe, merchant 5
5211617 2419136 2419136 plaintiff Robyn John   602265 602265 Robyn, John, of Aysshe 1
5264201 2434563 2434563 defendant Carent John, junior esq 602265 602265 Carent, John, junior, of Aysshe, esq 1
5497767 2504276 2504276 defendant Spurne William husbandman 602265 602265 Spurne, William, of Aysshe, husbandman 0
5497768 2504276 2504276 defendant White Thomas husbandman 602265 602265 White, Thomas, of Aysshe, husbandman 1

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