A resource for Developers
building applications
using LexisNexis APIs

Azure Data Market - Community Data

Azure Data Market - Community Data

We have created a reference site with downloadable code examples to illustrate how you can use the ODATA API to retrieve our data from SQL Azure and display it on your website. You can find a link to the site at

http://www.lexisnexisstore.com/datamarket


Blogposts and Podcasts from the LexisNexis Online Communities ( http://www.lexisnexis.com/community/portal/ ) are now available through the Microsoft Azure DataMarket ( https://datamarket.azure.com/ ). The dataset includes LexisNexis and user generated content for a rolling six month period. This information is available at no cost through Azure DataMarket. This data may be displayed on your website as long as all LexisNexis branding remains in place and you agree to the terms and conditions of the LexisNexis Developer License Agreement.

 

DATA SET

 

The data set consists of "blogposts" and "podcasts" originally posted in the LexisNexis Communities. The previous six months of postings are included in the data yielding approximately 2500 blogposts and 500 podcasts on a variety of current legal topics. The data is contained in a single table accessible through Azure DataMarket. The table data is as follows:

 

Data Description Notes
Id Unique Identity 
Title Blog or Podcast Title
Link Link to the content online
MediaLink Link to podcast mp3 file
Extract Summary of the item First 150 characters of the item content
Content Full content of the item Entire content of the blogpost or podcast description
Author Author name
AuthorEmail Author email address
AuthorWeblink Author site url May be blank
DatePublished Date the item was published mm-dd-yyyy hh:mm:ss
ContentType Item type "blogpost" or "podcast"
CommunityName Community Long Name *** See below for listing
Keywords Tags
LexisID Permanent LexisID for the item Lexis identifier
CommunityAbbreviation Abbreviated Community Name *** See below for listing

 

Data in RED can be queried.

 

ITEM TYPES
blogpost
podcast 

 

COMMUNITY (LONG NAMES)
Corporate & Securities Law Community
Legal Business Community
Workers' Compensation Law Community Powered by Larson's
Real Estate Law Community
Estate Practice & Elder Law Community
Tax Law Community
International & Foreign Law Community
Immigration Law COmmunity
Patent Law Community
Copyright & Trademark Law Community
Litigation Resource Community
Environmental Law & Climate Change Community
Bankruptcy Law Community
Emerging Issues Law Community
Insurance Law Community
Legal Communities
Lexis Hub for New Attorneys
Labor & Employment Law Community 

 

COMMUNITY_SHORTNAME (searchable)
corpsec
legalbusiness
workerscomp
realestate
elder
tax
international
immigration
patent
copyrighttrademark
litigationresources
environment
 bankruptcy
emerging
insurance
legalcommunities
newattorneys
laboremployment 

 

SAMPLE QUERIES


select *  from consumer.dbo.gmes_community_content where charindex(‘blogpost’,item_type) > 0

select * from consumer.dbo.gmes_community_content where community_shortname = ‘patentlaw’

 

VISUALIZATIONS

The following is an example of a podcast post. A simple media listener has been inserted using the attachment address of the mp3 file. 

 

The following is an example of a typical blog post

 

Recent Comments

By: Marc Slovak Posted on Wed, Jul 6 2011 12:36 PM

Added Labor & Employment Law Community on July 6th, 2011

By: Marc Slovak Posted on Tue, Aug 30 2011 11:20 AM

We are retiring the Torts and Personal Injury Law Community. Most postings have been transitioned to the Litigation Resource Community. We are adding a new Immigration Law Community. When that is in place the documentation will be modified.

By: Marc Slovak Posted on Mon, Sep 26 2011 11:23 AM

Added new Immigration Law Community

By: bernard22 Posted on Wed, Jun 5 2013 6:55 AM

Thank you for keeping the listings up to date, and for providing the data for free.

Regards from Switzerland

Bernard

http://www.egga.ch