names

53 rows where place_id = 740216

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4339475 2143574 2143574 defendant Cockborne George clerk 740216 740216 Cockborne, George, of Gretam, clerk 0
4903903 2327836 2327836 defendant Stykney John husbandman 740216 740216 Stykney, John, of Gretam, husbandman 1
5055373 2373193 2373193 defendant Assher Nicholas husbandman 740216 740216 Assher, Nicholas, of Gretam, husbandman 0
5055374 2373193 2373193 defendant Assher William husbandman 740216 740216 Assher, William, of Gretam, husbandman 1
5055375 2373193 2373193 defendant Assher Henry husbandman 740216 740216 Assher, Henry, of Gretam, husbandman 2
5055376 2373193 2373193 defendant Edmond William husbandman 740216 740216 Edmond, William, of Gretam, husbandman 3
5055377 2373193 2373193 defendant Clerk William husbandman 740216 740216 Clerk, William, of Gretam, husbandman 4
5055378 2373193 2373193 defendant Money William husbandman 740216 740216 Money, William, of Gretam, husbandman 5
5055379 2373193 2373193 defendant Bocher William husbandman 740216 740216 Bocher, William, of Gretam, husbandman 6
5055380 2373193 2373193 defendant Stallok John husbandman 740216 740216 Stallok, John, of Gretam, husbandman 7
5055381 2373193 2373193 defendant Crosse Henry husbandman 740216 740216 Crosse, Henry, of Gretam, husbandman 8
5055382 2373193 2373193 defendant Godehous Thomas husbandman 740216 740216 Godehous, Thomas, of Gretam, husbandman 9
5055383 2373193 2373193 defendant Parker John husbandman 740216 740216 Parker, John, of Gretam, husbandman 10
5055384 2373193 2373193 defendant Edlyn William husbandman 740216 740216 Edlyn, William, of Gretam, husbandman 11
5078558 2380083 2380083 defendant Assher Nicholas husbandman 740216 740216 Assher, Nicholas, of Gretam, husbandman 0
5078559 2380083 2380083 defendant Assher William husbandman 740216 740216 Assher, William, of Gretam, husbandman 1
5078560 2380083 2380083 defendant Assher Henry husbandman 740216 740216 Assher, Henry, of Gretam, husbandman 2
5078561 2380083 2380083 defendant Edmond William husbandman 740216 740216 Edmond, William, of Gretam, husbandman 3
5078562 2380083 2380083 defendant Clerk William husbandman 740216 740216 Clerk, William, of Gretam, husbandman 4
5078563 2380083 2380083 defendant Money William husbandman 740216 740216 Money, William, of Gretam, husbandman 5
5078564 2380083 2380083 defendant Bocher William husbandman 740216 740216 Bocher, William, of Gretam, husbandman 6
5078565 2380083 2380083 defendant Stallok John husbandman 740216 740216 Stallok, John, of Gretam, husbandman 7
5078566 2380083 2380083 defendant Crosse Henry husbandman 740216 740216 Crosse, Henry, of Gretam, husbandman 8
5078567 2380083 2380083 defendant Godehous Thomas husbandman 740216 740216 Godehous, Thomas, of Gretam, husbandman 9
5078568 2380083 2380083 defendant Parker John husbandman 740216 740216 Parker, John, of Gretam, husbandman 10
5078569 2380083 2380083 defendant Edlyn William husbandman 740216 740216 Edlyn, William, of Gretam, husbandman 11
5103665 2387500 2387500 defendant Assher Nicholas husbandman 740216 740216 Assher, Nicholas, of Gretam, husbandman 0
5103666 2387500 2387500 defendant Assher William husbandman 740216 740216 Assher, William, of Gretam, husbandman 1
5103667 2387500 2387500 defendant Assher Henry husbandman 740216 740216 Assher, Henry, of Gretam, husbandman 2
5103668 2387500 2387500 defendant Clerk William husbandman 740216 740216 Clerk, William, of Gretam, husbandman 3
5103669 2387500 2387500 defendant Money William husbandman 740216 740216 Money, William, of Gretam, husbandman 4
5103670 2387500 2387500 defendant Bocher William husbandman 740216 740216 Bocher, William,of Gretam, husbandman 5
5103671 2387500 2387500 defendant Stallok John husbandman 740216 740216 Stallok, John, of Gretam, husbandman 6
5103672 2387500 2387500 defendant Crosse Henry husbandman 740216 740216 Crosse, Henry, of Gretam, husbandman 7
5103673 2387500 2387500 defendant Godehous Thomas husbandman 740216 740216 Godehous, Thomas, of Gretam, husbandman 8
5103674 2387500 2387500 defendant Parker John husbandman 740216 740216 Parker, John, of Gretam, husbandman 9
5103675 2387500 2387500 defendant Edlyn William husbandman 740216 740216 Edlyn, William, of Gretam, husbandman 10
5275521 2437910 2437910 plaintiff Stanes Walter   740216 740216 Stanes, Walter, of Gretam, parson 0
5275522 2437910 2437910 defendant Rathby John yeoman 740216 740216 Rathby, John, of Gretam, yeoman 0
5508520 2507534 2507534 defendant Man Thomas yeoman 740216 740216 Man, Thomas, of Gretam, yeoman 0
5508521 2507534 2507534 defendant Edmond William yeoman 740216 740216 Edmond, William, of Gretam, yeoman 1
5508522 2507534 2507534 defendant Plumpton John yeoman 740216 740216 Plumpton, John, of Gretam, yeoman 2
5508523 2507534 2507534 defendant Freman William yeoman 740216 740216 Freman, William, of Gretam, yeoman 3
5508524 2507534 2507534 defendant Leche William yeoman 740216 740216 Leche, William, of Gretam, yeoman 4
5508525 2507534 2507534 defendant Lidster William yeoman 740216 740216 Lidster, William, of Gretam, yeoman 5
5508526 2507534 2507534 defendant Hopkyns Robert yeoman 740216 740216 Hopkyns, Robert, of Gretam, yeoman 6
5508527 2507534 2507534 defendant Walker Henry yeoman 740216 740216 Walker, Henry, of Gretam, yeoman 7
5508528 2507534 2507534 defendant Crosse John yeoman 740216 740216 Crosse, John, of Gretam, yeoman 8
5508529 2507534 2507534 defendant Mone John yeoman 740216 740216 Mone, John, of Gretam, yeoman 9
5508530 2507534 2507534 defendant Wells Thomas yeoman 740216 740216 Wells, Thomas, of Gretam, yeoman 10
5508531 2507534 2507534 defendant Staylok John yeoman 740216 740216 Staylok, John, of Gretam, yeoman 11
5508532 2507534 2507534 defendant Torry Robert yeoman 740216 740216 Torry, Robert, of Gretam, yeoman 12
5508533 2507534 2507534 defendant Pykwell John yeoman 740216 740216 Pykwell, John, of Gretam, yeoman 13

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