names

25 rows where place_id = 668462

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3989228 2020887 2020887 defendant Boswell or Bosworth Anthony yeoman 668462 668462 Boswell or Bosworth, Anthony, of Combe, Hants, yeoman 0
4065608 2047990 2047990 defendant Bosewell Anthony yeoman 668462 668462 Bosewell, Anthony, of Combe, Hants, yeoman 0
4792097 2293628 2293628 defendant Adam William husbandman 668462 668462 Adam, William, of Combe, Hants, husbandman 1
4826890 2304448 2304448 defendant Bagmere William yeoman 668462 668462 Bagmere, William, of Combe, Hants, yeoman 0
4835733 2307174 2307174 plaintiff Adam John   668462 668462 Adam, John, of Combe, Hants 1
4881029 2320978 2320978 defendant Bagmere William husbandman 668462 668462 Bagmere, William, of Combe, Hants, husbandman 1
4923903 2333916 2333916 defendant Bagmere William husbndman 668462 668462 Bagmere, William, of Combe, Hants, husbndman 0
4932784 2336638 2336638 defendant Bagmere William husbandman 668462 668462 Bagmere, William, of Combe, Hants, husbandman 0
4949113 2341712 2341712 defendant Bagmere William husbandman 668462 668462 Bagmere, William, of Combe, Hants, husbandman 0
4956795 2343991 2343991 defendant Bagmer William husbandman 668462 668462 Bagmer, William, of Combe, Hants, husbandman 0
4975182 2349533 2349533 defendant Bagmer William husbandman 668462 668462 Bagmer, William, of Combe, Hants, husbandman 0
4978465 2350506 2350506 defendant Bagemer William husbandman 668462 668462 Bagemer, William, of Combe, Hants, husbandman 0
4985110 2352473 2352473 defendant Bagmere William husbandman 668462 668462 Bagmere, William, of Combe, Hants, husbandman 0
5049653 2371520 2371520 defendant Bagmore William husbandman 668462 668462 Bagmore, William, of Combe, Hants, husbandman 0
5057121 2373711 2373711 defendant Bagmere William yeoman 668462 668462 Bagmere, William, of Combe, Hants, yeoman 0
5075060 2379042 2379042 defendant Bagmer William yeoman 668462 668462 Bagmer, William, of Combe, Hants, yeoman 0
5114833 2390751 2390751 defendant Bagmere William yeoman 668462 668462 Bagmere, William, of Combe, Hants, yeoman 3
5114838 2390752 2390752 defendant Bagmere William yeoman 668462 668462 Bagmere, William,of Combe, Hants, yeoman 3
5129753 2395188 2395188 defendant Bagmere William husbandman 668462 668462 Bagmere, William, of Combe, Hants, husbandman 0
5200172 2415805 2415805 defendant Bagncere or Bagucere William husbandman 668462 668462 Bagncere or Bagucere, William, of Combe, Hants, husbandman 0
5214990 2420107 2420107 defendant Gyot John husbandman 668462 668462 Gyot, John, of Combe, Hants, husbandman 0
5292186 2442711 2442711 defendant Percy John clerk 668462 668462 Percy, John, of Combe, Hants, clerk 0
5292188 2442712 2442712 defendant Poy John clerk 668462 668462 Poy, John, of Combe, Hants, clerk 0
5292190 2442713 2442713 defendant Poy John clerk 668462 668462 Poy, John, of Combe, Hants, clerk 0
5354268 2461401 2461401 defendant North Richard husbandman 668462 668462 North, Richard, of Combe, Hants, husbandman 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);