names

29 rows where place_id = 608270

✎ 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
3672961 1917556 1917556 defendant Lorwynche John husbandman 608270 608270 Lorwynche, John, of Wodmancote, husbandman 0
3698927 1925878 1925878 defendant Gregory John laborer 608270 608270 Gregory, John, of Wodmancote, laborer 2
3698929 1925878 1925878 defendant Bonyface Thomas husbandman 608270 608270 Bonyface, Thomas, of Wodmancote, husbandman 4
3736030 1937510 1937510 defendant Bonyface Thomas husbandman 608270 608270 Bonyface, Thomas, of Wodmancote, husbandman 3
3776243 1950316 1950316 defendant Berde William yeoman 608270 608270 Berde, William, of Wodmancote, yeoman 0
3814553 1962464 1962464 defendant Cokkys William weaver 608270 608270 Cokkys, William, of Wodmancote, weaver 3
3856557 1975677 1975677 defendant Daunse William husbandman 608270 608270 Daunse, William, of Wodmancote, husbandman 0
3856558 1975677 1975677 defendant Browne Thomas weaver 608270 608270 Browne, Thomas, of Wodmancote, weaver 1
3856559 1975677 1975677 defendant Tukker Philip tucker 608270 608270 Tukker, Philip, of Wodmancote, tucker 2
3856560 1975677 1975677 defendant Mayle Henry weaver 608270 608270 Mayle, Henry, of Wodmancote, weaver 3
3856561 1975677 1975677 defendant Spencer John tucker 608270 608270 Spencer, John, of Wodmancote, tucker 4
3893901 1988182 1988182 defendant Holden Nicholas weaver 608270 608270 Holden, Nicholas, of Wodmancote, weaver 4
4824006 2303583 2303583 defendant Prentys Simon laborer 608270 608270 Prentys, Simon, of Wodmancote, laborer 2
4930397 2335907 2335907 defendant Bailly William husbandman 608270 608270 Bailly, William, of Wodmancote, husbandman 0
4996512 2355812 2355812 defendant Sankyn Edmund husbandman 608270 608270 together with Sankyn, Edmund, of Wodmancote, husbandman 6
4996517 2355813 2355813 defendant Saukyn Edmund husbandman 608270 608270 Saukyn, Edmund, of Wodmancote, husbandman 1
5009062 2359533 2359533 defendant atte Wode Thomas   608270 608270 atte Wode, Thomas, of Wodmancote, bailiff 1
5009063 2359533 2359533 defendant atte Wode John husbandman 608270 608270 atte Wode, John, of Wodmancote, husbandman 2
5009067 2359534 2359534 defendant att Wode Thomas   608270 608270 att Wode, Thomas, of Wodmancote, bailiff 1
5010354 2359898 2359898 defendant Payn John husbandman 608270 608270 Payn, John, of Wodmancote, husbandman 0
5123716 2393396 2393396 defendant Plomeswode Walter tucker 608270 608270 Plomeswode, Walter, of Wodmancote, tucker 0
5295767 2443756 2443756 defendant Payn John husbandman 608270 608270 Payn, John, of Wodmancote, husbandman 0
5412844 2478788 2478788 defendant Coke James husbandman 608270 608270 Coke, James, of Wodmancote, husbandman 0
5481749 2499474 2499474 defendant Cole Richard weaver 608270 608270 Cole, Richard, of Wodmancote, weaver 1
5583379 2529875 2529875 defendant Browne Thomas husbandman 608270 608270 Browne, Thomas, of Wodmancote, husbandman 0
5602769 2535746 2535746 defendant Seman Robert weaver 608270 608270 Seman, Robert, of Wodmancote, weaver 0
5636587 2555387 2555387 defendant Hunte John parker 608270 608270 Hunte, John, of Wodmancote, parker 0
5636588 2555387 2555387 defendant Selle Thomas laborer 608270 608270 Selle, Thomas, of Wodmancote, laborer 1
5636592 2555387 2555387 defendant Peny William laborer 608270 608270 Peny, William, of Wodmancote, laborer 5

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