names

96 rows where place_id = 600843

✎ 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
3605956 1869525 1869525 plaintiff Lucas Peter (legal representative) 600843 600843 Lucas, Peter, of Witham, clothmaker, executors of 0
3642800 1908196 1908196 defendant Cristemas John weaver 600843 600843 Cristemas, John, of Witham, weaver 0
3732959 1936531 1936531 defendant Howlet Hugh yeoman 600843 600843 Howlet, Hugh, of Witham Halse Hunder, yeoman 0
3806448 1959930 1959930 defendant Molyners William gent 600843 600843 Molyners, William, of Witham, gent 0
3823543 1965265 1965265 defendant Reydon Christopher gent 600843 600843 Reydon, Christopher, of Witham, gent 0
3823544 1965265 1965265 defendant Raven Christopher tailor 600843 600843 Raven, Christopher, of Witham, tailor 1
3824540 1965547 1965547 defendant Harrys Robert fuller 600843 600843 Harrys, Robert, of Witham, fuller 0
4128657 2070542 2070542 defendant Hill John laborer 600843 600843 Hill, John, of Witham, laborer 1
4152072 2078835 2078835 defendant Kenderdale Richard husbandman 600843 600843 Kenderdale, Richard, of Witham, husbandman 0
4246589 2111834 2111834 defendant Garrard Jerome yeoman 600843 600843 Garrard, Jerome, of Witham, yeoman 0
4279858 2122869 2122869 defendant Fearne William yeoman 600843 600843 Fearne, William, of Witham, yeoman 3
4281406 2123403 2123403 defendant Bruff or Broughe William gent 600843 600843 Bruff or Broughe, William, of Witham, gent 0
4281407 2123403 2123403 defendant Savell John yeoman 600843 600843 Savell, John, of Witham, yeoman 1
4281408 2123403 2123403 defendant Norris Nicholas laborer 600843 600843 Norris, Nicholas, of Witham, laborer 2
4281409 2123403 2123403 defendant Rogers Jerome mariner 600843 600843 Rogers, Jerome, of Witham, mariner 3
4281522 2123440 2123440 defendant Keyghtley Michael draper 600843 600843 Keyghtley, Michael, of Witham, draper 0
4282131 2123653 2123653 defendant Keightley Michael draper 600843 600843 Keightley, Michael, of Witham, draper 0
4301172 2130528 2130528 defendant Halyn Richard clothier 600843 600843 Halyn, Richard, of Witham, clothier 2
4317592 2136267 2136267 defendant Keightley Thomas clothier 600843 600843 Keightley, Thomas, of Witham, clothier 2
4317593 2136267 2136267 defendant Fearne William innholder 600843 600843 Fearne, William, of Witham, innholder 3
4454790 2186509 2186509 plaintiff Mariot John, junior   600843 600843 Mariot, John, junior, of Witham 0
4492751 2198433 2198433 defendant Maygode William   600843 600843 Maygode, William, of Witham 0
4498005 2200021 2200021 defendant Maygode William   600843 600843 Maygode, William, of Witham 0
4607574 2233476 2233476 defendant Brise Thomas   600843 600843 Brise, Thomas, of Witham 6
4652543 2246750 2246750 defendant Bircheleigh Thomas   600843 600843 Bircheleigh, Thomas, of Witham 0
4683161 2260350 2260350 defendant Man John husbandman 600843 600843 Man, John, of Witham, husbandman 0
4683162 2260350 2260350 defendant P--lle Robert husbandman 600843 600843 P--lle, Robert, of Witham, husbandman 1
4696987 2264535 2264535 plaintiff Child Thomas   600843 600843 Child, Thomas, of Witham 0
4711265 2268869 2268869 defendant Herde Thomas   600843 600843 Herde, Thomas, of Witham, husb 2
4711268 2268869 2268869 defendant Bryd Edmund husbandman 600843 600843 Bryd, Edmund, of Witham, husbandman 5
4711270 2268869 2268869 defendant Mallere William   600843 600843 Mallere, William, of Witham, husb 7
4711273 2268869 2268869 defendant Vynter William laborer 600843 600843 Vynter, William, of Witham, laborer 10
4711289 2268870 2268870 defendant Herde Thomas husbandman 600843 600843 Herde, Thomas, of Witham, husbandman 2
4711292 2268870 2268870 defendant Bryd Edmund husbandman 600843 600843 Bryd, Edmund, of Witham, husbandman 5
4711293 2268870 2268870 defendant Pultere Thomas husbandman 600843 600843 Pultere, Thomas, of Witham, husbandman 6
4711294 2268870 2268870 defendant Mellere William husbandman 600843 600843 Mellere, William, of Witham, husbandman 7
4711297 2268870 2268870 defendant Vynter William laborer 600843 600843 Vynter, William, of Witham, laborer 10
4711312 2268871 2268871 defendant Herde Thomas husbandman 600843 600843 Herde, Thomas, of Witham, husbandman 1
4711315 2268871 2268871 defendant Bryd Edmund husbandman 600843 600843 Bryd, Edmund, of Witham, husbandman 4
4711316 2268871 2268871 defendant Pultere Thomas husbandman 600843 600843 Pultere, Thomas, of Witham, husbandman 5
4711320 2268871 2268871 defendant Vynter William laborer 600843 600843 Vynter, William, of Witham, laborer 9
4715294 2270116 2270116 defendant Herde John butcher 600843 600843 Herde, John, of Witham, butcher 2
4715295 2270116 2270116 defendant Pye John butcher 600843 600843 Pye, John, of Witham, butcher 3
4721906 2272183 2272183 plaintiff Chyld Thomas   600843 600843 Chyld, Thomas, of Witham 0
4735649 2276299 2276299 defendant Mercer William mercer 600843 600843 Mercer, William, of Witham, mercer 0
4741668 2278055 2278055 defendant Hierde John yeoman 600843 600843 Hierde, John, of Witham, yeoman 0
4745198 2279102 2279102 plaintiff Frende John   600843 600843 Frende, John, of Witham 0
4745199 2279102 2279102 plaintiff Warner John   600843 600843 Warner, John, of Witham 1
4745202 2279103 2279103 plaintiff Frende John   600843 600843 Frende, John, of Witham 0
4745203 2279103 2279103 plaintiff Warner John   600843 600843 Warner, John, of Witham 1
4762639 2284294 2284294 defendant Lylye Geoffrey husbandman 600843 600843 Lylye, Geoffrey, of Witham, husbandman 1
4788784 2292549 2292549 defendant Trippe William butcher 600843 600843 Trippe, William, of Witham, butcher 2
4821562 2302826 2302826 defendant Couper Richard carpenter 600843 600843 Couper, Richard, of Witham, carpenter 1
4903769 2327798 2327798 defendant Basset Thomas gent 600843 600843 together with Basset, Thomas, of Witham, gent 2
4903771 2327799 2327799 defendant Basset Thomas gent 600843 600843 Basset, Thomas, of Witham, gent 0
5011277 2360156 2360156 defendant Welde Thomas fuller 600843 600843 Welde, Thomas, of Witham, fuller 1
5109970 2389345 2389345 plaintiff Graveley William fuller 600843 600843 Graveley, William, of Witham, fuller 0
5109971 2389345 2389345 defendant Sayer Andrew yeoman 600843 600843 Sayer, Andrew, of Witham, yeoman 0
5131760 2395774 2395774 plaintiff Gravele William fuller 600843 600843 Gravele, William, of Witham, fuller 0
5218852 2421237 2421237 defendant Bygelond John butcher 600843 600843 Bygelond, John, of Witham, butcher 1
5223467 2422556 2422556 defendant Dyer Robert dyer 600843 600843 Dyer, Robert, of Witham, dyer 3
5261623 2433743 2433743 defendant Wright Thomas husbandman 600843 600843 Wright, Thomas, of Witham, husbandman 2
5292624 2442840 2442840 defendant Warner Thomas yeoman 600843 600843 Warner, Thomas, of Witham, yeoman 0
5303368 2446003 2446003 defendant Smyth John fuller 600843 600843 Smyth, John, of Witham, fuller 2
5344928 2458572 2458572 defendant Sterlyng Robert fuller 600843 600843 Sterlyng, Robert, of Witham, fuller 1
5375896 2468052 2468052 defendant Snowe Thomas smith 600843 600843 Snowe, Thomas, of Witham, smith 5
5403763 2476151 2476151 defendant Broke John gent 600843 600843 Broke, John, of Witham, gent 0
5427492 2483173 2483173 defendant Forster William husbandman 600843 600843 Forster, William, of Witham, husbandman 0
5427494 2483174 2483174 defendant Gryme Richard husbandman 600843 600843 Gryme, Richard, of Witham, husbandman 0
5427496 2483175 2483175 defendant Smyth John husbandman 600843 600843 Smyth, John, of Witham, husbandman 0
5445233 2488466 2488466 defendant Forster William husbandman 600843 600843 Forster, William, of Witham, husbandman 0
5445235 2488467 2488467 defendant Gynns Richard   600843 600843 Gynns, Richard, of Witham 0
5445237 2488468 2488468 defendant Smyth John husbandman 600843 600843 Smyth, John, of Witham, husbandman 0
5457921 2492269 2492269 defendant Forster William husbandman 600843 600843 Forster, William, of Witham, husbandman 0
5457923 2492270 2492270 defendant Gyme Richard husbandman 600843 600843 Gyme, Richard, of Witham, husbandman 0
5457925 2492271 2492271 defendant Smyth John husbandman 600843 600843 Smyth, John, of Witham, husbandman 0
5462469 2493678 2493678 defendant Greye John dyer 600843 600843 Greye, John, of Witham, dyer 1
5469713 2495869 2495869 defendant Gyme Richard husbandman 600843 600843 Gyme, Richard, of Witham, husbandman 0
5475069 2497530 2497530 defendant Rythere Richard turner 600843 600843 Rythere, Richard, of Witham, turner 0
5500819 2505188 2505188 defendant Howelat Robert butcher 600843 600843 Howelat, Robert, of Witham, butcher 0
5500820 2505188 2505188 defendant Houlman Robert laborer 600843 600843 Houlman, Robert, of Witham, laborer 1
5500821 2505188 2505188 defendant Mennse or Menuse Thomas laborer 600843 600843 Mennse or Menuse, Thomas, of Witham, laborer 2
5502686 2505757 2505757 defendant Pagett John husbandman 600843 600843 Pagett, John, of Witham, husbandman 0
5525745 2512641 2512641 defendant Braxsted John butcher 600843 600843 Braxsted, John, of Witham, butcher 0
5539734 2516907 2516907 defendant Chylde John yeoman 600843 600843 Chylde, John, of Witham, yeoman 5
5541774 2517540 2517540 defendant Heed John yeoman 600843 600843 Heed, John, of Witham, yeoman 0
5548231 2519511 2519511 plaintiff Aphowell John   600843 600843 Aphowell, John, of Witham 0
5548233 2519511 2519511 defendant Watton Thomas chaplain 600843 600843 Watton, Thomas, of Witham, chaplain 0
5559316 2522693 2522693 defendant Quyk John yeoman 600843 600843 Quyk, John, of Witham, yeoman 5
5568475 2525328 2525328 defendant Hardyng Thomas, junior husbandman 600843 600843 Hardyng, Thomas, junior, of Witham, husbandman 0
5568476 2525328 2525328 defendant Bedfeld John tailor 600843 600843 Bedfeld, John, of Witham, tailor 1
5568477 2525328 2525328 defendant Bateman John laborer 600843 600843 Bateman, John, of Witham, laborer 2
5578235 2528263 2528263 defendant Brigge John husbandman 600843 600843 Brigge, John, of Witham, husbandman 1
5578743 2528415 2528415 defendant Harrys John yeoman 600843 600843 Harrys, John, of Witham, yeoman 0
5579634 2528714 2528714 defendant Chyld John yeoman 600843 600843 Chyld, John, of Witham, yeoman 0
5584906 2530358 2530358 defendant Nicoll Edward fuller 600843 600843 Nicoll, Edward, of Witham, fuller 2

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);