names

30 rows where place_id = 607845

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3671020 1916907 1916907 defendant Fygge Arthur merchant of the staple 607845 607845 Fygge, Arthur, of Segbroke, merchant of the staple 1
3671026 1916908 1916908 defendant Fygge Arthur merchant of the staple 607845 607845 Fygge, Arthur, of Segbroke, merchant of the staple 1
3671032 1916909 1916909 defendant Figg Arthur merchant of the staple 607845 607845 Figg, Arthur, of Segbroke, merchant of the staple 1
3671038 1916910 1916910 defendant Figg Arthur merchant of the staple 607845 607845 Figg, Arthur, of Segbroke, merchant of the staple 1
3671044 1916911 1916911 defendant Figg Arthur merchant of the staple 607845 607845 Figg, Arthur, of Segbroke, merchant of the staple 1
3671050 1916912 1916912 defendant Figge Arthur merchant of the staple 607845 607845 Figge, Arthur, of Segbroke, merchant of the staple 1
3711525 1929915 1929915 defendant Arnall Walter laborer 607845 607845 Arnall, Walter, of Segbroke, laborer 0
4494434 2198956 2198956 defendant Aweler William   607845 607845 Aweler, William, of Segbroke 3
4508345 2203096 2203096 defendant parker John   607845 607845 parker, John, of Segbroke 1
4663717 2250135 2250135 defendant Milford John butcher 607845 607845 Milford, John, of Segbroke, butcher 0
4664259 2250304 2250304 defendant Parker Robert, junior courser 607845 607845 Parker, Robert, junior, of Segbroke, courser 0
4664260 2250304 2250304 defendant Blithe William courser 607845 607845 Blithe, William, of Segbroke, courser 1
4664262 2250304 2250304 defendant Milford John butcher 607845 607845 Milford, John, of Segbroke, butcher 3
4664263 2250304 2250304 defendant Widale John butcher 607845 607845 Widale, John, of Segbroke, butcher 4
4726565 2273584 2273584 defendant Whytales John husbandman 607845 607845 Whytales, John, of Segbroke, husbandman 4
4726566 2273584 2273584 defendant Milford John husbandman 607845 607845 Milford, John, of Segbroke, husbandman 5
4744459 2278900 2278900 defendant Blyth William husbandman 607845 607845 Blyth, William, of Segbroke, husbandman 2
4773419 2287660 2287660 defendant Sturdy John yeoman 607845 607845 Sturdy, John, of Segbroke, yeoman 0
4818122 2301743 2301743 defendant Parker John husbandman 607845 607845 Parker, John, of Segbroke, husbandman 1
4845308 2310044 2310044 defendant Parker Robert husbandman 607845 607845 Parker, Robert, of Segbroke, husbandman 0
5014756 2361187 2361187 defendant Smyth John husbandman 607845 607845 Smyth, John, of Segbroke, husbandman 1
5151431 2401569 2401569 defendant Holbek Nicholas husbandman 607845 607845 Holbek, Nicholas, of Segbroke, husbandman 0
5151432 2401569 2401569 defendant Broun Robert husbandman 607845 607845 Broun, Robert, of Segbroke, husbandman 1
5224311 2422785 2422785 plaintiff Porter William   607845 607845 Porter, William, of Segbroke 0
5297446 2444256 2444256 plaintiff (illegible) William, sen (legal representative) 607845 607845 _, William, sen, of Segbroke, executors of 0
5432817 2484783 2484783 plaintiff Palmer Thomas clerk & parson 607845 607845 Palmer, Thomas, of Segbroke, clerk & parson 2
5472616 2496778 2496778 plaintiff Palmer Thomas   607845 607845 Palmer, Thomas, of Segbroke, parson 2
5551989 2520622 2520622 defendant Markeham John (legal representative) 607845 607845 Markeham, John, of Segbroke, esq, executrix of 0
5551990 2520622 2520622 defendant FitzRychard Simon gent 607845 607845 (FitzRychard, Simon, of Segbroke, gent 1
5553915 2521185 2521185 defendant Pypar William yeoman 607845 607845 Pypar, William, of Segbroke, yeoman 0

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