names

49 rows where place_id = 587452

✎ 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
3591449 1864952 1864952 defendant Stokys Thomas husbandman 587452 587452 Stokys, Thomas, of Ouresby, husbandman 0
4514599 2204984 2204984 defendant Wrygyt Adam   587452 587452 Wrygyt, Adam, of Ouresby 3
4552144 2216620 2216620 defendant Ouresby John   587452 587452 Ouresby, John, of Ouresby 0
4555104 2217528 2217528 defendant Smyth John   587452 587452 Smyth, John, of Ouresby 0
4567897 2221533 2221533 defendant Gednay John   587452 587452 Gednay, John, of Ouresby 0
4567899 2221533 2221533 defendant Botour Robert   587452 587452 Botour, Robert, of Ouresby 2
4567900 2221533 2221533 defendant Manger Hugh   587452 587452 Manger, Hugh, of Ouresby 3
4616785 2236250 2236250 defendant Disney Robert   587452 587452 together with Disney, Robert, of Ouresby 1
4682844 2260249 2260249 defendant Chaumbre William husbandman 587452 587452 Chaumbre, William, of Ouresby, husbandman 1
4788168 2292370 2292370 defendant Assheton Robert yeoman 587452 587452 Assheton, Robert, of Ouresby, yeoman 0
4826714 2304389 2304389 defendant Hansard Robert esq 587452 587452 Hansard, Robert, of Ouresby, esq 1
4850629 2311656 2311656 defendant Smyth John smith 587452 587452 Smyth, John, of Ouresby, smith 2
4942307 2339584 2339584 defendant atte Hall John husbandman 587452 587452 atte Hall, John, of Ouresby, husbandman 4
4957842 2344317 2344317 defendant Broun John tailor 587452 587452 Broun, John, of Ouresby, tailor 0
4966332 2346864 2346864 defendant Haunsard Robert gent 587452 587452 Haunsard, Robert, of Ouresby, gent 0
4972517 2348711 2348711 defendant Broxham Robert husbandman 587452 587452 Broxham, Robert, of Ouresby, husbandman 2
4972518 2348711 2348711 defendant Wykham Richard husbandman 587452 587452 Wykham, Richard, of Ouresby, husbandman 3
4992806 2354730 2354730 defendant Haunsar Robert gent 587452 587452 Haunsar, Robert, of Ouresby, gent 0
5028676 2365262 2365262 defendant Broxholm Robert husbandman 587452 587452 Broxholm, Robert, of Ouresby, husbandman 4
5090880 2383725 2383725 defendant Haunsert John gent 587452 587452 Haunsert, John, of Ouresby, gent 0
5090881 2383725 2383725 defendant Haunsert Joan widow 587452 587452 Haunsert, Joan, of Ouresby, widow 1
5111032 2389620 2389620 plaintiff Haunsert Richard   587452 587452 Haunsert, Richard, of Ouresby, son of Haunsaart, Robert, of Owresby 0
5132435 2395983 2395983 plaintiff Haunsert Richard   587452 587452 Haunsert, Richard, of Ouresby 0
5132440 2395983 2395983 defendant Standygrounde John husbandman 587452 587452 Standygrounde, John, of Ouresby, husbandman 4
5187421 2412046 2412046 plaintiff Haunsart Richard   587452 587452 Haunsart, Richard, of Ouresby 0
5187436 2412048 2412048 defendant Danet John husbandman 587452 587452 Danet, John, of Ouresby, husbandman 3
5187440 2412049 2412049 plaintiff Haunsert Richard   587452 587452 Haunsert, Richard, of Ouresby 0
5205483 2417355 2417355 plaintiff Hamsert Richard   587452 587452 Hamsert, Richard, of Ouresby 0
5205585 2417380 2417380 plaintiff Haunsart Richard   587452 587452 Haunsart, Richard, of Ouresby 0
5238988 2426994 2426994 plaintiff Haunsert Richard   587452 587452 Haunsert, Richard, of Ouresby 0
5249602 2430000 2430000 defendant Danson John clerk 587452 587452 Danson, John, of Ouresby, clerk 0
5258883 2432895 2432895 plaintiff Haunsert Richard   587452 587452 Haunsert, Richard, of Ouresby 0
5269507 2436184 2436184 defendant Catour John husbandman 587452 587452 Catour, John, of Ouresby, husbandman 1
5269509 2436184 2436184 defendant Daweson John   587452 587452 Daweson, John, of Ouresby, vicar & chaplain 3
5285706 2440847 2440847 defendant Danot or Davot John husbandman 587452 587452 Danot or Davot, John, of Ouresby, husbandman 1
5403476 2476065 2476065 defendant Robynson William husbandman 587452 587452 Robynson, William, of Ouresby, husbandman 2
5416545 2479866 2479866 defendant Robynson William husbandman 587452 587452 Robynson, William, of Ouresby, husbandman 2
5416592 2479877 2479877 defendant Cok Nicholas laborer 587452 587452 Cok, Nicholas, of Ouresby, laborer 0
5433509 2484984 2484984 defendant Cok Nicholas laborer 587452 587452 Cok, Nicholas, of Ouresby, laborer 0
5433576 2485004 2485004 defendant Robynson William husbandman 587452 587452 Robynson, William, of Ouresby, husbandman 1
5456572 2491888 2491888 defendant Daweson John clerk 587452 587452 Daweson, John, of Ouresby, clerk 2
5459348 2492707 2492707 defendant Rayner Thomas   587452 587452 Rayner, Thomas, of Ouresby, shepherd 0
5471014 2496269 2496269 defendant Rayner Thomas   587452 587452 Rayner, Thomas, of Ouresby, shepherd 0
5495464 2503546 2503546 defendant Cokke John laborer 587452 587452 Cokke, John, of Ouresby, laborer 0
5495466 2503546 2503546 defendant Daulton Richard laborer 587452 587452 Daulton, Richard, of Ouresby, laborer 2
5495467 2503546 2503546 defendant Dene Stephen laborer 587452 587452 Dene, Stephen, of Ouresby, laborer 3
5495468 2503546 2503546 defendant Peche William husbandman 587452 587452 Peche, William, of Ouresby, husbandman 4
5612201 2547554 2547554 defendant Higdon Robert   587452 587452 Higdon, Robert, of Ouresby 0
5616039 2548811 2548811 defendant (not given)   prior of John, formerly servant of the prior of Royston 587452 587452 John, formerly servant of the prior of Royston, of Ouresby 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);