names

29 rows where place_id = 651448

✎ 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
3917803 1996315 1996315 defendant Stretyn Richard husbandman 651448 651448 Stretyn, Richard, of Westden, husbandman 0
3917804 1996315 1996315 defendant Stretyn John husbandman 651448 651448 Stretyn, John, of Westden, husbandman 1
4585408 2226858 2226858 defendant Mulleward John   651448 651448 Mulleward, John, of Westden 4
4692422 2263148 2263148 defendant Howell William   651448 651448 Howell, William, of Westden, shepherd 0
4696342 2264335 2264335 defendant Symond Henry husbandman 651448 651448 Symond, Henry, of Westden, husbandman 0
4696343 2264335 2264335 defendant Saffray Richard husbandman 651448 651448 Saffray, Richard, of Westden, husbandman 1
4696344 2264335 2264335 defendant Mundy John husbandman 651448 651448 Mundy, John, of Westden, husbandman 2
4704137 2266673 2266673 defendant atte Broke Philip husbandman 651448 651448 atte Broke, Philip, of Westden, husbandman 0
4732586 2275367 2275367 defendant smyth Andrew smith 651448 651448 smyth, Andrew, of Westden, smith 1
4748956 2280179 2280179 defendant Bretton John laborer 651448 651448 Bretton, John, of Westden, laborer 0
4748957 2280179 2280179 defendant Brydham John husbandman 651448 651448 Brydham, John, of Westden, husbandman 1
4748960 2280179 2280179 defendant Raynold John, junior laborer 651448 651448 Raynold, John, junior, of Westden, laborer 4
4761564 2283962 2283962 defendant Bretton John laborer 651448 651448 Bretton, John, of Westden, laborer 0
4761565 2283962 2283962 defendant Bridham John husbandman 651448 651448 Bridham, John, of Westden, husbandman 1
4776982 2288783 2288783 defendant Fleccher Henry husbandman 651448 651448 together with Fleccher, Henry, of Westden, husbandman 1
4776983 2288783 2288783 defendant Sleter John husbandman 651448 651448 Sleter, John, of Westden, husbandman 2
4776984 2288783 2288783 defendant atte Nassh John laborer 651448 651448 atte Nassh, John, of Westden, laborer 3
4776985 2288783 2288783 defendant Reynald John, senior husbandman 651448 651448 Reynald, John, senior, of Westden, husbandman 4
4776986 2288783 2288783 defendant Reynald John, junior husbandman 651448 651448 Reynald, John, junior, of Westden, husbandman 5
4967881 2347338 2347338 plaintiff Bray John   651448 651448 Bray, John, of Westden 1
4988596 2353546 2353546 defendant Poteman Jophn husbandman 651448 651448 Poteman, Jophn, of Westden, husbandman 0
5058849 2374213 2374213 defendant Sage William husbandman 651448 651448 Sage, William, of Westden, husbandman 1
5058850 2374213 2374213 defendant Colyn John   651448 651448 Colyn, John, of Westden, "hoggeheler" 2
5266565 2435294 2435294 defendant Remys John husbandman 651448 651448 Remys, John, of Westden, husbandman 0
5334572 2455408 2455408 defendant Herkele William, junior yeoman 651448 651448 Herkele, William, junior, of Westden, yeoman 11
5525946 2512708 2512708 defendant Colloke William yeoman 651448 651448 Colloke, William, of Westden, yeoman 1
5525949 2512709 2512709 defendant Colloke William yeoman 651448 651448 Colloke, William, of Westden, yeoman 1
5525952 2512710 2512710 defendant Colloke William yeoman 651448 651448 Colloke, William, of Westden, yeoman 1
5582793 2529691 2529691 defendant Mabbe Richard husbandman 651448 651448 (Mabbe, Richard, of Westden, 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);