names

45 rows where place_id = 754916

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4424044 2172373 2172373 defendant Spynkard John   754916 754916 Spynkard, John, of Great Walsyngham 1
4495322 2199214 2199214 defendant Mason Henry   754916 754916 Mason, Henry, of Great Walsyngham 0
4527057 2208742 2208742 defendant Wryghte Richard   754916 754916 Wryghte, Richard, of Great Walsyngham 0
4570527 2222356 2222356 plaintiff Wryght Richard   754916 754916 Wryght, Richard, of Great Walsyngham 0
4572820 2223037 2223037 defendant Kempe John   754916 754916 Kempe, John, of Great Walsyngham 1
4573836 2223335 2223335 defendant Smyth John   754916 754916 Smyth, John, of Great Walsyngham 0
4602453 2231988 2231988 defendant Halle Adam   754916 754916 Halle, Adam, of Great Walsyngham 2
4606554 2233162 2233162 defendant Leeng Stephen (legal representative) 754916 754916 Leeng, Stephen, of Great Walsyngham, executors of 0
4609828 2234166 2234166 defendant Wrighte Richard   754916 754916 Wrighte, Richard, of Great Walsyngham 2
4621927 2237838 2237838 plaintiff Lenge Stephen (legal representative) 754916 754916 Lenge, Stephen, of Great Walsyngham, executors of 0
4621931 2237839 2237839 plaintiff Lenge Stephen (legal representative) 754916 754916 Lenge, Stephen, of Great Walsyngham, executors of 0
4636966 2242369 2242369 defendant Aleyn John, sen   754916 754916 Aleyn, John, sen, of Great Walsyngham 2
4666733 2255324 2255324 defendant Waryn Adam husbandman 754916 754916 Waryn, Adam, of Great Walsyngham, husbandman 0
4673956 2257471 2257471 defendant Halle Adam butcher 754916 754916 Halle, Adam, of Great Walsyngham, butcher 2
4673957 2257471 2257471 defendant Kempe John butcher 754916 754916 Kempe, John, of Great Walsyngham, butcher 3
4685291 2260995 2260995 defendant Kempe Edmund husbandman 754916 754916 Kempe, Edmund, of Great Walsyngham, husbandman 2
4685292 2260995 2260995 defendant Kempe John husbandman 754916 754916 Kempe, John, of Great Walsyngham, husbandman 3
4702536 2266206 2266206 defendant Kempe Edmund butcher 754916 754916 Kempe, Edmund, of Great Walsyngham, butcher 0
4730145 2274629 2274629 defendant Lynge John butcher 754916 754916 Lynge, John, of Great Walsyngham, butcher 2
4736552 2276564 2276564 defendant Palmere Thomas yeoman 754916 754916 Palmere, Thomas, of Great Walsyngham, yeoman 0
4804973 2297761 2297761 plaintiff Mabbes Richard tanner 754916 754916 Mabbes, Richard, of Great Walsyngham, tanner 1
4807201 2298454 2298454 defendant Gery John butcher 754916 754916 Gery, John, of Great Walsyngham, butcher 2
4807202 2298454 2298454 defendant Halle Adam butcher 754916 754916 Halle, Adam, of Great Walsyngham, butcher 3
4816898 2301388 2301388 defendant Kemp Richard husbandman 754916 754916 Kemp, Richard, of Great Walsyngham, husbandman 3
4833933 2306621 2306621 defendant Kempe Richard yeoman 754916 754916 Kempe, Richard, of Great Walsyngham, yeoman 0
4852379 2312165 2312165 defendant Palmer Thomas husbandman 754916 754916 Palmer, Thomas, of Great Walsyngham, husbandman 0
4852383 2312166 2312166 defendant Palmer Thomas husbandman 754916 754916 Palmer, Thomas, of Great Walsyngham, husbandman 0
4910332 2329750 2329750 plaintiff Blogge Robert tanner 754916 754916 Blogge, Robert, of Great Walsyngham, tanner 0
4910337 2329751 2329751 plaintiff Blogge Robert   754916 754916 Blogge, Robert, of Great Walsyngham 0
4910338 2329751 2329751 plaintiff Deen Nicholas   754916 754916 Deen, Nicholas, of Great Walsyngham 1
4912446 2330398 2330398 defendant Fouler Nichola husbandman 754916 754916 Fouler, Nichola, of Great Walsyngham, husbandman 1
4930628 2335986 2335986 defendant Blog Robert tanner 754916 754916 Blog, Robert, of Great Walsyngham, tanner 0
4930629 2335986 2335986 defendant Mabbys Richard tanner 754916 754916 Mabbys, Richard, of Great Walsyngham, tanner 1
4999056 2356596 2356596 defendant Palmer Thomas yeoman 754916 754916 Palmer, Thomas, of Great Walsyngham, yeoman 0
5039536 2368474 2368474 plaintiff Blog Robert tanner 754916 754916 Blog, Robert, of Great Walsyngham, tanner 0
5039537 2368474 2368474 plaintiff Kemp Richard yeoman 754916 754916 Kemp, Richard, of Great Walsyngham, yeoman 1
5039539 2368475 2368475 plaintiff Blogg Robert   754916 754916 Blogg, Robert, of Great Walsyngham 0
5125626 2393985 2393985 defendant Andrewes Simon yeoman 754916 754916 Andrewes, Simon, of Great Walsyngham, yeoman 1
5205042 2417229 2417229 defendant Wright William husbandman 754916 754916 Wright, William, of Great Walsyngham, husbandman 0
5206346 2417592 2417592 defendant Hales John husbandman 754916 754916 Hales, John, of Great Walsyngham, husbandman 0
5270196 2436382 2436382 defendant Pykto Alan husbandman 754916 754916 Pykto, Alan, of Great Walsyngham, husbandman 10
5272396 2436995 2436995 defendant Perott Robert yeoman 754916 754916 Perott, Robert, of Great Walsyngham, yeoman 0
5273142 2437216 2437216 defendant Byrd Margaret widow 754916 754916 Byrd, Margaret, of Great Walsyngham, widow 1
5276762 2438286 2438286 defendant Den Robert gent & bachelor of Civil Law 754916 754916 Den, Robert, of Great Walsyngham, gent & bachelor of Civil Law 3
5297879 2444386 2444386 defendant Pykto Alan husbandman 754916 754916 Pykto, Alan, of Great Walsyngham, husbandman 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);