names

68 rows where place_id = 661028

✎ 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
3958827 2010167 2010167 defendant Cokkyng Hansel husbandman 661028 661028 Cokkyng, Hansel, of Mumby, husbandman 1
3999913 2024738 2024738 defendant More Edward yeoman 661028 661028 More, Edward, of Mumby, yeoman 1
4022722 2032849 2032849 defendant Cragg John husbandman 661028 661028 Cragg, John, of Mumby, husbandman 0
4043363 2040092 2040092 defendant Chubb William yeoman 661028 661028 Chubb, William, of Mumby, yeoman 0
4053963 2043795 2043795 plaintiff Atkynston Richard   661028 661028 Atkynston, Richard, of Mumby 0
4053964 2043795 2043795 defendant Raynold Richard weaver 661028 661028 Raynold, Richard, of Mumby, weaver 0
4068088 2048892 2048892 defendant Barkworthe John husbandman 661028 661028 Barkworthe, John, of Mumby, husbandman 0
4074454 2051167 2051167 plaintiff Ransley Thomas miller 661028 661028 Ransley, Thomas, of Mumby, miller 0
4239179 2109329 2109329 defendant Lowes John yeoman 661028 661028 Lowes, John, of Mumby, yeoman 0
4247577 2112175 2112175 defendant Lowes John yeoman 661028 661028 Lowes, John, of Mumby, yeoman 0
4413015 2168945 2168945 plaintiff Arnehewe Thomas de   661028 661028 Arnehewe, Thomas de, of Mumby 0
4563528 2220167 2220167 defendant Wodhorne William   661028 661028 Wodhorne, William, of Mumby 0
4563529 2220167 2220167 defendant Hamond William   661028 661028 Hamond, William, of Mumby 1
4563530 2220167 2220167 defendant Grave or Grane Alice   661028 661028 Grave or Grane, Alice, of Mumby, formerly wife of Robert 2
4563531 2220167 2220167 defendant Pery Robert   661028 661028 Pery, Robert, of Mumby 3
4661902 2249569 2249569 defendant Benet Simon husbandman 661028 661028 Benet, Simon, of Mumby, husbandman 0
4718606 2271158 2271158 defendant Chaumbre Thomas shoemaker 661028 661028 Chaumbre, Thomas, of Mumby, shoemaker 0
4775090 2288201 2288201 defendant Myculbarowe Robert husbandman 661028 661028 Myculbarowe, Robert, of Mumby, husbandman 3
4775091 2288201 2288201 defendant Wrangull Robert weaver 661028 661028 Wrangull, Robert, of Mumby, weaver 4
4793123 2293943 2293943 defendant Miculbarowe Robert husbandman 661028 661028 Miculbarowe, Robert, of Mumby, husbandman 3
4793124 2293943 2293943 defendant Wrangull Robert weaver 661028 661028 Wrangull, Robert, of Mumby, weaver 4
4855079 2312938 2312938 defendant Rihed Robert husbandman 661028 661028 Rihed, Robert, of Mumby, husbandman 0
4863923 2315692 2315692 plaintiff Pore John   661028 661028 Pore, John, of Mumby 1
4897082 2325743 2325743 defendant Ledebeter Stpehen   661028 661028 Ledebeter, Stpehen, of Mumby, lead beater 0
4929907 2335766 2335766 defendant Pore John, senior husbandman 661028 661028 Pore, John, senior, of Mumby, husbandman 0
4933773 2336941 2336941 defendant Gybson John husbandman 661028 661028 Gybson, John, of Mumby, husbandman 0
4933774 2336941 2336941 defendant Rape Robert husbandman 661028 661028 Rape, Robert, of Mumby, husbandman 1
4946874 2341029 2341029 defendant Porcher John husbandman 661028 661028 Porcher, John, of Mumby, husbandman 2
4959019 2344664 2344664 defendant Inglyssh William husbandman 661028 661028 Inglyssh, William, of Mumby, husbandman 1
4965691 2346663 2346663 defendant Broddyng Simon   661028 661028 Broddyng, Simon, of Mumby, "kydyer" 1
4971550 2348420 2348420 defendant Broddyng Simon husbandman 661028 661028 Broddyng, Simon, of Mumby, husbandman 0
4972945 2348832 2348832 defendant Gybson John husbandman 661028 661028 Gybson, John, of Mumby, husbandman 0
5001262 2357247 2357247 defendant Rowesyng Thomas husbandman 661028 661028 Rowesyng, Thomas, of Mumby, husbandman 2
5001497 2357328 2357328 defendant Delchaumbre Joan single woman 661028 661028 Delchaumbre, Joan, of Mumby, single woman 0
5081402 2380943 2380943 plaintiff Croude William   661028 661028 Croude, William, of Mumby 0
5095548 2385118 2385118 defendant Gybson William husbandman 661028 661028 Gybson, William, of Mumby, husbandman 0
5095549 2385118 2385118 defendant Gybson Robert husbandman 661028 661028 Gybson, Robert, of Mumby, husbandman 1
5095875 2385220 2385220 defendant Baker John husbandman 661028 661028 Baker, John, of Mumby, husbandman 0
5099458 2386277 2386277 defendant Andrewe John husbandman 661028 661028 Andrewe, John, of Mumby, husbandman 1
5142011 2398785 2398785 defendant Watkynson John husbandman 661028 661028 Watkynson, John, of Mumby, husbandman 0
5142012 2398785 2398785 defendant Watkynson William husbandman 661028 661028 Watkynson, William, of Mumby, husbandman 1
5191102 2413136 2413136 defendant Gibson John husbandman 661028 661028 Gibson, John, of Mumby, husbandman 1
5216100 2420440 2420440 plaintiff Crowede William   661028 661028 Crowede, William, of Mumby 0
5219094 2421311 2421311 defendant Crowed William husbandman 661028 661028 Crowed, William, of Mumby, husbandman 3
5242847 2428113 2428113 defendant Mekylberghe Thomas husbandman 661028 661028 Mekylberghe, Thomas, of Mumby, husbandman 0
5245301 2428784 2428784 defendant Pecher John husbandman 661028 661028 Pecher, John, of Mumby, husbandman 4
5247012 2429287 2429287 defendant Rusyng Thomas husbandman 661028 661028 Rusyng, Thomas, of Mumby, husbandman 3
5261756 2433785 2433785 defendant Mykelberghe Thomas husbandman 661028 661028 Mykelberghe, Thomas, of Mumby, husbandman 0
5272088 2436918 2436918 defendant Burton William husbandman 661028 661028 Burton, William, of Mumby, husbandman 0
5276949 2438337 2438337 defendant Goderyk John husbandman 661028 661028 Goderyk, John, of Mumby, husbandman 1
5352724 2460941 2460941 defendant Walton William gent 661028 661028 Walton, William, of Mumby, gent 0
5439482 2486743 2486743 defendant Smyre Robert   661028 661028 Smyre, Robert, of Mumby 0
5446587 2488868 2488868 defendant Wilkyns Walter husbandman 661028 661028 Wilkyns, Walter, of Mumby, husbandman 0
5446588 2488868 2488868 defendant Gibson John husbandman 661028 661028 Gibson, John, of Mumby, husbandman 1
5446589 2488868 2488868 defendant Mikelbergh Thomas yeoman 661028 661028 Mikelbergh, Thomas, of Mumby, yeoman 2
5459217 2492660 2492660 defendant Wilkyns Walter husbandman 661028 661028 Wilkyns, Walter, of Mumby, husbandman 0
5459218 2492660 2492660 defendant Gibson John husbandman 661028 661028 Gibson, John, of Mumby, husbandman 1
5479266 2498816 2498816 defendant Boog Thomas husbandman 661028 661028 Boog, Thomas, of Mumby, husbandman 0
5484430 2500260 2500260 defendant Mekylbarowe Thomas husbandman 661028 661028 Mekylbarowe, Thomas, of Mumby, husbandman 1
5519335 2510894 2510894 defendant Westbury William husbandman 661028 661028 Westbury, William, of Mumby, husbandman 1
5519336 2510894 2510894 defendant Morset William husbandman 661028 661028 Morset, William, of Mumby, husbandman 2
5610269 2546923 2546923 plaintiff atte Welle Robert   661028 661028 atte Welle, Robert, of Mumby, son of William 0
5610272 2546924 2546924 plaintiff atte Welle Robert   661028 661028 atte Welle, Robert, of Mumby, son of William 0
5610275 2546925 2546925 plaintiff atte Welle Robert   661028 661028 atte Welle, Robert, of Mumby, son of William 0
5615210 2548553 2548553 defendant Rumfer John chaplain 661028 661028 Rumfer, John, of Mumby, chaplain 0
5615211 2548553 2548553 defendant Davy Walter   661028 661028 Davy, Walter, of Mumby 1
5615212 2548553 2548553 defendant Caumel Gilbert   661028 661028 Caumel, Gilbert, of Mumby 2
5636018 2555221 2555221 defendant Wilkyns John husbandman 661028 661028 Wilkyns, John, of Mumby, 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);