names

29 rows where place_id = 676236

✎ 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
4005813 2026853 2026853 defendant Rolt Richard   676236 676236 Rolt, Richard, of Earls Colne, Essex, pale maker 0
4021988 2032592 2032592 defendant Ennewes or Gunewes Richard yeoman 676236 676236 Ennewes or Gunewes, Richard, of Earls Colne, Essex, yeoman 0
4304367 2131664 2131664 defendant German Agnes widow 676236 676236 German, Agnes, of Earls Colne, Essex, widow 3
4346603 2146065 2146065 defendant Pertriche Robert gent 676236 676236 Pertriche, Robert, of Earls Colne, Essex, gent 0
4346633 2146076 2146076 defendant Ward Richard yeoman 676236 676236 Ward, Richard, of Earls Colne, Essex, yeoman 1
4350339 2147379 2147379 defendant Partrich Robert gent 676236 676236 Partrich, Robert, of Earls Colne, Essex, gent 0
4357888 2150000 2150000 defendant Partrych Robert gent 676236 676236 Partrych, Robert, of Earls Colne, Essex, gent 3
4369212 2154053 2154053 defendant Partridge Robert gent 676236 676236 Partridge, Robert, of Earls Colne, Essex, gent 0
4522244 2207302 2207302 defendant Holbrook Thomas   676236 676236 Holbrook, Thomas, of Earls Colne, Essex 0
4670181 2256377 2256377 defendant Austyn Peter yeoman 676236 676236 Austyn, Peter, of Earls Colne, Essex, yeoman 3
4689873 2262389 2262389 defendant Falbergh Henry gent 676236 676236 Falbergh, Henry, of Earls Colne, Essex, gent 0
4805732 2298002 2298002 defendant Payn John gent 676236 676236 Payn, John, of Earls Colne, Essex, gent 1
4809229 2299060 2299060 defendant Bray John yeoman 676236 676236 Bray, John, of Earls Colne , Essex, yeoman 1
4841353 2308832 2308832 defendant Tyler Firman   676236 676236 Tyler, Firman, of Earls Colne, Essex, pedlar 0
4841359 2308833 2308833 defendant Tyler Firman   676236 676236 Tyler, Firman, of Earls Colne, Essex, pedlar 0
4858622 2314069 2314069 defendant Skynnere Richard husbandman 676236 676236 Skynnere, Richard, of Earls Colne, Essex, husbandman 1
4865576 2316198 2316198 defendant Goldyng Edmund chapman 676236 676236 Goldyng, Edmund, of Earls Colne, Essex, chapman 0
4881233 2321036 2321036 defendant Goldyng Edmund husbandman 676236 676236 Goldyng, Edmund, of Earls Colne, Essex, husbandman 0
4885609 2322376 2322376 defendant Boteler John chapman 676236 676236 Boteler, John, of Earls Colne, Essex, chapman 2
4889182 2323403 2323403 defendant Skynner Richard husbandman 676236 676236 Skynner, Richard, of Earls Colne, Essex, husbandman 1
4890653 2323833 2323833 defendant Skynner Richard husbandman 676236 676236 Skynner, Richard, of Earls Colne, Essex, husbandman 1
4897148 2325766 2325766 defendant Skynner Richard husbandman 676236 676236 Skynner, Richard, of Earls Colne, Essex, husbandman 1
4906193 2328529 2328529 defendant Skynner Richard husbandman 676236 676236 Skynner, Richard, of Earls Colne, Essex, husbandman 1
4942790 2339716 2339716 defendant Gardyner William weaver 676236 676236 Gardyner, William, of Earls Colne, Essex, weaver 0
4993791 2355012 2355012 defendant Crewyn William yeoman 676236 676236 Crewyn, William, of Earls Colne, Essex, yeoman 1
5008706 2359438 2359438 defendant Mylne John gent 676236 676236 Mylne, John, of Earls Colne, Essex, gent 4
5356863 2462206 2462206 defendant Kebyll John fuller 676236 676236 Kebyll, John, of Earls Colne, Essex, fuller 0
5400379 2475182 2475182 defendant Woderove Hugh yeoman 676236 676236 Woderove, Hugh, of Earls Colne, Essex, yeoman 0
5428493 2483448 2483448 defendant Woderofe Hugh yeoman 676236 676236 Woderofe, Hugh, of Earls Colne, Essex, 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);