names

47 rows where place_id = 619293

✎ 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
3729142 1935364 1935364 defendant Mares John husbandman 619293 619293 Mares, John, of South Kelsey, husbandman 0
3733241 1936630 1936630 defendant Rak Thomas laborer 619293 619293 Rak, Thomas, of South Kelsey, laborer 1
3734590 1937064 1937064 defendant Rak Thomas laborer 619293 619293 Rak, Thomas, of South Kelsey, laborer 1
3746858 1940936 1940936 defendant Mounton William chaplain 619293 619293 Mounton, William, of South Kelsey, chaplain 1
3748726 1941532 1941532 defendant Selby William laborer 619293 619293 Selby, William, of South Kelsey, laborer 1
3903651 1991453 1991453 defendant Mursit or Murfit Thomas laborer 619293 619293 Mursit or Murfit, Thomas, of South Kelsey, laborer 0
3906437 1992446 1992446 defendant Murssyt Edith widow 619293 619293 Murssyt, Edith, of South Kelsey, widow 0
3906439 1992446 1992446 defendant Blythe William husbandman 619293 619293 Blythe, William, of South Kelsey, husbandman 2
4168309 2084398 2084398 defendant Ascoughe William esq 619293 619293 Ascoughe, William, of South Kelsey, or of Stallingbrought, esq 0
4214432 2100555 2100555 defendant Smyth Edward   619293 619293 Smyth, Edward, of South Kelsey 0
4232075 2106719 2106719 defendant Smyth Edward laborer 619293 619293 Smyth, Edward, of South Kelsey, laborer 0
4337724 2142941 2142941 defendant Vessey John husbandman 619293 619293 Vessey, John, of South Kelsey, husbandman 0
4355980 2149309 2149309 defendant Brocklesbie John yeoman 619293 619293 Brocklesbie, John, of South Kelsey, yeoman 0
4355982 2149310 2149310 defendant Brockesbie John yeoman 619293 619293 Brockesbie, John, of South Kelsey, yeoman 0
4371868 2155000 2155000 defendant Hides John cordwainer 619293 619293 Hides, John, of South Kelsey, cordwainer 0
4459895 2188149 2188149 plaintiff Scarle William   619293 619293 Scarle, William, of South Kelsey, parson, on his own account 0
4482032 2195091 2195091 plaintiff Marshall John weaver 619293 619293 Marshall, John, of South Kelsey, weaver 0
4482034 2195091 2195091 defendant Maunsell Richard   619293 619293 Maunsell, Richard, of South Kelsey 0
4500867 2200891 2200891 defendant Marschall John   619293 619293 Marschall, John, of South Kelsey 3
4877515 2319924 2319924 plaintiff Stefyng John   619293 619293 Stefyng, John, of South Kelsey 0
4887964 2323042 2323042 defendant Ingram John husbandman 619293 619293 Ingram, John, of South Kelsey, husbandman 0
4922680 2333505 2333505 defendant Norys Willam husbandman 619293 619293 Norys, Willam, of South Kelsey, husbandman 0
4924261 2334028 2334028 defendant Haunsard Richard, senior esq 619293 619293 Haunsard, Richard, senior, of South Kelsey, esq 0
4924262 2334028 2334028 defendant Haunsard Richard, junior gent 619293 619293 Haunsard, Richard, junior, of South Kelsey, gent 1
4924263 2334028 2334028 defendant Welton William yeoman 619293 619293 Welton, William, of South Kelsey, yeoman 2
4924264 2334028 2334028 defendant Brades William yeoman 619293 619293 Brades, William, of South Kelsey, yeoman 3
4924265 2334028 2334028 defendant Humberston Thomas   619293 619293 Humberston, Thomas, of South Kelsey, servant 4
4960131 2344998 2344998 defendant Haunsard Richard esq 619293 619293 Haunsard, Richard, of South Kelsey, esq 0
5028670 2365261 2365261 defendant Mason John laborer 619293 619293 Mason, John, of South Kelsey, laborer 4
5104861 2387858 2387858 defendant Wykeham John husbandman 619293 619293 Wykeham, John, of South Kelsey, husbandman 0
5132227 2395922 2395922 defendant Kyng Richard husbandman 619293 619293 Kyng, Richard, of South Kelsey, husbandman 0
5148465 2400679 2400679 plaintiff Wyld Peter   619293 619293 Wyld, Peter, of South Kelsey 3
5167746 2406281 2406281 plaintiff Wyld Peter   619293 619293 Wyld, Peter, of South Kelsey 3
5170084 2406982 2406982 defendant Kyng Richard husbandman 619293 619293 Kyng, Richard, of South Kelsey, husbandman 0
5183341 2410868 2410868 plaintiff Wyld Peter   619293 619293 Wyld, Peter, of South Kelsey 3
5187433 2412048 2412048 defendant Waynman Thomas husbandman 619293 619293 Waynman, Thomas, of South Kelsey, husbandman 0
5187434 2412048 2412048 defendant Mereman Thomas laborer 619293 619293 Mereman, Thomas, of South Kelsey, laborer 1
5269508 2436184 2436184 defendant RoughHatte Thomas butcher 619293 619293 RoughHatte, Thomas, of South Kelsey, butcher 2
5287705 2441428 2441428 defendant Monson John merchant 619293 619293 Monson, John, of South Kelsey, merchant 1
5297921 2444400 2444400 defendant Chapman William chaplain 619293 619293 Chapman, William, of South Kelsey, chaplain 0
5297923 2444401 2444401 defendant Chapman William chaplain 619293 619293 Chapman, William, of South Kelsey, chaplain 0
5402401 2475759 2475759 defendant Wryght John husbandman 619293 619293 Wryght, John, of South Kelsey, husbandman 0
5415317 2479519 2479519 defendant Wright John husbandman 619293 619293 Wright, John, of South Kelsey, husbandman 0
5415338 2479523 2479523 defendant Wright John husbandman 619293 619293 Wright, John, of South Kelsey, husbandman 0
5447946 2489269 2489269 defendant Wright John husbandman 619293 619293 Wright, John, of South Kelsey, husbandman 0
5539371 2516800 2516800 defendant Monson alias Dymmok John gent 619293 619293 Monson alias Dymmok, John, of South Kelsey, gent 0
5633483 2554470 2554470 defendant Clerk Richard clerk 619293 619293 Clerk, Richard, of South Kelsey, clerk 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);