names

24 rows where place_id = 644639

✎ 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
3880957 1983901 1983901 plaintiff Roche Richard gent 644639 644639 Roche, Richard, of Beseby, gent 0
4456878 2187161 2187161 defendant Chapman Walter   644639 644639 Chapman, Walter, of Beseby 0
4492084 2198214 2198214 defendant Beseby Simon   644639 644639 Beseby, Simon, of Beseby 0
4543431 2213835 2213835 plaintiff atte Halle Richard   644639 644639 atte Halle, Richard, of Beseby 0
4641450 2243597 2243597 plaintiff Franke William   644639 644639 Franke, William, of Beseby, knight 0
4682556 2260164 2260164 defendant Ulceby Walter husbandman 644639 644639 Ulceby, Walter, of Beseby, husbandman 0
4682557 2260164 2260164 defendant Chaumberlayn Thomas husbandman 644639 644639 Chaumberlayn, Thomas, of Beseby, husbandman 1
4715915 2270291 2270291 defendant Baldryke Richard husbandman 644639 644639 Baldryke, Richard, of Beseby, husbandman 0
4742698 2278374 2278374 defendant Ulsby Walter husbandman 644639 644639 Ulsby, Walter, of Beseby, husbandman 2
4742699 2278374 2278374 defendant Chamberleyn Thomas husbandman 644639 644639 Chamberleyn, Thomas, of Beseby, husbandman 3
4750688 2280689 2280689 defendant Chaumberleyn John yeoman 644639 644639 Chaumberleyn, John, of Beseby, yeoman 2
4967346 2347174 2347174 defendant Genteles Robert husbandman 644639 644639 Genteles, Robert, of Beseby, husbandman 14
4967804 2347314 2347314 defendant Geneyll or Geveyll Robert husbandman 644639 644639 Geneyll or Geveyll, Robert, of Beseby, husbandman 1
4983490 2351976 2351976 defendant Gentill Robert husbandman 644639 644639 Gentill, Robert, of Beseby, husbandman 1
5020827 2362987 2362987 defendant Gentyls Robert husbandman 644639 644639 Gentyls, Robert, of Beseby, husbandman 3
5026232 2364564 2364564 defendant Lucas Robert husbandman 644639 644639 Lucas, Robert, of Beseby, husbandman 1
5115750 2391036 2391036 defendant Grason Robert husbandman 644639 644639 Grason, Robert, of Beseby, husbandman 0
5115751 2391036 2391036 defendant Saper Richard husbandman 644639 644639 Saper, Richard, of Beseby, husbandman 1
5255025 2431688 2431688 defendant Roche Robert gent 644639 644639 Roche, Robert, of Beseby, gent 0
5321444 2451506 2451506 defendant Traves Robert (legal representative) 644639 644639 Traves, Robert, of Beseby, husbandman, executors of 5
5503405 2505973 2505973 defendant Raynes Peter yeoman 644639 644639 Raynes, Peter, of Beseby, yeoman 4
5503406 2505973 2505973 defendant Michell John husbandman 644639 644639 Michell, John, of Beseby, husbandman 5
5520474 2511222 2511222 defendant Steward John husbandman 644639 644639 Steward, John, of Beseby, husbandman 0
5577660 2528081 2528081 defendant Carter William yeoman 644639 644639 Carter, William, of Beseby, yeoman 1

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