names

25 rows where place_id = 771746

✎ 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
4581673 2225714 2225714 defendant Skynner Robert   771746 771746 Skynner, Robert, of West Malling 1
4585566 2226906 2226906 defendant Bedell John   771746 771746 Bedell, John, of West Malling 0
4641954 2243751 2243751 defendant Sprot William   771746 771746 Sprot, William, of West Malling 0
4646491 2245038 2245038 defendant Gerard John   771746 771746 Gerard, John, of West Malling 1
4648291 2245562 2245562 defendant Goos John, sen   771746 771746 Goos, John, sen, of West Malling 0
4698865 2265127 2265127 defendant Dyne Henry draper 771746 771746 Dyne, Henry, of West Malling, draper 0
4702563 2266214 2266214 defendant Mayhewe Henry husbandman 771746 771746 Mayhewe, Henry, of West Malling, husbandman 0
4715475 2270177 2270177 defendant Langle John fuller 771746 771746 Langle, John, of West Malling, fuller 2
4727893 2273967 2273967 plaintiff Hoo John   771746 771746 Hoo, John, of West Malling 0
4730123 2274622 2274622 defendant Grygge John butcher 771746 771746 Grygge, John, of West Malling, butcher 0
4734601 2275985 2275985 defendant Hoyton Roger husbandman 771746 771746 Hoyton, Roger, of West Malling, husbandman 0
4774687 2288072 2288072 defendant Chobham John   771746 771746 Chobham, John, of West Malling, shoe maker 0
4833622 2306522 2306522 defendant Maynward William yeoman 771746 771746 Maynward, William, of West Malling, yeoman 0
4847269 2310647 2310647 defendant Claygate John husbandman 771746 771746 Claygate, John, of West Malling, husbandman 0
4847270 2310647 2310647 defendant Carpenter Richard husbandman 771746 771746 Carpenter, Richard, of West Malling, husbandman 1
5092655 2384232 2384232 plaintiff Pellican William gent 771746 771746 Pellican, William, of West Malling, gent 0
5145713 2399889 2399889 defendant Crouchere John husbandman 771746 771746 Crouchere, John, of West Malling, husbandman 2
5166054 2405815 2405815 defendant Crouchere John husbandman 771746 771746 Crouchere, John, of West Malling, husbandman 2
5168799 2406605 2406605 defendant Crowechere (illegible) butcher 771746 771746 Crowechere, _, of West Malling, butcher 0
5168800 2406605 2406605 defendant Hexstaple John butcher 771746 771746 Hexstaple, John, of West Malling, butcher 1
5168801 2406605 2406605 defendant Bocher Robert laborer 771746 771746 Bocher, Robert, of West Malling, laborer 2
5168802 2406605 2406605 defendant Fyssher Richard husbandman 771746 771746 Fyssher, Richard, of West malling, husbandman 3
5378967 2469016 2469016 defendant Sewe-- Richard miller 771746 771746 Sewe--, Richard, of West Malling, miller 1
5473161 2496929 2496929 defendant Elyotte John husbandman 771746 771746 Elyotte, John, of West Malling, husbandman 0
5473162 2496929 2496929 defendant Dryver William carpenter 771746 771746 together with Dryver, William, of West Malling, carpenter 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);