names

33 rows where place_id = 780702

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4669315 2256109 2256109 defendant Cholle John ostler 780702 780702 Cholle, John, of Royston, Cambs, ostler 4
4679606 2259238 2259238 defendant Chaundeler Walter barber 780702 780702 Chaundeler, Walter, of Royston, Cambs, barber 4
4683507 2260443 2260443 defendant Adam John husbandman 780702 780702 Adam, John, of Royston, Cambs, husbandman 0
4688456 2261958 2261958 defendant Marchall John, junior husbandman 780702 780702 Marchall, John, junior, of Royston, Cambs, husbandman 0
4701073 2265742 2265742 defendant Adam John husbandman 780702 780702 Adam, John, of Royston, Cambs, husbandman 1
4706486 2267408 2267408 defendant Plegge Richard husbandman 780702 780702 Plegge, Richard, of Royston, Cambs, husbandman 0
4718228 2271040 2271040 defendant Plegge Richard husbandman 780702 780702 Plegge, Richard, of Royston, Cambs, husbandman 2
4718229 2271040 2271040 defendant Porter William husbandman 780702 780702 Porter, William, of Royston, Cambs, husbandman 3
4718234 2271041 2271041 defendant Plegge Richard husbandman 780702 780702 Plegge, Richard, of Royston, Cambs, husbandman 2
4718240 2271042 2271042 defendant Plegge Richard husbandman 780702 780702 Plegge, Richard, of Royston, Cambs, husbandman 2
4734705 2276009 2276009 defendant Adam John miller 780702 780702 Adam, John, of Royston, Cambs, miller 3
4738724 2277199 2277199 defendant Marsshall John husbandman 780702 780702 Marsshall, John, of Royston, Cambs, husbandman 0
4751073 2280797 2280797 defendant Plegge Richard hostiller 780702 780702 Plegge, Richard, of Royston, Cambs, hostiller 0
4840826 2308665 2308665 defendant Ade_m John yeoman 780702 780702 Ade_m, John, of Royston, Cambs, yeoman 1
4848128 2310886 2310886 defendant Wylby William ostler 780702 780702 Wylby, William, of Royston, Cambs, ostler 0
4919200 2332516 2332516 defendant Haukeswell John gent 780702 780702 Haukeswell, John, of Royston, Cambs, gent 0
4919681 2332662 2332662 defendant Jankyn Alexander butcher 780702 780702 Jankyn, Alexander, of Royston, Cambs, butcher 3
4921002 2333081 2333081 defendant Hauswell John gent 780702 780702 Hauswell, John, of Royston, Cambs, gent 1
4921245 2333159 2333159 defendant Haukswell John gent 780702 780702 Haukswell, John, of Royston, Cambs, gent 1
4928351 2335291 2335291 defendant Clement William ostler 780702 780702 Clement, William, of Royston, Cambs, ostler 1
5004021 2358066 2358066 defendant Cook Richard husbandman 780702 780702 Cook, Richard, of Royston, Cambs, husbandman 3
5004029 2358067 2358067 defendant Cook Richard husbandman 780702 780702 Cook, Richard, of Royston, Cambs, husbandman 3
5006214 2358709 2358709 defendant Bernard William hosteler 780702 780702 Bernard, William, of Royston, Cambs, hosteler 0
5297624 2444309 2444309 defendant Thirlowe John gent 780702 780702 Thirlowe, John, of Royston, Cambs, gent 3
5371160 2466566 2466566 defendant Wadlowe John yeoman 780702 780702 Wadlowe, John, of Royston, Cambs, yeoman 2
5377449 2468530 2468530 defendant Wadylone or Wadylove John   780702 780702 Wadylone or Wadylove, John, of Royston, Cambs, inn holder 2
5406328 2476880 2476880 defendant Rogers Thomas hosteler 780702 780702 Rogers, Thomas, of Royston, Cambs, hosteler 3
5419394 2480716 2480716 defendant Rogiers Thomas hosteler 780702 780702 Rogiers, Thomas, of Royston, Cambs, hosteler 3
5419399 2480717 2480717 defendant Rogers Thomas hosteler 780702 780702 Rogers, Thomas, of Royston, Cambs, hosteler 3
5437716 2486217 2486217 defendant Archer Henry butcher 780702 780702 Archer, Henry, of Royston, Cambs, butcher 2
5451923 2490457 2490457 defendant Bocher Henry butcher 780702 780702 Bocher, Henry, of Royston, Cambs, butcher 2
5463287 2493930 2493930 defendant Marshall William yeoman 780702 780702 Marshall, William, of Royston, Cambs, yeoman 2
5474834 2497456 2497456 defendant Marshall William yeoman 780702 780702 Marshall, William, of Royston, Cambs, yeoman 2

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