names

63 rows where place_id = 595587

✎ 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
3621110 1874159 1874159 defendant Grene William husbandman 595587 595587 Grene, William, of North Kelsey, husbandman 0
3639312 1907105 1907105 defendant Maynman Thomas tailor 595587 595587 Maynman, Thomas, of North Kelsey, tailor 0
3892113 1987614 1987614 defendant Benson Richard husbandman 595587 595587 Benson, Richard, of North Kelsey, husbandman 0
3913079 1994704 1994704 defendant Cantys Thomas carpenter 595587 595587 Cantys, Thomas, of North Kelsey, carpenter 0
3962426 2011447 2011447 plaintiff Wentworth William gent 595587 595587 Wentworth, William, of North Kelsey, gent 0
3962428 2011448 2011448 plaintiff Wentworth William gent 595587 595587 Wentworth, William, of North Kelsey, gent 0
4007463 2027453 2027453 plaintiff Marrys John yeoman 595587 595587 Marrys, John, of North Kelsey, yeoman 0
4025640 2033822 2033822 defendant Teffe Thomas husbandman 595587 595587 Teffe, Thomas, of North Kelsey, husbandman 0
4044154 2040363 2040363 defendant Broxolme Richard yeoman 595587 595587 Broxolme, Richard, of North Kelsey, yeoman 0
4068791 2049128 2049128 defendant Tesse Thomas husbandman 595587 595587 Tesse, Thomas, of North Kelsey, husbandman 0
4068793 2049129 2049129 defendant Tesse Thomas husbandman 595587 595587 Tesse, Thomas, of North Kelsey, husbandman 0
4070273 2049662 2049662 plaintiff Marris John yeoman 595587 595587 Marris, John, of North Kelsey, yeoman 0
4074200 2051072 2051072 plaintiff Pye John husbandman 595587 595587 Pye, John, of North Kelsey, husbandman 0
4087199 2055711 2055711 defendant Mounson Alexander (legal representative) 595587 595587 Mounson, Alexander, of North Kelsey, gent, administrator of 0
4106019 2062443 2062443 defendant Browne John laborer 595587 595587 Browne, John, of North Kelsey, laborer 0
4131255 2071497 2071497 defendant Teffe William husbandman 595587 595587 Teffe, William, of North Kelsey, husbandman 0
4133337 2072246 2072246 defendant Robinson William yeoman 595587 595587 Robinson, William, of North Kelsey, yeoman 0
4133338 2072246 2072246 defendant White Robert husbandman 595587 595587 White, Robert, of North Kelsey, husbandman 1
4136251 2073310 2073310 defendant Teffe William husbandman 595587 595587 Teffe, William, of North Kelsey, husbandman 0
4141889 2075331 2075331 defendant Teffe William husbandman 595587 595587 Teffe, William, of North Kelsey, husbandman 0
4160535 2081759 2081759 defendant Teffe William husbandman 595587 595587 Teffe, William, of North Kelsey, husbandman 0
4162334 2082386 2082386 defendant Higget James husbandman 595587 595587 Higget, James, of North kelsey, husbandman 1
4166850 2083902 2083902 defendant Teffe William husbandman 595587 595587 Teffe, William, of North Kelsey, husbandman 0
4219276 2102237 2102237 defendant Marris John yeoman 595587 595587 Marris, John, of North Kelsey, yeoman 0
4257339 2115430 2115430 defendant Marris John yeoman 595587 595587 Marris, John, of North Kelsey, yeoman 0
4274715 2121101 2121101 defendant Edwardes Charles husbandman 595587 595587 Edwardes, Charles, of North Kelsey, husbandman 0
4276860 2121834 2121834 defendant Edwards Charles yeoman 595587 595587 Edwards, Charles, of North Kelsey, yeoman 0
4280020 2122923 2122923 defendant Brokelsbye John yeoman 595587 595587 Brokelsbye, John, of North kelsey, yeoman 1
4283174 2124015 2124015 defendant Edward Charles husbandman 595587 595587 Edward, Charles, of North Kelsey, husbandman 0
4283190 2124021 2124021 defendant Marrys John husbandman 595587 595587 Marrys, John, of North Kelsey, husbandman 0
4289942 2126465 2126465 defendant Edward Joan widow 595587 595587 Edward, Joan, of North Kelsey, or of Helmesall, Kirkbie, Yorks, widow 0
4289943 2126465 2126465 defendant Edward Charles yeoman 595587 595587 Edward, Charles, of North Kelsey, yeoman 1
4291604 2127074 2127074 defendant Robynson Simon (legal representative) 595587 595587 Robynson, Simon, of North Kelsey, yeoman, administrator of 0
4338041 2143046 2143046 defendant Edward Charles yeoman 595587 595587 Edward, Charles, of North Kelsey, yeoman 0
4355272 2149064 2149064 defendant Edward Charles yeoman 595587 595587 Edward, Charles, of North Kelsey, yeoman 0
4357646 2149908 2149908 defendant Beard George gent 595587 595587 Beard, George, of North Kelsey, gent 0
4357647 2149908 2149908 defendant Beard Tristram gent 595587 595587 Beard, Tristram, of North Kelsey, gent 1
4359413 2150527 2150527 defendant Fenbie John yeoman 595587 595587 Fenbie, John, of North Kelsey, yeoman 0
4374304 2155879 2155879 defendant Edward Charles husbandman 595587 595587 Edward, Charles, of North Kelsey, husbandman 3
4379822 2157880 2157880 defendant Benson Richard yeoman 595587 595587 Benson, Richard, of North Kelsey, yeoman 0
4478650 2193987 2193987 plaintiff Higdon Thomas   595587 595587 Higdon, Thomas, of North Kelsey 0
4510897 2203862 2203862 defendant Chapman John   595587 595587 Chapman, John, of North Kelsey 4
4620795 2237486 2237486 defendant Redemere William   595587 595587 Redemere, William, of North Kelsey 0
4630261 2240375 2240375 plaintiff Stepyng Henry   595587 595587 Stepyng, Henry, of North Kelsey 0
4651135 2246358 2246358 defendant Hikdon Thomas husbandman 595587 595587 Hikdon, Thomas, of North Kelsey, husbandman 0
4673188 2257254 2257254 defendant Burde John gent 595587 595587 Burde, John, of North Kelsey, gent 1
5065008 2376065 2376065 defendant Barde John gent 595587 595587 Barde, John, of North Kelsey, gent 0
5065009 2376065 2376065 defendant Hygdon John husbandman 595587 595587 Hygdon, John, of North Kelsey, husbandman 1
5114137 2390534 2390534 defendant Waycke William husbandman 595587 595587 Waycke, William, of North Kelsey, husbandman 1
5135736 2396963 2396963 defendant Douce Alice widow 595587 595587 Douce, Alice, of North Kelsey, widow 0
5156005 2402912 2402912 defendant Douce Elizabeth widow 595587 595587 Douce, Elizabeth, of North Kelsey, widow 0
5172341 2407636 2407636 defendant Douce Elizabeth widow 595587 595587 Douce, Elizabeth, of North Kelsey, widow 0
5191759 2413327 2413327 defendant Donce Elizabeth widow 595587 595587 Donce, Elizabeth, of North Kelsey, widow 0
5422841 2481785 2481785 defendant Hall William husbandman 595587 595587 Hall, William, of North Kelsey, husbandman 4
5427450 2483158 2483158 defendant Hygdon William yeoman 595587 595587 Hygdon, William, of North Kelsey, yeoman 1
5442316 2487622 2487622 defendant Hall William husbandman 595587 595587 Hall, William, of North Kelsey, husbandman 4
5445200 2488456 2488456 defendant Hygdon William   595587 595587 Hygdon, William, of North Kelsey 1
5457889 2492257 2492257 defendant Hygdon William yeoman 595587 595587 Hygdon, William, of North Kelsey, yeoman 1
5469694 2495861 2495861 defendant Hygdon William yeoman 595587 595587 Hygdon, William, of North Kelsey, yeoman 1
5531312 2514313 2514313 defendant Hygdon Adam husbandman 595587 595587 Hygdon, Adam, of North Kelsey, husbandman 0
5531313 2514313 2514313 defendant Colyn Simon husbandman 595587 595587 Colyn, Simon, of North Kelsey, husbandman 1
5587428 2531086 2531086 defendant Munson John esq 595587 595587 Munson, John, of North Kelsey, esq 0
5635160 2554974 2554974 defendant Barde John   595587 595587 Barde, John, of North Kelsey 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);