names

37 rows where place_id = 644357

✎ 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
3879165 1983285 1983285 defendant Smyth Richard husbandman 644357 644357 Smyth, Richard, of Lemyng, husbandman 0
3896989 1989210 1989210 defendant Bracan Richard smith 644357 644357 Bracan, Richard, of Lemyng, smith 2
4214710 2100650 2100650 defendant Firbanck Christopher yeoman 644357 644357 Firbanck, Christopher, of Lemyng, yeoman 0
4220347 2102622 2102622 defendant Firbanck Christopher yeoman 644357 644357 Firbanck, Christopher, of Lemyng, yeoman 0
4420940 2171445 2171445 defendant Legge Joan   644357 644357 Legge, Joan, of Lemyng 0
4500218 2200697 2200697 defendant Belford John   644357 644357 Belford, John, of Lemyng 3
4528811 2209294 2209294 defendant Welford William   644357 644357 Welford, William, of Lemyng 0
4560376 2219183 2219183 defendant Rotour Robert   644357 644357 Rotour, Robert, of Lemyng 2
4588321 2227739 2227739 defendant Belford William   644357 644357 Belford, William, of Lemyng 0
4618546 2236809 2236809 defendant Belford William   644357 644357 Belford, William, of Lemyng 0
4628587 2239865 2239865 defendant Thommesson William   644357 644357 Thommesson, William, of Lemyng 0
4641830 2243712 2243712 defendant Barthilmewe Robert   644357 644357 Barthilmewe, Robert, of Lemyng 0
4645458 2244740 2244740 defendant Belford William   644357 644357 Belford, William, of Lemyng 0
4646626 2245075 2245075 defendant Bedale Robert   644357 644357 Bedale, Robert, of Lemyng 0
4664685 2250433 2250433 defendant Belford William   644357 644357 Belford, William, of Lemyng 0
4668641 2255905 2255905 plaintiff Belford William   644357 644357 Belford, William, of Lemyng 0
4668646 2255906 2255906 plaintiff Belford William   644357 644357 Belford, William, of Lemyng 0
4694805 2263868 2263868 defendant Burgh John yeoman 644357 644357 Burgh, John, of Lemyng, yeoman 1
4717694 2270868 2270868 defendant Broune John smith 644357 644357 Broune, John, of Lemyng, smith 0
4719021 2271296 2271296 plaintiff Belford William   644357 644357 Belford, William, of Lemyng 0
4719474 2271435 2271435 defendant Bedale Robert butcher 644357 644357 Bedale, Robert, of Lemyng, butcher 0
4725083 2273141 2273141 defendant Belford William gent 644357 644357 Belford, William, of Lemyng, gent 0
4728523 2274159 2274159 defendant Bedale Robert husbandman 644357 644357 Bedale, Robert, of Lemyng, husbandman 0
4740856 2277839 2277839 plaintiff Belford William   644357 644357 Belford, William, of Lemyng 0
4740858 2277840 2277840 plaintiff Belforth William gent 644357 644357 Belforth, William, of Lemyng, gent 0
4741267 2277943 2277943 defendant Bedale Robert butcher 644357 644357 Bedale, Robert, of Lemyng, butcher 1
4754942 2281927 2281927 plaintiff Belford William   644357 644357 Belford, William, of Lemyng 1
4756302 2282340 2282340 plaintiff Bedford William   644357 644357 Bedford, William, of Lemyng 0
4776537 2288655 2288655 plaintiff Belford William   644357 644357 Belford, William, of Lemyng 1
4802403 2296943 2296943 defendant Walker John gent 644357 644357 Walker, John, of Lemyng, gent 0
4834070 2306663 2306663 defendant Robynson John yeoman 644357 644357 Robynson, John, of Lemyng, yeoman 0
4868967 2317267 2317267 defendant Bedale Robert yeoman 644357 644357 Bedale, Robert, of Lemyng, yeoman 0
4909873 2329612 2329612 defendant Wykham John   644357 644357 Wykham, John, of Lemyng, holy water clerk 0
4909875 2329612 2329612 defendant Webster Thomas husbandman 644357 644357 Webster, Thomas, of Lemyng, husbandman 2
4991671 2354392 2354392 defendant Belford Thomas gent 644357 644357 Belford, Thomas, of Lemyng, gent 1
5019200 2362505 2362505 defendant Taillour John yeoman 644357 644357 Taillour, John, of Lemyng, yeoman 0
5632030 2554042 2554042 defendant Smyth Robert smith 644357 644357 Smyth, Robert, of Lemyng, smith 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);