names

35 rows where place_id = 599293

✎ 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
3636142 1906096 1906096 defendant Carver John maltman 599293 599293 Carver, John, of Sundon, maltman 0
3781265 1951881 1951881 defendant Carter Reginald husbandman 599293 599293 Carter, Reginald, of Sundon, husbandman 0
4338149 2143083 2143083 defendant Bowstred William yeoman 599293 599293 Bowstred, William, of Sundon, yeoman 1
4701339 2265819 2265819 defendant Bocher Thomas butcher 599293 599293 Bocher, Thomas, of Sundon, butcher 0
4716896 2270614 2270614 defendant Boteler Thomas butcher 599293 599293 Boteler, Thomas, of Sundon, butcher 0
4776388 2288607 2288607 defendant Longe William, junior husbandman 599293 599293 Longe, William, junior, of Sundon, husbandman 0
4777815 2289052 2289052 defendant Boteler alias Bocher Thomas husbandman 599293 599293 Boteler alias Bocher, Thomas, of Sundon, husbandman 0
4822206 2303026 2303026 defendant Boteler Thomas husbandman 599293 599293 Boteler, Thomas, of Sundon, husbandman 0
4848979 2311146 2311146 defendant Berne Edward husbandman 599293 599293 Berne, Edward, of Sundon, husbandman 0
4876388 2319576 2319576 defendant Smyth John husbandman 599293 599293 Smyth, John, of Sundon, husbandman 1
4876389 2319576 2319576 defendant Bailly Henry husbandman 599293 599293 Bailly, Henry, of Sundon, husbandman 2
4876390 2319576 2319576 defendant Souter William husbandman 599293 599293 Souter, William, of Sundon, husbandman 3
4876391 2319576 2319576 defendant Piers William husbandman 599293 599293 Piers, William, of Sundon, husbandman 4
4876393 2319577 2319577 defendant Berne Edward husbandman 599293 599293 Berne, Edward, of Sundon, husbandman 0
4876394 2319577 2319577 defendant Smyth John husbandman 599293 599293 Smyth, John, of Sundon, husbandman 1
4876395 2319577 2319577 defendant Bailly Henry husbandman 599293 599293 Bailly, Henry, of Sundon, husbandman 2
4876396 2319577 2319577 defendant Souter William husbandman 599293 599293 Souter, William, of Sundon, husbandman 3
4876397 2319577 2319577 defendant Piers William husbandman 599293 599293 Piers, William, of Sundon, husbandman 4
4907677 2328968 2328968 defendant Colshull Richard husbandman 599293 599293 Colshull, Richard, of Sundon, husbandman 2
4948108 2341381 2341381 defendant atte Wode alias Sowetere Andrew husbandman 599293 599293 atte Wode alias Sowetere, Andrew, of Sundon, husbandman 0
4976465 2349924 2349924 defendant Parker John parker 599293 599293 Parker, John, of Sundon, parker 0
5171697 2407442 2407442 defendant Buntyng John clerk 599293 599293 Buntyng, John, of Sundon, clerk 0
5231281 2424747 2424747 defendant Berne John yeoman 599293 599293 Berne, John, of Sundon, yeoman 4
5271518 2436764 2436764 defendant Bern John husbandman 599293 599293 Bern, John, of Sundon, husbandman 0
5279622 2439119 2439119 defendant Karver John husbandman 599293 599293 Karver, John, of Sundon, husbandman 0
5279623 2439119 2439119 defendant Hall Thomas husbandman 599293 599293 Hall, Thomas, of Sundon, husbandman 1
5279624 2439119 2439119 defendant Hardyng John husbandman 599293 599293 Hardyng, John, of Sundon, husbandman 2
5279625 2439119 2439119 defendant Hall John husbandman 599293 599293 Hall, John, of Sundon, husbandman 3
5360740 2463390 2463390 defendant Bern Edmund husbandman 599293 599293 Bern, Edmund, of Sundon, husbandman 3
5360741 2463390 2463390 defendant Souter William husbandman 599293 599293 Souter, William, of Sundon, husbandman 4
5537752 2516294 2516294 defendant Canere or Cavere John husbandman 599293 599293 Canere or Cavere, John, of Sundon, husbandman 1
5545281 2518620 2518620 defendant Carver John husbandman 599293 599293 Carver, John, of Sundon, husbandman 0
5604115 2536148 2536148 defendant Weroll Richard husbandman 599293 599293 Weroll, Richard, of Sundon, husbandman 2
5604116 2536148 2536148 defendant Barne Robert husbandman 599293 599293 Barne, Robert, of Sundon, husbandman 3
5634498 2554789 2554789 defendant Bawedewyn John ploughman 599293 599293 Bawedewyn, John, of Sundon, ploughman 3

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