names

24 rows where place_id = 813344

✎ 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
4855588 2313113 2313113 defendant Geffre John yeoman 813344 813344 Geffre, John, of Plympton Priors, yeoman 1
4911782 2330187 2330187 defendant Sprydell John fuller 813344 813344 Sprydell, John, of Plympton Priors, fuller 0
4916191 2331566 2331566 defendant Porter John laborer 813344 813344 Porter, John, of Plympton Priors, laborer 0
4955762 2343688 2343688 defendant Frend William smith 813344 813344 Frend, William, of Plympton Priors, smith 0
5004589 2358243 2358243 defendant Frende William smith 813344 813344 together with Frende, William, of Plympton Priors, smith 1
5113425 2390320 2390320 defendant Langedon Roger husbandman 813344 813344 Langedon, Roger, of Plympton Priors, husbandman 0
5146986 2400262 2400262 defendant Steynlake John, sen husbandman 813344 813344 Steynlake, John, sen, of Plympton Priors, husbandman 0
5149080 2400857 2400857 defendant Hundesdon Nicholas husbandman 813344 813344 Hundesdon, Nicholas, of Plympton Priors, husbandman 3
5149081 2400857 2400857 defendant Partryche John husbandman 813344 813344 Partryche, John, of Plympton Priors, husbandman 4
5149082 2400857 2400857 defendant Whetell Nicholas husbandman 813344 813344 Whetell, Nicholas, of Plympton Priors, husbandman 5
5149083 2400857 2400857 defendant Proude John husbandman 813344 813344 Proude, John, of Plympton Priors, husbandman 6
5222348 2422247 2422247 defendant Parke Robert baker 813344 813344 Parke, Robert, of Plympton Priors, baker 0
5222349 2422247 2422247 defendant Piers Richard   813344 813344 Piers, Richard, of Plympton Priors, millward 1
5222350 2422247 2422247 defendant Kyng William tanner 813344 813344 Kyng, William, of Plympton Priors, tanner 2
5235843 2426064 2426064 defendant Langman John mercer 813344 813344 Langman, John, of Plympton Priors, mercer 0
5235844 2426064 2426064 defendant Langman Robert   813344 813344 Langman, Robert, of Plympton Priors, "helyer" 1
5288284 2441594 2441594 defendant Snellyng William husbandman 813344 813344 Snellyng, William, of Plympton Priors, husbandman 0
5291342 2442470 2442470 defendant Peke William   813344 813344 Peke, William, of Plympton Priors 0
5291346 2442472 2442472 defendant Benet John chaplain 813344 813344 Benet, John, of Plympton Priors, chaplain 0
5324015 2452270 2452270 defendant Peke William   813344 813344 Peke, William, of Plympton Priors 0
5341210 2457444 2457444 defendant Ayssheford John yeoman 813344 813344 Ayssheford, John, of Plympton Priors, yeoman 1
5343044 2458011 2458011 defendant Langeman Robert   813344 813344 Langeman, Robert, of Plympton Priors, "helyer" 2
5513892 2509197 2509197 defendant Tankerd Henry chaplain 813344 813344 Tankerd, Henry, of Plympton Priors, chaplain 0
5513902 2509197 2509197 defendant Grepe Thomas weaver 813344 813344 Grepe, Thomas, of Plympton Priors, weaver 10

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